How does the Microsoft hotfixes section of Resource Manager get populated?
|Article:HOWTO77106|||||Created: 2012-06-06|||||Updated: 2012-06-15|||||Article URL http://www.symantec.com/docs/HOWTO77106|
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 http://www.symantec.com/docs/HOWTO77106