ビデオヘルプ

Patch Management: List of Vendors and Products Report

作成: 28 Jun 2012 • 更新: 28 Jun 2012 | コメント数: 1
各国語の翻訳
odami の写真
+6 得票数:6
ログインして投票

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
  

 

コメント 1 Comment最新のコメントを表示

BMH1978 の写真

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.

0
ログインして投票
  • アクション