SQL Query for Computer Details Inventory Report

The following is the SQL query based reports to fetch Information like Computer Name, Location(Domain) , OS Details Like (OS Name, OS Type,OS Revision), Processor details like(CPU Type, CPU Speed, CPU Count) Computer Model details like(Manufacturer, Computer Model) from Altiris Inventory.

----------------------------------

SELECT DISTINCT 
-- Computer Name And Location    
AI.[Name] as [Computer Name],           
AI.[Domain] AS [Computer Domain],      
 -- OS Details
AI.[OS Name] AS [OS Name],      
AI.[OS Type] AS [OS Type],      
AI.[OS Revision] AS [OS Revision],      
AI.[System Type],     
 -- Processor  
CPU.[Type] AS 'CPU Type', 
CPU.[Speed] AS 'CPU Speed',  
CPU.[Number] AS 'CPU Count', 
 -- Computer Model  
HMDL.[Manufacturer] AS [Manufacturer],  
HMDL.[Model] AS [Computer Model]  
  
FROM      
dbo.Inv_AeX_AC_Identification AS AI      
LEFT OUTER JOIN [Inv_AeX_HW_CPU] AS CPU 
ON AI.[_ResourceGuid] = CPU.[_ResourceGuid]      
LEFT OUTER JOIN [Inv_Mon_HW_Computer_Model] AS HMDL  
ON AI.[_ResourceGuid] = HMDL.[_ResourceGuid] 

ORDER BY AI.[Name] ASC

----------------------------------

Thanks,
Sid