Determining the Last Time Records Were Updated by Specific User

[SebastianBarnes]

Hi all,

I have a use case where I need to determine if a particular user has made updates to a record (asset) within a timeframe.

We have a specific account that is used to process certain updates, and I want to know if it has updated a record in 90 days or less. How would I go about accomplishing this?

Thank you!

[AshishKM]

Hi @SebastianBarnes , 

You can apply the filter condition like below, but this only give those records which are not updated by any other users as any other update will change the updated by value.

If the below in not the solution then you have think about some metric definition configuration for updated by field and then you can create report on metric instance table.

-Thanks,

AshishKM

[Ankur Bawiskar]

@SebastianBarnes 

if your table is audited then you can check Audit table