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

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 to a server, for example a SQL server.

    If you don’t see one on a dashboard, use the Search… box on the navigation bar by typing part of the name of a SQL Server and clicking on a result.

    The resulting page is called a ‘drilldown’.

    SQL Server Perspective <>

  2. Below the name of the server is a ribbon listing all of the perspectives available for this server. Try changing perspective.

    If you have drilled down into a SQL Server the default perspective should be the SQL perspective. This shows key SQL performance metrics and shows the health of the SQL instances on the server.

    If you imported a HyperV or SQL Dashboard Pack earlier and this server is virtualised using that platform, you should also see a VM perspective, for example HyperV VM.

    The perspectives are defined in Dashboard Packs. By importing further Dashboard Packs you can gain new views on your monitoring data. You can also create your own perspectives, see Creating Perspectives.

  3. 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 last value and the statistics.

  4. 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 automatically switches to using hourly and daily aggregates depending on the timeframe selected.

  5. Click export at the top right of the page and open the downloaded Excel file.

    Export Performance Data <>

    Squared Up exports the data to Excel, but 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 trend lines 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’:

Understanding the figures on Performance graphs

How to use wildcards in metrics

Troubleshooting the Data Warehouse connection label: How to export performance data to Excel keywords: export performance data Excel spreadsheet exporting trendline trend-line table metrics exported tab