Exporting the report - Automatically

[shiju]

I have few report on ServiceNow portal, I frequently pull the report manually, export it to excel and import into a database for further analysis. Is there a way to automate the downloading part from servicenow portal without any additional privileges.

Thanks,

Shiju

[Atul Kumar2]

Hi Shiju,

You can create a scheduled jobs in the service now and it will send the report to the specific email address or to the group member in servicenow.

Steps.

1. go to system definition
2. schedule jobs
3. select the template for your requirement
4. create the schedule jobs and fill the required details as per your need and you would be good to go.

Creating a Scheduled Job - ServiceNow Wiki

Hope this helps.

Regards,

Atul Kumar

[tony_barratt]

Hi Shiju,

Here are a couple of useful links

from the Geneva docs

Schedule a report

From the per-Geneva wiki (has video)

Scheduling and Publishing Reports - ServiceNow Wiki

Best Regards

Tony

[Goran WitchDoc]

Hi,

Edit your report. Make sure it's a "list" report, otherwise change it and save. If it isn't a list-report you won't be able to attach the report as a excel-file, only PDF and picture-formats.

Click on the arrow next to save and choose schedule.

then just fill in the fields and save and you got mail when you want

[shiju]

Thanks for your replies! those are helpful. I wondering is it possible to connect to servicenow portal programmatically to download the report and import into SQL Server. Getting into mailbox requires me to write additional code to download it from the mailbox and import.