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]

Hi Gaura,

Just to add what you mentioned, one has to use type excel for the other reports..

Yes, also included   in email from the related list can be used,which would pre-set the   include with field to the report.

[shaik_irfan]

I know that we can sent multiple reports on a single email but our client needs all reports to be in 1 excel sheet

Since we merge 7 to 8 reports in a single excel daily and email our client, when we update them that we can make automate by setting scheduled reports they are asking us to merge all reports in 1 excel and that 1 excel sheet should be sent to the cient.

Any guesss ?

[Sharique Azim]

Oh well ,then i am certain you cannot!!

[Gaurav Bajaj]

If that's the requirement, then you might need mid server and some other scripting application( Java platform etc) which can read all the reports and merge them into one file.

Then you can attach the file back to ServiceNow instance which can be sent as per scheduled jobs.

This will take a lot of scripting efforts not limited just to ServiceNow as it certainly not feasible with OOB features.

Thanks

Gaurav

[shaik_irfan]

Well thank you for both Shariq & Gaurav..

Gaurav it is best to do it manually instead of writing bunch of scripting including Mid servers etc...