SQL Query for OS and Hardware Inventory Report of Unix System

The following is the SQL query based reports to fetch Information like Machine Name, OS Name, Processor Type, Processor Speed, Physical Memory, SerIial Number, Model from Altiris Inventory for Unix system.

SELECT DISTINCT 
IAI.[Name] AS 'Machine Name', 
IAI.[System Type] AS 'System Type', 
IAI.[OS Name] AS 'OS Name', 
IAI.[OS Type] AS 'OS Type', 
IAI.[OS Version] AS 'OS Version', 
IAI.[OS Revision] AS 'OS Revision', 
IUM.[Physical Memory] AS 'Physical Memory', 
IUP.[Type] AS 'Processor Type', 
IUP.[Speed] AS 'Processor Speed', 
IUS.[Onboard Serial Number] As 'Serial Number', 
IUS.[Model] As 'Model' 
 
FROM [Inv_AeX_AC_Identification] IAI 
LEFT OUTER JOIN [Inv_Unix_Memory] IUM 
ON IAI.[_ResourceGuid] = IUM.[_ResourceGuid] 
LEFT OUTER JOIN [Inv_Unix_Processor] IUP 
ON IAI.[_ResourceGuid] = IUP.[_ResourceGuid] 
JOIN [Inv_Unix_SystemID] IUS 
ON IAI.[_ResourceGuid] = IUS.[_ResourceGuid]

Thanks,
Sid