Send notification after completion of task options

[GeSaviynt]

Hi Team,

Can you suggest approach to send notification after completion of tasks, not from global configuration and end-point level. Is there any option to send from report then please share the sample query and how to trigger notification and have to exculde few applications from notification for example notification will not triggered for birth right applications.

Thanks

[rushikeshvartak]

Query:

select username,taskkey from arstasks a,users u where a.status=3 and u.userkey=a.userkey and a.endpoint=1

Attach email template to report and click send email notification

Email Template 

To: ${userEmail}