We rely on Student Interns for data maintenance in a versioned GDB environment, and as a QC mechanism/tool, developed a python script that reports the following:
Number of Adds, Updates and Deletes in each Feature Class updated by each version
Number of rows in the A & D Table of Feature Classes that are regisreted as versioned
These reports are e-mailed, and act as a snapshot. Our main goal is to get a feel for the magnitude of updates performed in each open version, and to keep an eye on the A & D tables from a GDB performance standpoint.
We would like to make the script available for everyone on arcscripts, but would like to have it tested prior to that. We are particularly interested in the following:
Check if the logic is valid - see if it produces the desired result
Test it on other releases and back-ends (Tested OK in 9.3/Oracle)
The python script uses the pyodbc module to query the VERSIONS, STATE_LINEAGES, MVTABLES_MODIFIED and TABLE_REGISTRY tables. It also uses the yaml module to read a config file. These two modules need to be installed before running the script, and the config file needs to be updated to reflect your geodatabase environment. Instructions are documented in the python script header and in the config file.
The Python script and the config file are included in the attached zip file.
