SQL query

Open discussion about the Alloy Navigator 6 Asset Management

SQL query

Postby Apu on Thu Jan 17, 2013 3:03 pm

I need to get MAC addresses for all of the computers in our inventory.

When we used Alloy Navigator 5, the following query got me what I needed...
Code: Select all
SELECT Computers.Name, Inv_Network_Adapters.MAC_Address
FROM Computers
INNER JOIN Inv_Workstations ON Computers.ID =
  Inv_Workstations.Computer_ID
INNER JOIN Inv_Network_Adapters ON Inv_Workstations.ID =
  Inv_Network_Adapters.Workstation_ID
WHERE Computers.Retired = 0
ORDER BY Computers.Name


Now using Alloy Navigator 6, I'm not seeing the equivalent tables. The best I have so far is

Code: Select all
SELECT     Name, MAC
FROM       Computers
ORDER BY Computers.Name


but that does not get me all of the MAC addresses for a given computer. For example, if a laptop has a wireless NIC and an Ethernet port, I'll get one of the two but not both.

Any help is appreciated.
Apu
Newbie
 
Posts: 1
Joined: Thu Jan 17, 2013 12:58 pm

Re: SQL query

Postby Dan Stuckey on Fri Jan 02, 2015 4:10 pm

It looks like Alloy Discovery 6 database stores all detected MAC Addresses while Alloy Navigator 6 keeps only one MAC Address.

I would query the Inv_Network_Adapters table of Alloy Discovery 6 database.
Dan Stuckey
Junior
 
Posts: 6
Joined: Wed Sep 02, 2009 5:21 pm


Return to Alloy Navigator 6 Asset Management Discussion

Who is online

Users browsing this forum: No registered users and 2 guests

cron