audit history for user table fields

[Vedavalli]

Hi

I am working on a flow in which I have to give condition where the condition is like we have to fetch the inactive users in the last month from the user table. So ,how to set this condition in the flow?

And also, I would like to know when a field(active) is being updated and when the updated info of the field is  being recorded?

Thanks in advance.

[Ankur Bawiskar · Accepted solution]

@Vedavalli 

user table is not audited so you won't know when the field got updated to active false

So you might have to use some custom logic.

[Mark Manders · Accepted solution]

You will need to activate audit on the user table. I am not sure why this isn't activated by default, since every client at some time comes with a question about 'what happened to this user', but for your requirement, you will need it.
And, depending on why you need this information, it could be helpful to put a field on the user table that sets the 'inactivation date/time'. That really makes it easy to get those users.

[Ankur Bawiskar · Accepted solution]

@Vedavalli 

user table is not audited so you won't know when the field got updated to active false

So you might have to use some custom logic.

[valli_17]

Hi @Ankur Bawiskar 

Actually, what does this audit will do?

Is this the audit you are saying ?

Thanks in advance.

[Vedavalli]

Hi @Ankur Bawiskar ,

Actually, what does this audit will do?

Is this the audit you are saying ?

Thanks in advance.

[Mark Manders · Accepted solution]

You will need to activate audit on the user table. I am not sure why this isn't activated by default, since every client at some time comes with a question about 'what happened to this user', but for your requirement, you will need it.
And, depending on why you need this information, it could be helpful to put a field on the user table that sets the 'inactivation date/time'. That really makes it easy to get those users.