Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/08/2024 01:43 AM
Hi Saviynt community
I've created a report for users who have been terminated through certification. The query is like this:
select u.username as 'TERMINATED USER USERNAME', u.employeeid as 'TERMINATED USER EMPLOYEE ID', a.username as 'MANAGER' from users u, users a where u.manager = a.userkey and u.statuskey = 0 and u.comments like '%Certification%'
The usecase is that it should be sent to a certain mailbox. The email format is like this:
Please initiate a high risk termination for ${ANALYTICSDATA.'TERMINATED USER USERNAME'}
Personnel Number: ${ANALYTICSDATA.'TERMINATED USER EMPLOYEE ID'}
Name: ${ANALYTICSDATA.'TERMINATED USER USERNAME'}
Supervisor Name: ${ANALYTICSDATA.MANAGER[0]}
I've currently addressed this to my personal mailbox as a test (and run the report) but haven't received anything yet. Is there a step I'm missing? Some job to run? Something in the email template?
Thanks in advance
Solved! Go to Solution.
10/08/2024 01:45 AM
@sb17gds share the email template.
10/08/2024 01:47 AM
<span>Please initiate a high risk termination for ${ANALYTICSDATA.'TERMINATED USER USERNAME'}</span>
<br><span>Personnel Number: ${ANALYTICSDATA.'TERMINATED
USER EMPLOYEE ID'}</span>
<br><span>Name: ${ANALYTICSDATA.'TERMINATED USER
USERNAME'}</span>
<br><span>Supervisor Name: ${ANALYTICSDATA.MANAGER[0]}</span>
10/08/2024 01:47 AM
@sb17gds Did you check the logs, is there anything in logs? Share the logs.
10/08/2024 01:48 AM
10/08/2024 02:10 AM
@sb17gds can you please send it in txt format.
10/08/2024 02:16 AM
10/08/2024 02:18 AM
Hey @sb17gds I meant logs .. email template is fine ..
10/08/2024 02:21 AM
10/08/2024 02:48 AM
@sb17gds does seem to have relevant entries.. can you run the analytics again and share logs
10/08/2024 03:12 AM
10/08/2024 04:27 AM
Just to add I've now made the same report into a runtime analytics and changed the to field to ${userEmail} and in cc my email.
Email is still not triggering
10/08/2024 04:31 AM
And found this in logs
10/08/2024 04:37 AM
Hi,
Just wanted to update that username was missing as a variable name. So added that in report:
select u.username as 'USERNAME', u.employeeid as 'USEREMPLOYEEID', a.username as 'MANAGER' from users u, users a where u.manager = a.userkey and u.statuskey = 0 and u.comments like '%Certification%'
It is triggering now.
Thanks for all your help everyone