If all you are looking for are the missing tiffs, why not run the Volume Consistency Checker instead?

https://answers.laserfiche.com/questions/49227/Is-there-a-Volume-Consistency-Checker-for-LF-9

I'm looking for automatic reported generated by workflow once a week and set email update.  after enabling checksums on volume I was looking for SQL query or SDK script which will be exectuded by workflow which will run the checksum validation and sent email update.

Hi Raymond,

Is your answer final? so checksums cant be automated.

Thank you for the word back.

Hi Arif,

Checksums can be automated. The same calls that the client application users are present in the SDK. They aren't specifically documented, but they should be in the object reference. I would recommend using the SDK calls instead of directly calling into SQL - if you try to use SQL directly you'd also need to go through all the files in the volumes yourself as well, which could be quite an undertaking. The Laserfiche Server will keep track of all that for you if you go through the SDK. 

Is there any SDK documentation regarding the CheckSum feature to automate a recurrent analysis?