Hi Team,
We have noticed a few assets (poles) missing from our eGDB.
When I look in SQLDeveloper, I can see the _H table that tells me when the feature existed using the FROM and TO fields. I cannot work out the WHO.
Is there a way to check this?
Solved! Go to Solution.
The traditional archiving method? Nope, you're out of luck with the data table alone, you might be able to correlate the GDB_TO_DATE with other database or server logs but no guarantees. Branch Versioned tables have their own schema that includes the GDB_DELETED BY field which should list the culprit, if you can work out a migration plan I'd recommend switching.
Hi @SahilBhouraskar Archiving alone does not provide editor tracking fields which gives you the WHO. The last editor would be tracked when using Editor Tracking.
You can take a look more in depth on Archiving by using Historical Moments. But I do not believe you will see the actual user.
Editor Tracking resource:
Marlon
The traditional archiving method? Nope, you're out of luck with the data table alone, you might be able to correlate the GDB_TO_DATE with other database or server logs but no guarantees. Branch Versioned tables have their own schema that includes the GDB_DELETED BY field which should list the culprit, if you can work out a migration plan I'd recommend switching.