How to Link a Service Now Report to Excel?

[vanko]

I have a report already built in Service Now (showing details for incidents related to three specific configuration items), and I am trying to link this report to an excel file with automatic refresh capabilities. I was able to set up the query in excel and connect to the data source, but was unable access the specific information that my report in Service Now display. Can anyone advise how to copy a Service Now 'query' into an excel file?

FYI - I am exporting to excel because some of the visualizations I wanted to display were not possible within Service Now reports (for example, combining 'created' and 'resolved' date columns to display count of incidents that were either opened or closed per day, displayed as grouped bar charts).

[Deepak Kumar5 · Accepted solution]

Open the incidents in list view. Filter for your requirement result.

Copy the Query by right clicking on the filter.use this query to retrieve your data.

[vanko]

Thanks Deep K! I was able to copy out the queries using this method, much appreciated!!

[Harsh Vardhan]

Hi Andrew,

Please refer the link below.

Excel Spreadsheets with Live Connection to ServiceNow

Thanks,

Harshvardhan

PS: Hit like, Helpful or Correct depending on the impact of the response

[vanko]

Thanks Harsh Vardhan! This is very helpful, but I am still having slight difficulty setting up the sysparm_query language in Excel to match the filtering applied in my Service Now report. I'll do some additional research, and will post to this forum if I locate any useful information. Thanks again!