4 Replies · Latest reply on Nov 14, 2016 1:02 PM by Andrew Kochinski

    How to Link a Service Now Report to Excel?

      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).