To check user activity in Saviynt, follow the steps below:
Start by configuring an analytical report using the provided query. This query retrieves specific information related to user activity, such as the username, access time, and access details. The access details provide insights into the specific actions performed by the user.
The query is as follows:
```SELECTusernameAS'Username', accesstimeAS'Access Time', accessdetailsAS'Access Details' FROM( SELECTu.username, accesstime, CASE WHEN( access_url='/workflowmanagement/requesthome')THEN'Request Home' WHEN( access_url='/workflowmanagement/requestaccessforothers')THEN'Request Access for Others'... -- Additional WHEN conditions for different access URLs and actions ... WHEN( access_url='/requestmap/update')THENconcat('Request map updated. Updated Object - ',query_param) ENDASaccessdetails FROMusersu, userlogin_accessua, userloginsl WHEREl.loginkey=ua.loginkey ANDl.userkey=u.userkey)ASt1 WHEREaccessdetailsISNOTNULL ANDaccesstimeBETWEENdate_sub(now(),interval1day)ANDnow();
Please note that the above provided query already filters the results based on a specific time range. You can modify the time range by adjusting the following line in the query:
accesstimeBETWEENdate_sub(now(),interval1day) AND now();
The report will include the following details for each user activity entry:
- Username: The username of the user who performed the action. - Access Time: The timestamp indicating when the action occurred. - Access Details: A description of the specific action performed by the user.
The "Access Details" field provides valuable insights into the user's activity by categorizing each action based on the accessed URLs and associated parameters.
Review the report to gain an understanding of user activity within the specified time range. This information can be useful for various purposes, including auditing, security monitoring, and compliance verification.
This example retrieves user activity within the last 24 hours. You can customize the time range according to your requirements.