How to find created or inserted data when we set audit field values for imported records (Created By, Created Date, Last Modified By ID, Last Modified Date)?

How to find created or inserted data when we set audit field values for imported records (Created By, Created Date, Last Modified By ID, Last Modified Date)?

Let’s say, Account records are inserted with audit field values. You can use the below query to find

SELECT Id, Name 
FROM Account 
WHERE DAY_ONLY ( SystemModStamp ) = TODAY

SystemModStamp is strictly read-only. Not only is it updated when a user updates the record, but also when automated system processes update the record. Because of this behavior, it creates a difference in stored value where ‘LastModifiedDate <= SystemModStamp’ but never ‘LastModifiedDate > SystemModStamp’.

To understand the usage of SystemModStamp, check the below link for more information

Leave a Reply