Hi, I would like to create a view that would show the dates for the last reconcile and post operation for each version in GDB. I understand each state has a closing date and each version can have last touched data. However I am having a difficult time figuring out at which point either the states or lineages would be considered "reconciled/posted". I was trying to use a combination of SDE_states, SDE_versions, SDE_lineages_modified and SDE_state_lineages.
Would anyone have SQL code or ideas how to accomplish this?
The idea here is to create a report that would list which versions need to be reconciled and posted within a certain time period, to hold our users accountable.