Patch Management Solution

 View Only

  • 1.  Where is Patch Management Vendor table?

    Posted Nov 08, 2012 11:50 AM

    Where is the table in cmdb that lists the vendors for patch management?



  • 2.  RE: Where is Patch Management Vendor table?

    Posted Nov 08, 2012 12:16 PM

    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



  • 3.  RE: Where is Patch Management Vendor table?
    Best Answer

    Broadcom Partner
    Posted Nov 08, 2012 01:32 PM

    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



  • 4.  RE: Where is Patch Management Vendor table?

    Posted Nov 08, 2012 02:16 PM

    thanks! that's exactly what I needed