Query for rule triggered

[NPY]

Hello,

I need a query that gives the list of users for whom a particular user update rule or technical rule have triggered. Could someone please help me with this query. 

Thank you

[rushikeshvartak]

SELECT u.username,
       u.userkey,
       yh.updatedby,
       ruleruns
FROM   usershistory uh,
       users u
WHERE  ruleruns LIKE '%Email Test Rushi%'
       AND u.userkey = uh.userkey

[NPY]

Hi @rushikeshvartak, thanks for the reply. I also wanted to limit it to certain time frame such as 30 days. How do I do it? I don't see this table exposed in data analyzer and don't know what the columns are.

Are there any documentations that gives the database schema with all the tables Saviynt is using (which may or may not be exposed in data analyzer) and relevant for us.

[rushikeshvartak]

Database schema does not added all table and columns please add feedback on documentation website 

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

[NPY]

I actually want the list of users for whom a particular userupdaterule ran in last 30 days.

[rushikeshvartak · Accepted solution]

SELECT u.username,
u.userkey,
uh.updatedby,
uh.ruleruns
FROM usershistory uh
JOIN users u ON u.userkey = uh.userkey
WHERE uh.ruleruns LIKE '%Email Test Rushi%'
AND uh.updatedate >= CURDATE() - INTERVAL 30 DAY;

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

columns https://forums.saviynt.com/t5/identity-governance/what-are-the-columns-available-for-quot-usershisto...