SCOM 2012: SquaredUp SQL Query Dashboards

After SCU Europe 2015 I finally made it to install the latest version of Squared Up (2.1.x) in my development environment. There are already a lot great posts around about SquaredUp. Tao Yang is leading on that at the moment.

I really must say, I am amazed about how the product improved within the last year. It is very easy now to import/export dashboards, customize existing ones and create new rich dashboards. And there is a lot more to come, I already received some information about the next version ;-).

This week I played around with the SQL Query PlugIn and created two dashboards for my environment, which I want to share here.

  1. OpsManager Settings:
    This dashboard shows the current database usage and the grooming/retention settings of the OpsManager database and the OpsManagerDW.
    OpsMgr settings
  2. Last Month:
    This dashboard shows the top 20 alerts and the number of alerts by severity, both from the last month.
    Last Month

I have taken this information in the past from SCOM reports, with SquaredUp you can see the data very fast and share that information with other teams easily.

You can download the dashboard templates here:
Last Month
OpsManager settings

Please be aware, that you need to change the database connection string in your environment.


Published by


* 1974, female, working as a IT Senior System Analyst in a chemical company. Main topics: System Center Operations Manager 2012, System Center Orchestrator 2012, System Center Configuration Manager 2012. Monitoring servers since 2002, started with NetIQ Appmanager. Twitter: @NatasciaHeil

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s