Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/13/2024 08:04 PM
Hi,
I have copied the default Analytics Dormant Accounts - Active Directory and set up an analytics job with the below query:
SELECT u.username AS 'Username', u.jobcodedesc AS 'Position Title', u.customproperty15 AS 'customproperty15', a.accounttype AS 'accounttype', u.FIRSTNAME AS 'User First Name', u.LASTNAME AS 'User Last Name', e.DISPLAYNAME AS 'Application Name', name AS 'Account Name', a.lastlogondate AS 'Last Logon', DATEDIFF(CURDATE(), a.lastlogondate) as 'Days Since LastLogin', CASE WHEN (a.status = 1) THEN 'Active' ELSE a.status END AS 'Account Status', e.endpointKey, a.accountkey as 'acctKey', 'disableAccount' as 'Default_Action_For_Analytics' FROM accounts a, user_accounts ua, users u, endpoints e WHERE ua.accountkey = a.accountkey AND u.userkey = ua.userkey AND e.endpointkey in (3) AND a.endpointKey = e.endpointKey AND a.status IN ('1' , 'Manually Provisioned', 'Active') AND DATEDIFF(CURDATE(), lastlogondate) >= 90 AND lastlogondate IS Not NULL AND u.customproperty15 is NULL order by lastlogondate asc
Results are displaying the correct records when reviewing the history of the analytics job and its also correct in data analyzer.
I have included 'disableAccount' as 'Default_Action_For_Analytics' FROM accounts a.
I have created a RunAllAnalyticsJob in Job Control Panel, including categories ALL and Execute Default Action for Analytics is ticked.
The accounts do not get disabled.
TIA
05/13/2024 08:05 PM
Account needs to be attached to user. You can attach user to admin user and test it will work. This looks like defect please raise support ticket
05/13/2024 08:23 PM
05/13/2024 08:29 PM
Please share
05/13/2024 08:46 PM
05/13/2024 08:55 PM
in allowed actions just keep disable account
05/13/2024 09:32 PM
05/13/2024 09:38 PM
Please create job with below configs
05/13/2024 09:46 PM
Hi,
I don't have that option "Actionable Reports". thanks
05/13/2024 09:49 PM
You can ignore that for your case.
05/13/2024 09:53 PM - edited 05/13/2024 09:53 PM
OK, so there is no change then. Its the same as yours except I have "All" for Analytics Categories and no subcategories. Any other ideas? thanks
05/13/2024 10:00 PM
try with simple query
select a.name,a.accountkey as acctKey, endpointkey, 'disableAccount' as Default_Action_For_Analytics from accounts a where accountkey=1111 limit 1
05/13/2024 10:36 PM
Same result unfortunately, the parent job and v2 job never update status to success.