Reset package hash in sql database

Version 3

    Verified Product Versions

    Endpoint Manager 9.5Endpoint Manager 9.6

    How to reset the package hash for all software distribution packages in sql database.

     

     

    Use the following script to run a query for the package_files_hash which will reset all the package hashes to null.

     

     

    NOTE: Please make sure you backup your database prior to running the query.

     

     

         1. New query

    UPDATE PACKAGE_FILES_HASH SET HASH = null WHERE PACKAGE_FILES_HASH_IDN > 0

         2. F5 to execute

     

     

    Once executed the PACKAGE_FILES_HASH table will reset all HASH to NULL. Schedule a task and start, the HASH will update with a new HASH code.