SQL Query for User Details - Inventory Report

The following is the SQL query based reports to fetch user details like User ID, First Name, Middle Name, Last Name, Domain, Site Code, Location and Country from Altiris Inventory.

----------- Begin of Code ---------


SELECT DISTINCT
VCO.GUID AS [_Guid],
VCO.[user] AS [User ID], 
ExD.[Given Name] AS 'First Name', 
ExD.[Initials] AS 'Middle Name', 
ExD.[Surname] AS 'Last Name', 
VCO.Domain AS [Domain], 
ML.SiteCode AS [Site Code], 
ML.SiteTitle AS [Location], 
ML.Country      

From vComputer VCO
Join Inv_Mon_SM_Machine_Locale ML       
On VCO.GUID = ML._resourceGUID       
Join dbo.Inv_AeX_EU_Contact_Detail ExD
On VCO.GUID = ExD._resourceGUID AND VCO.[user] = ExD.[Account]
Join Inv_AeX_AC_Identification AI      
On VCO.GUID = AI._ResourceGUID      

Order by ML.SiteCode


----------- End Of Code ---------

Thanks,
Sid