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?
Discussion Filed Under:
Comments 3 Comments • Jump to latest comment
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
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
thanks! that's exactly what I needed
Would you like to reply?
Login or Register to post your comment.