Reset the Server side data hashes for the Windows System Assessment Scan

Products

• Patch Management Solution for Windows

Issue/Introduction

How can I reset the Server side datahashes for the Windows System Assessment Scan return for Patch Management Solution 7.5.x, 7.6.x and 8.1.x?

Environment

ITMS 7.x, 8.x

Resolution

When Patch Compliance reporting is inaccurate, or Patch DataClasses are not being created, work through the process outlined on KM: 180637, and then run the following SQL to clear server-side datahashes for the following SQL queries will set the datahashes to 'Null':

1.To update Patch DataHashes for ALL Resources run the following:

UPDATE ResourceUpdateSummary
SET DataHash = NULL
WHERE InventoryClassGuid IN
('82125795-059D-415D-9CF9-9CDA2643026E',
'737D8EF6-C775-4EB0-A3E0-7333A936FC25')
AND DataHash IS Not NULL

2. Run the following SQL script to update the datahash for Patch DataClasses for a single computer:  (This script is useful to test; once verified the ALL script from item #1 above could be utilized):

UPDATE ResourceUpdateSummary
SET DataHash = NULL
WHERE InventoryClassGuid IN
('82125795-059D-415D-9CF9-9CDA2643026E',
'737D8EF6-C775-4EB0-A3E0-7333A936FC25') 
AND ResourceGuid = 'ENTER CLIENT RESOURCE GUID HERE'

3.To update the DataHash for a single DataClass run the following:

UPDATE ResourceUpdateSummary
SET DataHash = NULL
WHERE InventoryClassGuid = 'ENTER DESIRED DATACLASS GUID FROM LIST BELOW'

The following are corresponding Guid's with Patch Dataclasses :

82125795-059D-415D-9CF9-9CDA2643026E – Applicable Windows Software Update
737D8EF6-C775-4EB0-A3E0-7333A936FC25 – Installed Windows Software Update