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 as seen below?

Environment

ITMS 8.x

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