We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Exporting Completed tasks and complete analytics history for all analytics

yeddulanaveen
New Contributor
New Contributor

Hi All,

I am trying to take an export of completed tasks in Saviynt version 5.5SP3x (The count is more than 3lakhs). I am unable to get the export of completed tasks. 

I also need information about getting complete analytic history data for all the analytics. I am able to get individual analytics history, but I need run history of all the analytics.

Please help.

Regards,

Naveen

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

For Tasks use below query 

 Pending & Tasks information 





SELECT a.taskkey            AS 'TASK ID',
       a.taskdate           AS 'TASK CREATE DATE',
       a.updatedate         AS 'TASK UPDATE DATE',
       CASE
         WHEN a.tasktype = 1 THEN 'Add Access'
         WHEN a.tasktype = 2 THEN 'Remove Access'
         WHEN a.tasktype = 3 THEN 'NEW ACCOUNT'
         WHEN a.tasktype = 4 THEN 'NEW ROLE REQUEST'
         WHEN a.tasktype = 5 THEN 'CHANGE PASSWORD'
         WHEN a.tasktype = 6 THEN 'ENABLE ACCOUNT'
         WHEN a.tasktype = 14 THEN 'DISABLE ACCOUNT'
         WHEN a.tasktype = 12 THEN 'UPDATE ACCOUNT'
         WHEN a.tasktype = 8 THEN 'DELETE ACCOUNT'
         ELSE a.tasktype
       END                  AS 'TASK TYPE',
       u.username           AS 'USERNAME',
       CASE
         WHEN u.statuskey = 0 THEN 'Inactive'
         WHEN u.statuskey = 1 THEN 'Active'
         ELSE u.statuskey
       END                  AS 'User_Status',
       a.accountname        AS 'ACCOUNT NAME',
       s.systemname         AS 'Security System',
       e.endpointname       AS 'ENDPOINT NAME',
       ev.entitlement_value AS 'ENTITLEMENT VALUE',
       CASE
         WHEN a.status = 1 THEN 'NEW'
         WHEN a.status = 2 THEN 'IN PROGRESS'
         WHEN a.status = 3 THEN 'COMPLETE'
         WHEN a.status = 4 THEN 'DISCONTINUED'
         WHEN a.status = 5 THEN 'PENDING CREATE'
         WHEN a.status = 6 THEN 'PENDING PROVISIONING'
         WHEN a.status = 7 THEN 'PROVISIONING FAILED'
         WHEN a.status = 8 THEN 'ERROR'
         WHEN a.status = 9 THEN 'NO_ACTION_REQUIRED'
         ELSE a.status
       END                  AS 'TaskStatus'
FROM   arstasks a
       INNER JOIN users u
               ON u.userkey = a.userkey
       INNER JOIN endpoints e
               ON a.endpoint = e.endpointkey
       INNER JOIN securitysystems s
               ON s.systemkey = e.securitysystemkey
       LEFT JOIN entitlement_values ev
              ON a.entitlement_valuekey = ev.entitlement_valuekey 

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

rushikeshvartak
All-Star
All-Star

What do u mean by analytics history ?

If its report run history then you need to download individually only


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.