and more in a single search tool across platforms. Read the announcement here. |
09/02/2022 09:19 PM
We want a report of users whose emails were updated in last 7 days. Is there a table to get this data?
Moreover can we get the previous email values from which is was updated?
09/03/2022 05:19 AM
Requirement is not feasible with analytics report. You can use user update rule to achieve above requirement.
Usershistory table contain changelog column which will be encrypted
select b.USERKEY, b.username, a.UPDATEDATE as 'User Update Date' from usershistory a,users b where DATEDIFF(now(),a.UPDATEDATE) < 1 AND a.USERKEY = b.USERKEY AND b.STATUSKEY =1 AND b.EMPLOYEEID IS NOT NULL AND b.SYSTEMUSERNAME IS NOT NULL order by userkey;
09/04/2022 10:18 PM
Hi Yogesh,
Thanks for reaching out to us
USERSHISTORY table stores all the data from Update History tab of users where we can see the changes that happened to an identity.
The user attributes changes are inserted as LONGBLOB type in "CHANGELOG" column which can't be decrypted in an understandable manner through reports.
You can write query to get your desired results.
User History information is stored as a blob and not available OOB.
Thanks & Regards
Srinivas
09/16/2022 06:43 AM
Are there any plans to make the audit data reportable?
This is not the first time a customer has asked for this data for audit purposes. They're not satisfied when we have to tell them that the data they see in a user's history is not reportable and can be only checked one by one manually through UI.
They really like how Saviynt shows them a user's history with full details of their attribute changes but it's always a bummer when it is not easily reportable for bulk users.
THE most common ask is always to get a report for the users terminated on a certain date (i.e. status changed from 1-0)
09/16/2022 07:09 AM
If your authoratative data source is sending across the Term Date, then you should be able to write a report based off that date. For the ones which aren't it is a challenge.
You can pitch in your ideas/enhancement request on the ideas portal, if not already there : http://ideas.saviynt.com/