Where is the table in cmdb that lists the vendors for patch management?
In addition to a vendors list I also want to build a report that shows patchable products by vendor that I can forward to management. Does anyone know the tables in cmdb that I can pull this information from? we're on 7.1 sp2
Try the following SQL Query (after run Patch Import Task):
Select comp.Name AS [Company], vi.Name AS [Product]
From Inv_Software_Release_Platform rp
INNER JOIN ResourceAssociation ra
ON ra.ParentResourceGuid = rp._ResourceGuid
AND ra.ResourceAssociationTypeGuid = '292dbd81-1526-423a-ae6d-f44eb46c5b16'
LEFT JOIN RM_ResourceCompany comp
ON ra.ChildResourceGuid = comp.Guid
INNER JOIN RM_ResourceSoftware_Release vi
ON vi.Guid = rp._ResourceGuid
ORDER BY 1,2
Does this answer your question?
thanks! that's exactly what I needed