Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey and tell us about your satisfaction level using Symantec Connect. One lucky winner will receive 500 Connect points!* Take the survey.

Patch Management: List of Vendors and Products Report

Created: 28 Jun 2012 • Updated: 28 Jun 2012 | 1 comment
Language Translations
odami's picture
+6 6 Votes
Login to vote

The question I get asked most about Patch Management is "What products can I actually patch?". This answers that question at last.

After running the PMI Task, even if a product is "Checked" or not this report will return a list of all possible Products (By Vendor) that you can Patch.

For now I'm uploading only SQL, later I will add search Parameters in xml format.

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
  

Comments 1 CommentJump to latest comment

BMH1978's picture

I found this posting very helpful, however, is there a way to generate a report of the vendors/products "Checked" within the Metadata Import section?

I need to provide a listing of all vendors and software products we are currently importing. I was trying to put together my own SQL query, but I don't know which table in the database stores the "selected" products.

Any guidance would be greatly appreciated. Thanks.

+1
Login to vote