Video Screencast Help

SQL Query\Report

Created: 14 Mar 2013 • Updated: 17 Apr 2013 | 10 comments
This issue has been solved. See solution.


I want the below detail from Altiris. Any report/sql query to find it

Require Detail- User Name, OS, System Type, BIOS Version, IP

Comments 10 CommentsJump to latest comment

Sachin Sawant's picture

kindly check below query,

SELECT dbo.Inv_AeX_AC_Identification.[Name][Host Name]
, dbo.Inv_AeX_AC_Identification.[Os Name]
, dbo.Inv_AeX_AC_Identification.[System Type]
, dbo.Inv_AeX_AC_Identification.[Last Logon User]
, dbo.Inv_AeX_AC_TCPIP.[MAC Address]
, dbo.Inv_AeX_AC_TCPIP.[IP Address]
, dbo.Inv_SW_BIOS_Element.[Version][BIOS Version]


AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid

Sumit G's picture

Check the step

1 In the Symantec Management Console, on the "Reports" menu, click "All Reports".
2 In the left pane, under "Reports", expand Discovery and Inventory > Inventory > Cross-platform > Operating System.
3 In the left pane, under "Operating System", click the "Computer Summary" report.

Report will be reflect in right hand panel, Choose saveas to save the file in any of the format which you required.


Sumit G.

rs_cert's picture

hello sachin,

have you tried this one?

Sachin Sawant's picture

Yes, rs_cert and this query working properly in my office, if you any challenges and query pls revert....

Sachin Sawant's picture

Please find screen short of the same.

query screen short.jpg
consoleadmin's picture

Have you tried my above attached?


rs_cert's picture

Thanks for providing the query and report location