02/07/2023 04:29 PM - edited 02/07/2023 04:30 PM
Is it possible to update end date from Actionable Analytics report.
Scenario: AD Groups assigned to users account in AD has End Date.
There should be notification raised when end date is approaching and task raised to extend the end date of group, if required.
We are trying to do this through actionable report. My report has below query:
select u.username as 'Employee User Name',u.firstname as 'Firstname', u.lastname as 'Lastname',(select m.email from users m where m.username = u.owner) as 'Manager Email',(select mf.firstname from users mf where mf.username = u.owner) as 'ManagerFirstname',(select ml.lastname from users ml where ml.username = u.owner) as 'ManagerLastname', a.name as 'Account Name',e.endpointname as 'Application', ev.entitlement_value as 'Entitlement', ev.DESCRIPTION as 'Description', ae1.ENDDATE as 'End Date',(select mm.username from users mm where mm.username = u.owner) as username, ua.accountkey as 'acctKey' from users u, accounts a, user_accounts ua, entitlement_values ev, account_entitlements1 ae1, endpoints e where u.userkey= ua.userkey and u.STATUSKEY=1 and ua.ACCOUNTKEY = a.ACCOUNTKEY and a.ACCOUNTKEY = ae1.ACCOUNTKEY and a.status in ("Manually Provisioned",1,'Active') and ae1.ENTITLEMENT_VALUEKEY = ev.ENTITLEMENT_VALUEKEY and a.ENDPOINTKEY = e.ENDPOINTKEY and e.STATUS = 1 and ev.status = 1 and ae1.enddate is not null and (ae1.ASSIGNEDFROMROLE is null or ae1.ASSIGNEDFROMROLES is null) and DATEDIFF(ae1.ENDDATE,sysdate()) between 0 AND (select configdata from configuration where name = 'NUMBEROFDAYSBEFOREENTITLEMENTEXPIRYDATE');
My report looks like below:
Is there a way to make "End Date" editable here so the action "Update Account" updates the End Date?
02/07/2023 07:14 PM
This is not configurable in report. You can keep editable on Request form and enable extend date functionality