Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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