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 |
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









Thank you.