Hi Experts,
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?
Regards,
Naveen
