SQL Samples

This article describes how to download a specific dashboard pack. You can download dashboard packs from dashboards.squaredup.com and learn more about how dashboard packs work here: Dashboard Packs

Description

This dashboard demonstrates how the same base SQL query could be used with each of SquaredUp DS's visualizations. Each SQL visualization slightly modifies how the data from the OperationsManagerDW database is presented to target user requirements. For example, a Status Block to quickly show health or a spark line to show how something has changed over time. The same data source, seven different SQL visualizations!

How do I import and configure this dashboard?

  1. Ensure you're using SquaredUp DS v5.4 or above.

    Already a SquaredUp customer?

    Get the latest version of SquaredUp DS for Azure

    New to SquaredUp?

    Try it for free

  2. Download and import this dashboard pack.

  3. Replace the connection string in each of the seven SQL tiles with the connection string to your own OperationsManagerDW database.
    1. Edit the tiles by clicking the Edit button.
    2. Open the connection panel.

    3. Enter the connection string to your own OperationsManagerDW database, for example
      Data Source=fqdn.site.domain.com;Initial Catalog=OperationsManagerDW;Integrated Security=True
  4. Publish the dashboard.

Was this article helpful?


Have more questions or facing an issue?