SQL Query Report to Display Outlook Profiles Information on a Given Machine

The following are the SQL query based reports to fetch Outlook Profiles information from Altiris Inventory based on machine name.

--------------------------------------------------------Query 1:

SELECT [Profile],[Default Profile],[Exchange Display Name] as [Name],[Office Telephone] as [Telephone],[Custom Attribute 2] as [Site Code]
FROM [Inv_AeX_EU_Contact_Detail] AEC
JOIN [Inv_Aex_AC_Identification] ACI ON ACI.[_ResourceGuid] = AEC.[_ResourceGuid]
WHERE ACI.[Name] = 'Enter Machine name here'
--------------------------------------------------------Query 2:

SELECT [Profile],[Item],[Source],[Service]
FROM [Inv_Mon_Eu_Mail_Profile] AEM
JOIN [Inv_Aex_AC_Identification] ACI ON ACI.[_ResourceGuid] = AEM.[_ResourceGuid]
WHERE ACI.[Name] = 'Enter machine name here'

--------------------------------------------------------
If don't know the machine name and you know the user name, here the query to get machine name based on user name:

SELECT DISTINCT(vComputer.[Name]) AS 'Machine Name', PU.[User], ACI.[Domain] AS 'Domain'      
FROM vComputer        
INNER JOIN inv_aex_ac_primary_user PU ON PU._ResourceGuid = vComputer.Guid        
JOIN [Inv_AeX_AC_Identification] ACI ON ACI.[_ResourceGuid] = vComputer.Guid   
JOIN [Inv_Mon_SM_Machine_Locale] OU ON OU.[_ResourceGuid] = ACI.[_ResourceGuid]   
JOIN [Inv_Global_Active_Directory_Details] AD ON AD.[_ResourceGuid] = ACI.[_ResourceGuid]    
JOIN Inv_AeX_AC_TCPIP IP    
ON IP._ResourceGuid = ACI._ResourceGuid   
WHERE PU.[Month] = datename(month, getdate())   
AND UPPER(PU.[User]) IN ('Enter user name here') 
ORDER BY PU.[User]
--------------------------------------------------------

See below image for sample report result:

Click to view.