Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/26/2024 12:15 PM
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
Solved! Go to Solution.
08/26/2024 01:04 PM - edited 08/26/2024 01:04 PM
SELECT u.username,
u.userkey,
yh.updatedby,
ruleruns
FROM usershistory uh,
users u
WHERE ruleruns LIKE '%Email Test Rushi%'
AND u.userkey = uh.userkey
08/26/2024 01:52 PM
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.
08/26/2024 03:32 PM
Database schema does not added all table and columns please add feedback on documentation website
08/26/2024 02:01 PM - edited 08/26/2024 02:10 PM
I actually want the list of users for whom a particular userupdaterule ran in last 30 days.
08/26/2024 02:36 PM - edited 08/26/2024 02:39 PM
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;