How can I reset the Server side data hashes for the Windows System Assessment Scan

book

Article ID: 180729

calendar_today

Updated On:

Products

Patch Management Solution for Windows

Issue/Introduction

 

Resolution

Question:
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?

Answer:
When Patch Compliance reporting is inaccurate, or Patch DataClasses are not being created, work through the process outlined on KM: HOWTO58971, 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