Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Sending terminated user report through analytics failure

sb17gds
New Contributor III
New Contributor III

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

 

13 REPLIES 13

NM
Esteemed Contributor
Esteemed Contributor

@sb17gds share the email template.


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

sb17gds
New Contributor III
New Contributor III

<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>

pmahalle
All-Star
All-Star

@sb17gds Did you check the logs, is there anything in logs? Share the logs.


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂

sb17gds
New Contributor III
New Contributor III

Still going through logs but havent found anything special

NM
Esteemed Contributor
Esteemed Contributor

@sb17gds can you please send it in txt format.


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

sb17gds
New Contributor III
New Contributor III

Here you go

NM
Esteemed Contributor
Esteemed Contributor

Hey @sb17gds I meant logs .. email template is fine ..


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

sb17gds
New Contributor III
New Contributor III

Sorry, here you go

NM
Esteemed Contributor
Esteemed Contributor

@sb17gds does seem to have relevant entries.. can you run the analytics again and share logs


If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'

sb17gds
New Contributor III
New Contributor III

Ran the analytics again and pulled advanced logs this time.

Analytics key is 936

sb17gds
New Contributor III
New Contributor III

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

sb17gds
New Contributor III
New Contributor III

And found this in logs

sb17gds_0-1728387078634.png

 

sb17gds
New Contributor III
New Contributor III

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