Identify all the artifacts with missing client checksum in a repo

The fastest way to identify all the artifacts with missing Client Checksum is to run the following query:

  Select repo, node_path, node_name FROM nodes Where sha1_original IS NULL AND sha1_actual IS NOT NULL AND repo=’some_repo’;