scheduled reports to send to assignment group managers when the tickets are unassigned

[bhanu27]

Scheduled reports to send to assignment group managers when the tickets are unassigned or assigned to field is empty, how can we achieve it, please help me.

[AnveshKumar M · Accepted solution]

@bhanu27 you can include this report too, follow all the steps as is except Step 3: Mail Script.

Copy the sys_id of your report then in Step 4: Notification replace 

${mail_script:ag_unassigned_incident_report}

With

${report:reportID:YOUR_REPORT_SYSID}

This will include your report as PDF attachment in the notification email.

Please mark my answer helpful and accept as solution if it helped you 👍✅

[AnveshKumar M]

@bhanu27

Share the report with everyone (Share -> Everyone) and test the notification. 

[bhanu27]

Hi @AnveshKumar M  

I have shared the report with everyone, but still am getting same error, can you please let me know what to do, sorry for inconvenience.

Thanks & Regards

Bhanu. 

[AnveshKumar M · Accepted solution]

@bhanu27 Who is the run as user for Scheduled Job? And check the user which you are using to test (i.e. changing the assignment group) have access to table , are there any ACL restrictions (report type ACL also).

And try creating a new simple report and try to insert that in the code and check, whether you are getting the same error or not?

[bhanu27]

Hi @AnveshKumar M  can you please reply and do the needful.

Thank you very much

regards

Bhanu