This Add-in allow geodatabase administrators to log users edit start/stop and version reconcile/post history.
When a versioned editing session starts in a SDE geodatabase, the extension listens events and inserts log records to RPC_LOG table which must be exists in editing geodatabase.
Below script can be execute to create the RPC_LOG table for Oracle;
CREATE TABLE RPC_LOG
( "LOGTIME" NUMBER NOT NULL ENABLE,
"MACHINE" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"OSUSER" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"DBUSER" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"OPERATION" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"DESCRIPTION" VARCHAR2(250 BYTE)
);
Add-in is using simple "insert into" sql command text for inserting log records to table. Same table can be created with corresponding schema for MS Sql Server, Postgresql etc.
Users who start editing in Arcmap must be granted to Select and Insert on the RPC_LOG table.
Sample Oracle script for grant;
"grant select,insert on RPC_LOG to EDIT_ROLE_OR_USER;"
Additional registry settings may be use;
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Enerjisa\GIS\VersionHistory]
"LogTableName"="GDBOWNER.RPC_LOG" > for changing the log table name or define full qualified name for access errors.
"ListenEditEvents" = "1" > Listen and log editing Start/Stop events. (string "1" : Enable, "0" for disable) (Default : Enable)
"ListenVersionEvents" = "1" > Listen and log version Reconcile/Post/Delete events. (string "1" : Enable, "0" for disable) (Default : Enable)
"DisabledUsers" = "Administrator,OtherPowerUser" > Comma separated OS users which needs to be excluded from logging. (Default : empty)
Extension is activated when edit session starts. If there is a problem about inserting records to table, this can be found in Windows Application Event Logs.
Note : LOGTIME is a number field which is calculating with the pattern of "YYMMDDHHmmSS".
