How does the Microsoft hotfixes section of Resource Manager get populated?

Article:HOWTO77106  |  Created: 2012-06-06  |  Updated: 2012-06-15  |  Article URL
Article Type
How To

 When viewing the resource manager for a resource, you might notice the Microsoft Hotfixes section.  

This data is stored in the Inv_SW_Patch_Windows table.  You can query this table using the following SQL query:


SELECT ISNULL( a.[Description], N''), a.[Patch ID]

FROM vRM_Network_Resource r

JOIN Inv_SW_Patch_Windows a ON a._ResourceGuid = r.Guid

WHERE r.Guid = 'Insert GUID of resource here' AND 

r.Deleted = 0

ORDER BY a.Description, a.[Patch ID]


This data is populated by Inventory Solution plug-in agent scanning of hardware and operating system files.

Article URL

Terms of use for this information are found in Legal Notices