- My View
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).
Thanks Deep K! I was able to copy out the queries using this method, much appreciated!!
Please refer the link below.
PS: Hit like, Helpful or Correct depending on the impact of the response
Hit correct/helpful based on impact.
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!