Page 1 of 1

SQL query

PostPosted: Thu Jan 17, 2013 3:03 pm
by Apu
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 =
INNER JOIN Inv_Network_Adapters ON Inv_Workstations.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.

Re: SQL query

PostPosted: Fri Jan 02, 2015 4:10 pm
by Dan Stuckey
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.