ConfigMgr 2012 handles editing of objects through something called “SEDO” or “Serialized Editing of Data Objects.” Object locks can be found in the SEDO_LockState table in the ConfigMgr database. You can locate the record in question by searching for LockStateID that’s not zero, or by the user ID that ConfigMgr says is editing the object (‘AssignedUser’). An example query would be: select * from SEDO_LockState where LockStateID <> 0
Wednesday, September 25, 2013
Unlocking ConfigMgr 2012 Objects
When removing objects in ConfigMgr the following message is displayed: "Cannot edit the object which is in use by <?>". This happened as the result of the ConfigMgr console crashing while someone had the object open.
Simply use the appropriate information to remove the record related to the object*. For example: DELETE from SEDO_LockState where LockID = ‘<LockID of the record identified in the previous query>’ Once the record is removed, you should be able to modify the object again. Hope it helps!