Identifying open edit sessions in SDE

LinkElmore

I am interested in learning a method to identify open edit sessions for users connected to a SQL/SDE database.  Using SQL Management Studio, it is possible to examine the sde_object_locks table.  However, I am unsure if this reflects merely a lock from a user with edit privileges who is connected to their version or if it additionally means they are in an active edit session.  My interest is in being able to disconnect users to perform db maintenance without risking the possibility of data loss if they are in an active edit session.

LinkElmore

I answered my own question by having a user open and close an edit session while refreshing the SQL query to view sde_object_locks.  Whenever an edit session opened, a new record appeared.  Closing the edit session removed the record from the table.  By cross referencing the object_id field with the version_id field in the sde_versions table, it's possible to see which version is locking the database.  Since each of my users has their own version, I know who to contact to disconnect before running maintenance operations that require disconnection.