Analytical report of termed users in saviynt in the past 24 hours.

[Rishi]

Use Case

This article describes creating an analytical report which gives a list of termed users (users whose status changed to inactive) in Saviynt in the past 24 hours. The requirement is that this termed user list will be sent to disconnected application admins where they can take manual action to terminate user in the disconnected application (application which is Not managed by Saviynt). 

This report takes into account if the termination rule was executed successfully so that it does not end up sending user report just based on just Status so its helpful in scenario where future dates termination is configured.

Pre-requisites

Saviynt user status is updated based on HR import and Saviynt rule is configured

Applicable Version(s)

All

Solution

Please configure the following analytical report in order to capture the terminations:

SELECT DISTINCT
USERNAME, DISPLAYNAME, customproperty17 as TERMED_USER_STATUS
FROM
userrulerundata_archive,
users
WHERE
userrulerundata_archive.userkey = users.userkey
AND changemap LIKE '%customproperty17%'
AND userrulerundata_archive.updatedate >= DATE_SUB(NOW(), INTERVAL 1 DAY)
AND changemap LIKE '%["A","T"]%'
AND userrulerundata_archive.comments LIKE '%rule run is successful%'
AND processed = 1;

NOTE:

• Please note in this example, terminations are based on customproperty17 and hence the changemap is configured based on the same. In your case, it might be different, so please configure the query accordingly. Also, "A" stands for Active and "T" stands for Terminated.
• Also, the reason why we have only configured userrulerundata_archive table and not userrulerundata is because once the rule run is successful and the user is terminated successfully,  the same data is migrated from userrulerundata to userrulerundata_archive table.