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.
Did this article resolve your issue?
Did this article save you the trouble of contacting technical support?
How can we make this article more helpful?
Email Address (Optional)
Login to Subscribe
Please login to set up your subscription.
Get support for your product, with downloads, knowledge base articles, documentation, and more.
Maximize your product competency and validate technical knowledge to gain the most benefit from your IT investments.
Submit a suspected infected file to Symantec.
Report a suspected erroneous detection (false positive).
Create and manage cases, manage licensing and renewals, submit threats, and enroll with Symantec Rewards.
Customer and Technical Support phone numbers and hours of operation.
User-to-user forums, blogs, videos, and other community resources on Symantec Connect.
Set default language
Do you wish to save this as your future site?