Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/21/2024 12:24 AM
Hi Everyone,
I am trying to fetch the history of One click disable data from January 2024 till now using the below query but it is not picking up the data from May.
I am not sure whether anything is not supported in EIC because in May the environment was migration from 5.5 to EIC 24.1.
SELECT DISTINCT u.username AS 'UserName',
monthname(a.taskdate) as 'deactivated'
FROM
arstasks a, users u WHERE a.userkey = u.userkey AND a.source = 'ONECLICKDISABLE' AND u.statuskey = 0 AND year(a.taskdate) = year(NOW()) ;