topic Re: Create Query of Feature Class Locks in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462102#M17899 <HTML><HEAD></HEAD><BODY><P>After poking around, this generates something pretty similar to the locks table...</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/153601_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 08 Dec 2015 22:51:00 GMT mpboyle 2015-12-08T22:51:00Z Create Query of Feature Class Locks https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462101#M17898 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>I'm assuming this is stored within various 'sde_' tables and related through identifiers.&nbsp; I'm hoping someone from Esri could point me in the right direction.&nbsp; We aren't looking to alter any of the background 'sde_' tables, just looking to reproduce the query that generates such a list.</P><P></P><P>Thanks!</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/153600_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 08 Dec 2015 22:23:49 GMT https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462101#M17898 mpboyle 2015-12-08T22:23:49Z Re: Create Query of Feature Class Locks https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462102#M17899 <HTML><HEAD></HEAD><BODY><P>After poking around, this generates something pretty similar to the locks table...</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/153601_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 08 Dec 2015 22:51:00 GMT https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462102#M17899 mpboyle 2015-12-08T22:51:00Z Re: Create Query of Feature Class Locks https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462103#M17900 <HTML><HEAD></HEAD><BODY><P>We've used the following SQL Statement for a while.&nbsp; Looks like your hitting the same elements.&nbsp; I just checked it again in Microsoft SQL Server Management Studio for SQL Server 2012.</P><P></P><P></P><P>select a.owner,a.table_name locked_table, a.registration_id, b.owner locked_by, b.nodename connect_source, b.start_time </P><P></P><P>from sde.sde_table_registry a, sde.sde_process_information b, sde.sde_table_locks c</P><P></P><P>where a.registration_id = c.registration_id and b.sde_id = c.sde_id</P></BODY></HTML> Thu, 21 Jan 2016 18:41:56 GMT https://community.esri.com/t5/arcgis-enterprise-questions/create-query-of-feature-class-locks/m-p/462103#M17900 RichardCrucchiola 2016-01-21T18:41:56Z