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.
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