Video Screencast Help

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

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.

Login to vote