Sending terminated user report through analytics failure

[sb17gds]

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

[NM]

@sb17gds share the email template.

[sb17gds]

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

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

[sb17gds]

Still going through logs but havent found anything special

[NM]

@sb17gds can you please send it in txt format.

[sb17gds]

Here you go

[NM]

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

[sb17gds]

Sorry, here you go

[NM]

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

[sb17gds]

Ran the analytics again and pulled advanced logs this time.

Analytics key is 936

[sb17gds]

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]

And found this in logs

[sb17gds · Accepted solution]

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