How to automate reports

[shaik_irfan]

Hello Everyone,

We generally send email to our manager will all open incidents, p1 incidents. open problems, p1 problems & unassigned tickets to specific group.

For which daily i run the report and export to excel filter all reports in 1 excel and later i send it to my manager, i want to make it automate which i can do but my issue can i automate all the reports to be sent as 1 Excel sheet ???

[Sharique Azim]

Read this :

Schedule a report

In the scheduled reports, specify the type as excel (works only for list type of reports).

[shaik_irfan]

Thanks Shariq but the above link is not working

[Sharique Azim]

Updated link:

Schedule a report https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/reference-pages/task/...

I requestyou to read about it first.

[Gaurav Bajaj]

HI Sharik,

You cant merge them in one excel sheet although you can schedule a daily report which will be mailed to your manager every day and you can include several reports in one email.

You need to see

http://wiki.servicenow.com/index.php?title=Scheduling_and_Publishing_Reports#gsc.tab=0

and then you can use "include with" feature to club all reports in one email.

Please mark correct/helpful based on the impact of the response.

Thanks

Gaurav