Dashboard Packs
SQL Samples Dashboard
Sometimes, visualizing something is harder than getting the data. This dashboard was designed to demonstrate how the same base SQL query could be used with each of SquaredUp’s visualizations. Each SQL visualization slightly modifies how the data 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!
Challenge
The challenge was to use one basic SQL query and demonstrate different ways to visualize that query using SquaredUp's native visualizations.
Solution
When working with a customer, the SQL visualization requirement kept changing because the target audience kept changing. In order to demonstrate how flexible SquaredUp is, we needed to build a dashboard that displayed storage information using each of SquaredUp’s native visualizations.
Each tile contains the same “base” SQL query, though for some SQL visualizations, a subsequent query is needed to reformat the data for the visualization.
Please note, even though the SCOM Data Warehouse was the target database, it is not required. Any relevant data from a SQL database can be visualized.
Dashboard walk-through
Each tile on the dashboard is a different SquaredUp visualization. Here is how it breaks down:
Tile 1 (Donut) - Case statement for the Donut tile to group and summarize on.
Tile 2 (Bar), 3 (Grid), 4 (Status Block), 5 (Status Icons) – A simple select statement to limit results.
Tile 6 (Sparklines), and 7 (Graph) – A second query to retrieve performance data.
How do I import and configure this dashboard?
Ensure you're using SquaredUp DS v5.4 or above.
Already a SquaredUp customer?
Get the latest version of SquaredUp DS for SCOM
New to SquaredUp?
Download and import this dashboard pack.
- Download the dashboard pack zip file for the dashboard pack you wish to import. There may be additional steps before or after the import to get the dashboard working in your environment.
- In DS for SCOM go to the top right hand menu ☰ > Import Dashboard Packs and drag the zip file into the Manual Import box.
- The dashboard pack is imported and if the pack contains top-level dashboards, these will automatically appear in the navigation bar, usually in a folder called 'Community Dashboards' for dashboard packs from the SquaredUp Community. If the dashboard pack also contains perspectives (see Working with perspectives), then you'll see these when you drilldown to the relevant object.
- Carry out any additional steps required to make the dashboard work in your environment. These steps will be described on the download page for each dashboard. For example, you may need to create the correctly named Web API provider, create a PowerShell profile, or edit tile collections.
- Edit the imported dashboard as required.
- Download the dashboard pack zip file for the dashboard pack you wish to import.
- Replace the connection string in each of the seven SQL tiles with the connection string to your own OperationsManagerDW database.
- Edit the tiles by clicking the Edit button.
- Open the connection panel.
- Enter the connection string
global:dw.
Publish the dashboard.
A newly created dashboard will not be visible to others until it is published.
Only admins can publish dashboards, unless you have been given author permissions to a Team Folder see Team Folders
If you made changes to an existing dashboard, the changes will only be visible to others after you published the dashboard again.
You can identify a dashboard that has not been published yet or has unpublished changes by the unpublished button at the top:
When you click on the unpublished button, you'll have two options:
- Publish will make the dashboard or changes visible to others.
Note: A newly created dashboard will appear on the menu where you created it. To move the dashboard to a different place on the navigation bar see How to edit the Navigation Bar. - Discard will delete your draft dashboard if it has never been published or, if you made changes to an already published dashboard, discard the changes.
Publishing dashboards to different audiences
Find out how to publish dashboards to a subset of users using Team Folders or visible to anyone even unlicensed users with Open Access (Sharing Dashboards with anyone - Open Access).
- Publish will make the dashboard or changes visible to others.
GET STARTED TODAY
Zero to dashboard hero in 60 seconds
Start now with hundreds of customizable dashboards.