Is there a report to run to view machines that are targeted by more than one Default Software Update Agent Configuration Policy?

Article:HOWTO21596  |  Created: 2010-02-10  |  Updated: 2012-10-10  |  Article URL http://www.symantec.com/docs/HOWTO21596
Article Type
How To



Question
Is there a report to run to view machines that are targeted by more than one Default Software Update Agent Configuration Policy?

Answer
Please run the following SQL Script on the SQL Server, against the Altiris Database, with Application Identity credentials.

 

SELECT

      vc.Name AS 'Computer Name',

      i.Name AS 'Software Update Agent Configuration Policy'

FROM vComputer vc

      JOIN vPolicyAppliesToResource pr ON pr.ResourceGuid = vc.Guid

            AND pr.Enabled = '1'

      JOIN vItem i ON i.Guid = pr.PolicyGuid  

            AND i.ClassGuid = '5e5bde22-c290-4a94-a36c-c5076da6d565'

WHERE vc.Guid IN

            (

            SELECT vc.Guid

            FROM vComputer vc

                  JOIN vPolicyAppliesToResource pr ON pr.ResourceGuid = vc.Guid

                        AND pr.Enabled = '1'

                  JOIN vItem i ON i.Guid = pr.PolicyGuid  

                        AND i.ClassGuid = '5e5bde22-c290-4a94-a36c-c5076da6d565'

            GROUP BY vc.Guid

            HAVING COUNT (vc.Name) > 1

            )

ORDER BY vc.Name

 

 

 


Legacy ID



51387


Article URL http://www.symantec.com/docs/HOWTO21596


Terms of use for this information are found in Legal Notices