Client Management Suite

This is the query to create the report for Machines with Altiris Agent Installed along with their IP addresses.

SELECT vc.[Name], vc.Domain, vc.[IP Address], vc.[OS Name], vc.[isManaged], vc.[Guid]
FROM vComputer vc
WHERE vc.[Guid] IN
                      (
   SELECT DISTINCT agent.[_ResourceGuid]
                        FROM Inv_AeX_AC_Client_Agent agent
   WHERE agent.[Agent Name]='Altiris Agent'
                            OR agent.[Agent Name]='Altiris eXpress NS Client'
                       )
AND
   (
     LOWER(vc.[OS Name]) LIKE '%windows 2000%'
     OR LOWER(vc.[OS Name]) LIKE '%server 2003%'
     OR LOWER(vc.[OS Name]) LIKE '%2008%'
     OR LOWER(vc.[OS Name]) LIKE '%vista%'
     OR LOWER(vc.[OS Name]) LIKE '%windows xp%'
     OR LOWER(vc.[OS Name]) LIKE '%windows%'
   )
AND LOWER(vc.[System Type]) like '%win%'
AND vc.[IsLocal] = 1
order by [IP Address]