A community member wanted to be able to identify machines that are not running the latest version of the SMA so that they could then email the user to inform them that they needed to connect to the network in order to bring their machine into compliance with corporate standards.
Although there is probably a cleaner way to achieve this by using a similar method as the agent upgrade filter, the following two queries fulfil the requirement:
1. Run this query to find out what the latest version of the SMA is in the environment (the SMA upgrade policy needs to be enabled and at least one computer must have been upgraded for this to work):
SELECT DISTINCT [Product Version] FROM Inv_AeX_AC_Client_Agent WHERE [Agent Name] = 'Altiris Agent'
2. Run this query to find the users email address
SELECT vu.Email FROM vUser vu JOIN Inv_AeX_AC_Primary_User pu ON pu.[User] = vu.Name JOIN Inv_AeX_AC_Client_Agent ca ON ca._ResourceGuid = pu._ResourceGuid WHERE ca.[Agent Name] = 'Altiris Agent' AND ca.[Product Version] < 'enter latest version here'
Here you go:
SELECT i.Name AS Hostname,vu.Email FROM vUser vu
JOIN Inv_AeX_AC_Primary_User pu ON pu.[User] = vu.Name
JOIN Inv_AeX_AC_Client_Agent ca ON ca._ResourceGuid = pu._ResourceGuid
JOIN Inv_AeX_AC_Identification i ON i._ResourceGuid = ca._ResourceGuid
WHERE ca.[Agent Name] = 'Altiris Agent'
AND ca.[Product Version] < 'enter latest version here'
Hi , can we get hostnames also in this report ?
Regards