How to differentiate new records from updated records made in a SDE version

[SanchezNuñez]

Good morning

Is there a way to differentiate between records added and records updated in traditional or branch versions?

I tried this code, but I did not see a way to differentiate them:

SELECT [MyRecordID], additional fields, ...
FROM [SchemaOwner].[a4313]
WHERE SDE_STATE_ID IN
(SELECT STATE_ID
FROM SDE.sde_STATES
WHERE LINEAGE_NAME IN
(SELECT LINEAGE_NAME
FROM SDE.sde_STATES
WHERE STATE_ID =
(SELECT STATE_ID FROM SDE.sde_VERSIONS WHERE NAME ='MyVersion'
)
)
)

Thanks

[MarlonAmaya]

Hi @SanchezNuñez ,

I cant provide you with a query, however you can utilize Editor Tracking with traditional versioning to assist you.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/introduction-to-editor-trac...

Branch versioning already has editor tracking built in automatically. 

Marlon