I know this isn't exactly what you are looking for but here is some SQL that should work for what you are looking for.
SELECT
irPOL.ParentItemGuid [Policy Guid],
itPOL.Name [Policy Name],
itAdv.Name [Advertisement Name],
case when iaadv.Enabled = 1 then 'Enabled' else 'Disabled' end as 'Advertisement Status',
case when sup.SupersededBy is not null then 'Superseded' else 'NOT Superseded' end as 'Supersedence State'
FROM Item itAdv
JOIN ItemReference irPOL ON irPOL.ChildItemGuid = itAdv.Guid AND irPOL.Hint = 'swuadvert'
JOIN Item itPOL ON itPOL.Guid = irPOL.ParentItemGuid
JOIN ItemActive iaadv on iaadv.Guid = itAdv.Guid
JOIN ItemActive iapol on iapol.Guid = itPOL.Guid AND iapol.Enabled = 1
JOIN ItemReference irSWU ON irSWU.ParentItemGuid = itAdv.Guid AND irSWU.Hint = 'swu'
JOIN vRM_Software_Update_Item itSWU ON itSWU.Guid = irSWU.ChildItemGuid
LEFT JOIN vSoftwareUpdateInventoryRuleAssociations sup on sup.SWUGuid = itSWU.Guid
WHERE itAdv.Guid in (select Guid from ItemClass where ClassGuid = '59705429-CFCC-4f7c-9BF6-D4FCE8C9622C')
order by 2, 3
Original Message:
Sent: 05-27-2020 02:55 PM
From: David McGahan
Subject: Patch Management API
Hi all, sorry to resurrect an old thread, but I have a question about the PM API and here seems the best place to ask it.
Every few months I find myself with some spare time in which to streamline our clunky patch management processes; usually a bit of experimentation and digging through forum posts (sometimes even documentation) will lead me to an answer, but this one has evaded me so far: which API call will return a list of disabled updates contained in a patch policy? In the attached screenshot, for example, it's clear that individual patches have been deactivated in an otherwise live policy with enabled patches.
I can connect the dots between patches, bulletins, policies, and enabled/disabled status of policies, but short of clumsily querying the database directly, I can't seem to find an API call which returns a list of disabled updates inside enabled patch policies. Does such a call exist?
------------------------------
--None--
Original Message:
Sent: 08-07-2019 04:57 AM
From: Alex Hedley
Subject: Patch Management API
Patch Management Workflow Web Service Application Programming Interface (API)
DOC11543
https://support.symantec.com/us/en/article.doc11543.html