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

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

 When viewing the Resource Manager for a resource, you might notice the Microsoft Hotfixes section.  How is this populated?

 

Environment

ITMS 8.x

Resolution

This data is collected and populated by the Inventory Solution plug-in agent when scanning the hardware and operating system files, and it is stored in the Inv_SW_Patch_Windows table.  You can view the contents of this table using the following SQL query:

SELECT c.Name, ISNULL( a.[Description], N'') as Description, a.[Patch ID]
FROM vRM_Network_Resource r
JOIN vComputer c on c.Guid = r.Guid
JOIN Inv_SW_Patch_Windows a ON a._ResourceGuid = r.Guid
WHERE r.Deleted = 0

-- You can search by Computer Name OR Bulletin (Uncomment one of the lines below)
--AND c.Name = '%ComputerName%'
--AND [Patch ID] like '%Bulletin#%'

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