Ability to identify computers not in a patch policy

[DHeinz57]

Back in Altiris 6.x, I found a SQL query that would identify servers that were NOT part of a patching policy (see code below).

Is there an equivilent report or SQL query for the ITMS environment?

Thanks!

 

**********************************************************************************************

select vc.[name], vc.[domain], vc.[User], vc.[IP Address], vc.[OS Name]                      
from vComputer vC      
WHERE Guid IN (      
       SELECT  a._ResourceGuid AS Guid       
        FROM    Inv_AeX_AC_Client_Agent a       
                INNER JOIN vComputer c ON c.Guid = a._ResourceGuid       
        WHERE   a.[Agent Name] = 'Altiris Software Update Agent'       
                AND a._ResourceGuid NOT IN (       
                SELECT  pr.ResourceGuid       
                FROM    vItem i       
                        INNER JOIN vPolicyAppliesToResource pr ON pr.PolicyGuid = i.Guid       
                WHERE   i.ClassGuid = '5e5bde22-c290-4a94-a36c-c5076da6d565'       
                        AND CollectionGuid <> 'b6a61e53-bcca-4336-b15a-8fd2975f67c9' )       
                AND Guid IN (       
                SELECT  [_ResourceGuid]       
                FROM    [Inv_AeX_OS_System]       
                WHERE   [Inv_AeX_OS_System].[System Type] IN ( 'Server',       
                                                              'Advanced Server',       
                                                              'Domain Controller' ) )       
       
                AND CAST(a.[Build Number] AS INT) >= 2437  -- 6.2 GA agent build number        
        GROUP BY a._ResourceGuid )      
order by vc.[name]

[SK]

Try this:  https://www-secure.symantec.com/connect/forums/sql-query-show-what-tasks-are-assigned-each-collection