ビデオヘルプ

Where is Patch Management Vendor table?

作成: 08 Nov 2012 • 更新: 08 Nov 2012 | コメント数: 3
この問題は解決されました。 ソリューションを参照してください。

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

コメント コメント数: 3最新のコメントを表示

shafiq1 の写真

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

Network23 の写真

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

ソリューション