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.