Understand number of edits present in childhood version and default version

Question

Hi Folks,

I am currently trying to understand how many edits are present individually on each child version and default version in traditional versioning scenario.

I have over 10+ version. Is there a Sql query that can help us to check. I know from ArcGIS Pro at individual feature class level we can check the diffrence view from versioning tab. From SSMS, individual edits could be tracked about its version origin from various system tables, and the versioning statistics query providing how many versions are there and how many records present in Delta tables.

It would be great if someone could help me with SQL query that can show us how many are present in each version.

Any kind of help on this would be appreciated.

Cheers,

Jess

Jessica_GISworker · Answer

Hi @VinceAngelo ,

Thank you for sharing the information.

I will try to formulate such a SQL query or built a Python query.

Thanks

Jess

VinceAngelo · Answer

There isn't going to be one query, unless you UNION ALL together every An and Dn table of every user in the database instance, joining in the states and state_lineages table. It would be an exceedingly ugly query, probably involving at least two WITH clauses (because UPDATEs are a combination of both Add and Delete, they would have to be queried separately, then conjoined in an additional query.

This would take me a day or two to work out, and I've been a SDBE/SDE/ArcSDE/geodatabase subject matter expert for thirty years. If you want to go down this path, you'll need to provide what you have so far. You'll need to compile a list of all the versioned tables, queries that generate lists of table_name, state, An/Dn row and impacted objectid and a query that can summarize INSERT/UPDATE/DELETE events by version-table.

It might be easier to run all those queries from Python, and collate there, but it's still an ambitious task.

- V

Jessica_GISworker · Answer

Hi Guys.

Any updates on this issue?

It would be appreciated if someone could share insights on this.

Regards,

Jess