topic changes in SDE version by date in Data Management Questions https://community.esri.com/t5/data-management-questions/changes-in-sde-version-by-date/m-p/266081#M15370 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am using ArcSDE 10 with SQL Databases.</SPAN><BR /><BR /><SPAN>Can anybody tell me that how can we see the records updated/created by any user of all days. I mean how can we check which records updated/created by a user on which day?</SPAN><BR /><BR /><SPAN>I 'll be thankful.</SPAN><BR /><BR /><SPAN>Rana.</SPAN></BODY></HTML> Wed, 28 Mar 2012 10:55:17 GMT Rana_M__SohailAslam 2012-03-28T10:55:17Z changes in SDE version by date https://community.esri.com/t5/data-management-questions/changes-in-sde-version-by-date/m-p/266081#M15370 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am using ArcSDE 10 with SQL Databases.</SPAN><BR /><BR /><SPAN>Can anybody tell me that how can we see the records updated/created by any user of all days. I mean how can we check which records updated/created by a user on which day?</SPAN><BR /><BR /><SPAN>I 'll be thankful.</SPAN><BR /><BR /><SPAN>Rana.</SPAN></BODY></HTML> Wed, 28 Mar 2012 10:55:17 GMT https://community.esri.com/t5/data-management-questions/changes-in-sde-version-by-date/m-p/266081#M15370 Rana_M__SohailAslam 2012-03-28T10:55:17Z Re: changes in SDE version by date https://community.esri.com/t5/data-management-questions/changes-in-sde-version-by-date/m-p/266082#M15371 <HTML><HEAD></HEAD><BODY><SPAN>You'd have to store that information somewhere to query it back out again. ArcSDE just </SPAN><BR /><SPAN>tracks changes via a state tree and allows you to merge the records based on states (a</SPAN><BR /><SPAN>"version" is just a named state). While there is some timing information in the states table,</SPAN><BR /><SPAN>there is nothing to store who made which edit (just the open and close times).&nbsp; You'd </SPAN><BR /><SPAN>need to merge with with a database logging capability or some unsupported triggers</SPAN><BR /><SPAN>on the SDE-owned tables to compile ownership information.</SPAN><BR /><BR /><SPAN>- V</SPAN></BODY></HTML> Wed, 28 Mar 2012 11:26:51 GMT https://community.esri.com/t5/data-management-questions/changes-in-sde-version-by-date/m-p/266082#M15371 VinceAngelo 2012-03-28T11:26:51Z