Updated date column in users table not getting updated properly

[soumik_das]

Hi,

We have been facing issue regarding the updated date column in users table not getting updated properly. The users have update account tasks in pending task list but the updated date is showing some previous date and time. I am attaching the query for your reference:

SELECT USERNAME, FIRSTNAME, LASTNAME, EMAIL, OWNER as Manager, CUSTOMPROPERTY3 as 'Business Unit', DEPARTMENTname as 'DEPARTMENT', EMPLOYEETYPE as 'Employee Type', ENDDATE as 'End Date', CASE STATUSKEY WHEN '0' THEN 'INACTIVE' WHEN '1' THEN 'ACTIVE' END AS 'USER STATUS', UPDATEDATE as 'Updated Date' FROM USERS WHERE UPDATEDATE > DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND STATUSKEY = 0;

Please can anyone intervene on this.

[indrahema95]

You want to check this for inactive users? Have tried to check it when the task is completed? 

[nimitdave]

users updated date is updated when any of the user attribute is updated by recon,api,UI and not when when account associated with the user is created,updated,deleted

[soumik_das]

okay thanks a lot

[rushikeshvartak · Accepted solution]

It won't update when user is updated via task. It only update when user is updated using UI, API or user import.

[soumik_das]

okay thanks a lot Rushikesh