Is there a report to get a list of available vendors in Patch Management Solution?

Products

• Patch Management Solution

Issue/Introduction

Is it possible to export the Patch Management Solution vendor list?

Environment

Release: 8.6

Resolution

The following SQL query can be run against the database to return the vendor list.

select
vi.name as Vendor,
rk.Name as Product
from RM_ResourceSoftware_Release rk
join ResourceAssociation ra on ra.ParentResourceGuid = rk.Guid
join vitem vi on vi.Guid = ra.ChildResourceGuid
where
rk.ProductGuid = 'B1338338-5575-4A27-9808-23BEC40D79FA' and
vi.name != 'Invariant Language (Invariant Country)' and
rk.name not like 'Patch Management Agent%' and
rk.name != 'Default Microsoft Update Product' and
rk.name != 'Patch Windows System Assessment Scan Tool'
order by rk.name, vi.name asc