Analytics Report

[Chirag_Gupta]

Hello Everyone

How can I generate a report to check if any user attributes have been updated in the last 24 hours, but only for specific attributes and not all of them?

Thanks,

Chirag

[pmahalle · Accepted solution]

Hi @Chirag_Gupta ,

Execute below query in the analytics will give all the updates for the user in the CHANGELOG column.

Run this query from the analytics tab in order to get the information.

SELECT 
    u.username, u.firstname, u.lastname, uh.updatedate as 'Update Date', uh.changelog
FROM
    users u
        INNER JOIN
    usershistory uh ON u.userkey = uh.userkey 
where u.username='<Provide username here>';

Note: It will not work in Data analyzer and even in analytics preview mode.

[Chirag_Gupta]

Is there a way to obtain information about which specific attribute was changed?

[rushikeshvartak]

No. You need to filter manually

[rushikeshvartak]

You can check using userhistory table but till v24.4 data is visible in encrypted format and it’s working in v24.5

Doc - https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

Refer https://forums.saviynt.com/t5/identity-governance/usershistory-table-changelog-blob-data-is-not-read...