changes in SDE version by date

828
1
03-28-2012 03:55 AM
Rana_M__SohailAslam
New Contributor
Hi,

I am using ArcSDE 10 with SQL Databases.

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?

I 'll be thankful.

Rana.
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
You'd have to store that information somewhere to query it back out again. ArcSDE just
tracks changes via a state tree and allows you to merge the records based on states (a
"version" is just a named state). While there is some timing information in the states table,
there is nothing to store who made which edit (just the open and close times).  You'd
need to merge with with a database logging capability or some unsupported triggers
on the SDE-owned tables to compile ownership information.

- V
0 Kudos