There are too many Software Update Policies to view the targets one by one. Would like a report to display this data.
Run the following SQL against the Symantec_CMDB database to view the requested data.
May also go to the Console > Reports > All Reports, right-click Reports folder and select 'New - Report,' and Replace the Parameterised Query field with the contents of this SQL script, and save the report for viewing in the Console.
select pol.Name as 'Policy', isnull (rtar.Name, 'All Windows Computers with Software Update Plug-in Installed Target') as 'Target'
from vItem pol
left Join (
SELECT i.guid, x1.value('.','UNIQUEIDENTIFIER') ResourceTarget
FROM Item i
SELECT Guid, CAST([State] AS XML) StateXML
WHERE classguid = '49FE4304-E09D-4382-9026-715868FFB856'
ON i.Guid = dt1.Guid
) rt ON rt.guid = pol.Guid
left Join vItem rtar on rtar.Guid = rt.ResourceTarget
where pol.classguid = '49FE4304-E09D-4382-9026-715868FFB856'
order by pol.name desc
Patch Management 7.0 SP2 and MR1.