Report on locked documents and batches using SQL?

[Peter_Scaramuzz]

I want to create a SQL report of locked jobs and batches. I looked all over and can't find any hints or documentation. Can anyone tell me how I can report on that using SQL?

[Anthony_Boyd · Accepted solution]

Hi,

This should help get you started:

Document locks are in hsi.doccheckout, you can join itemnum to hsi.itemdata and usernum to hsi.useraccount.

Process locks are in hsi.lockkeys, the keynum is going to be the object that is locked (if its a document this is the itemnum, if this is a batch this will be the batchnum, if this is a diskgroup this will be the diskgroupnum, etc.). keykeytype is the type of lock - you can use this and what is displayed in the Process Locks window in the client to figure out what each one may mean, it will vary based on what you have licensed.

[Peter_Scaramuzz]

Awesome, thanks