How can I reset the Server side data hashes for the Windows System Assessment Scan return for PM 7.1 SP1, SP2, MP1.x and 7.5?

Article:HOWTO60749  |  Created: 2011-10-31  |  Updated: 2014-01-07  |  Article URL http://www.symantec.com/docs/HOWTO60749
Article Type
How To

Product(s)


Question:
How can I reset the Server side data hashes for the Windows System Assessment Scan return for Patch Management Solution 7.1 SP1, SP2, MP1.x and 7.5?

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 data hashes.

The following SQL queries will set the datahash's to 'Null'. 

1.To update all DataHash's 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.To update the DataHash for a single computer run the following:  (This would be used to test and verify that it will help the issue if the all DataHash's are set to Null)

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

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

UPDATE ResourceUpdateSummary
SET DataHash = NULL
WHERE InventoryClassGuid = 'Place Desired Dataclass Guid Listed 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




Article URL http://www.symantec.com/docs/HOWTO60749


Terms of use for this information are found in Legal Notices