Sys_updated_on only for active field to get query ?

[sukran]

Hi 

we 're trying to query the records in user table(sys_user) that the only active field was updated on last two days but somewhat the users records getting other fields updated daily basis and updated by integration feed even after the record was inactive , so its not querying correct details for(sys_updated_on ) for active field updated before last two days .. how to get query that only active field is updated on last two days

Computer form - owned by is a reference field and we're looking owned by user table field is active was updated before 2 days

please find the attached screenshot

[sukran]

Hi Archanna

Any idea how to achieve this ?

[Archana Reddy2]

Not exactly Sukran.

I thought of querying on sys_audit table which would help to achieve this requirement. But not sure if querying on sys_audit is a good practice or not.

Thanks