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

admin_sepm

SQL Query\Report - Comment:15 Mar 2013 : Link

Check this one thread, may be help you to

https://www-secure.symantec.com/connect/forums/sql-report-cms71-add-ip-address-report

Thanks.

admin_sepm

SQL Query\Report - Comment:16 Mar 2013 : Link

other link for your help to view the report

https://www-secure.symantec.com/connect/forums/altiris-hardware-inventory-report-show-memory-type-column

----Edit----

https://www-secure.symantec.com/connect/forums/system-configuratin-report

Thanks.

Sumit G Partner

SQL Query\Report - Comment:17 Mar 2013 : Link

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.