Video Screencast Help

Where is Patch Management Vendor table?

Created: 08 Nov 2012 • Updated: 08 Nov 2012 | 3 comments
This issue has been solved. See solution.

Where is the table in cmdb that lists the vendors for patch management?

Comments 3 CommentsJump to latest comment

shafiq1's picture

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

Network23's picture

Hi Shafiq1,

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?

Network23

SOLUTION