SQL Query for Computer IP Address and MAC Address - Inventory Report
Created: 17 Dec 2008 • Updated: 17 Dec 2008
The following is the SQL query based reports to fetch details like Computer Name, OS Name, OS Version, Domain, IP Address and MAC Address from Altiris Inventory.
----------- Begin of Code --------- SELECT DISTINCT V1.[Name] AS 'Computer Name', V1.[OS Name], V1.[OS Version], V1.[Domain], V1.[IP Address], V1.[MAC Address] FROM vComputer V1 JOIN Inv_AeX_AC_Identification ID ON V1.GUID = ID._ResourceGUID AND V1.[Domain]=ID.[Domain] Order by V1.[Name] ----------- End of Code ---------
One can exclude OS Name, OS Version, if this information is not needed.
By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License
|Support:||User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab.|