Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Query\Report

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

Hi,

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]

FROM
dbo.Inv_AeX_AC_Identification,
dbo.Inv_AeX_AC_TCPIP,
dbo.Inv_SW_BIOS_Element

WHERE
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid

SOLUTION
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.

Regards

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?

Thanks.

rs_cert's picture

Thanks for providing the query and report location