Create Query of Feature Class Locks

Question

I'm wondering if it's possible to create a query within Sql Server that lists the users that have a lock on a feature class...?...something similar to what you'd see within the 'Locks' view of the Gdb Administration.

I'm assuming this is stored within various 'sde_' tables and related through identifiers.  I'm hoping someone from Esri could point me in the right direction.  We aren't looking to alter any of the background 'sde_' tables, just looking to reproduce the query that generates such a list.

Thanks!

RichardC · Answer

We've used the following SQL Statement for a while.  Looks like your hitting the same elements.  I just checked it again in Microsoft SQL Server Management Studio for SQL Server 2012.

select a.owner,a.table_name locked_table, a.registration_id, b.owner locked_by, b.nodename connect_source, b.start_time

from sde.sde_table_registry a, sde.sde_process_information b, sde.sde_table_locks c

where a.registration_id = c.registration_id and b.sde_id = c.sde_id

mpboyle · Answer

After poking around, this generates something pretty similar to the locks table...