Send email even if Analytics Report count is 0 (zero)

[yashpalsingh]

Hi Team,

Is there a way to send email even if analytics report count is 0. Saviynt version - 5.5SP3.10

Regards,

Yashpal

[sk]

No, analytics won't send the email when there is no data. Can we understand the use case to assist you better?

[yashpalsingh]

Customer wants the report even if the count is 0 for their audit purpose.

[rushikeshvartak]

<%if (totalRecords.equals(0)) print "${ownerEmail}" else print "${ownerEmail}" %>

[yashpalsingh]

I tried as you suggested, but it didn't work.

[rushikeshvartak]

what is error you are getting canyou print variable and see what value u getting

[dgandhi]

Hi @yashpalsingh 

OOTB I don't think Saviynt will send email attachment if output of query is 0.

I am just thinking out loud, just see if that helps.

Union your actual query with one dummy query which always gives 1 record as output.

So in case where the output of your actual query is 0, the query which was union will give one record in output and hence the email notification with report attachment will be triggered for that one dummy record. Obviously the auditors needs to be aware that one record is dummy record and no action is needed.

Thanks

[yashpalsingh]

Thanks Devang, for the workaround. Let me try that but I was thinking if there is any config required or fixed in the newer versions.

[sk]

@yashpalsingh No there is no such config that will let you send email without any records. Like @dgandhi mentioned you have to make it work with workaround 

[Manu269]

@yashpalsingh Saviynt OOTB feature does not send email with 0 data.

Although there has to end user training performed to perform workaround.

[BrandonLucas_BF]

I actually have an analytic that does send out an email with zero results, and I don't want it to do so. I am not sure why this is occurring but may have been introduced with version 23.3 or 23.4.