Exporting Completed tasks and complete analytics history for all analytics

[yeddulanaveen]

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

[rushikeshvartak]

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 

[rushikeshvartak]

What do u mean by analytics history ?

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