Tracking user who has deleted the record in the archive table

1369
5
12-05-2012 06:37 AM
Status: Open
Labels (1)
AndriusBogvila
New Contributor II

At the moment Editor tracking records the folowing information:

  • The name of the user who created it.
  • The date and time it was created.
  • The name of the user who edited it.
  • The date and time it was last edited.

This is great feature, however when archiving is enabled it misses such a very important information:

  • The name of the user who deleted it.
  • The date and time it was deleted.
5 Comments
VytautasGipiskis
Hello,

Actually geodatabase archiving combined with editor tracking needs to be used there. There is a bug NIM085153 on this issue, and it shoud be easy to implement. 


VytautasGipiskis
Hello,

Actually geodatabase archiving combined with editor tracking needs to be used there. There is a bug NIM085153 on this issue, and it shoud be easy to implement. 


Cesar_RafaelLopes
vgipiskis,

The geodatabase archiving is only possible in versioned geodatases and versions are only supported in ArcSDE geodatabases.

The editor tracking is available in non ArcSDE geodatabases, so it would be great to had a similar function to archiving in non ArcSDE Geodatabases.

Thanks!
ThomasColson

I've done this in the past on SDE tables About Change Data Capture (SQL Server) | Microsoft Docs  but it's not worth all of the extra steps. If you need to establish chain of custody for a forensic IT investigation, you can get the user name of whom deleted a record from system tables and transaction logs (again, a PITA), provided you're doing daily or incremental backups.  

Lake_Worth_BeachAdmin

I agree with this statement. you can accomplish OP's idea directly in SQL Server (Or any other RDBMS) but its not easy to set up if you're not a professional DBA.

Having this capability directly in ESRI products would be beneficial.