2 minute readApplies to: v4

How to export performance data to Excel

Overview

Squared Up shows performance data collected by SCOM and stored in the SCOM Data Warehouse (DW) (this includes the raw, near-real time data as well as the historical data). For more information see How to use the Performance Tile.

If you are unable to see performance graphs in Squared Up take a look at Troubleshooting the Data Warehouse connection.

Walkthrough: Exporting performance data

  1. In Squared Up browse or search and open a server page, for example a SQL server.

    Performance Graph

  2. Below the name of the server is a ribbon listing all of the perspectives available for this server. On a server perspective that shows performance data, click on a line on one of the graphs.

    You are taken to a performance drilldown showing the graph full page, including the latest values.

    SQL Server Perspective

  3. Below the performance metric title is a ribbon listing different timeframes. Try clicking on increasingly larger timeframes.

    The all timeframe will show all data available in the SCOM Data Warehouse. This will vary depending on your DW retention period, but is typically 400 days.

    Squared Up shows the highest resolution data available for the whole timeframe, and automatically switches to using hourly and daily aggregates depending on the timeframe selected.

  4. To export the graph's data to Excel, click Export to Excel button at the top right of the page.

    Export to Excel

    Export to Excel

  5. Open the downloaded Excel file.

    Squared Up exports the data to Excel, and helpfully also draws a graph of the data in the Excel spreadsheet, which should look similar to the graph in Squared Up.

    Using the graph in the Excel spreadsheet you can easily add trendlines and other analytics. The raw data points are listed on a second worksheet called data.

    Add Trendline To Exported Data

Find out more

For a quick (2 min) video introduction to using the Performance tile (including exporting data to Excel) take a look at the webinar 'How to use Squared Up performance reporting features':

How to use the Performance Tile

Understanding the figures on Performance graphs

How to use wildcards in metrics

Troubleshooting the Data Warehouse connection

Squared Up Ltd. (c) 2018Report an issue with this article