Client Management Suite

 View Only
Back to Library

Patch Management: List of Vendors and Products Report 

Jun 28, 2012 03:26 PM

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
  

 

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Migration User
Feb 26, 2013 03:58 PM

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.

Related Entries and Links

No Related Resource entered.