How to get a report on user update history

[yogesh]

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?

[rushikeshvartak]

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;

[Srinivas]

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

[yogesh]

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)

[avinashchhetri]

@yogesh,

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/