LogoDark mode logo
LogoDark mode logo
Contact SupportLoading Light/Dark Toggle

    • AdventureWorks
    • Au2mator
    • Azure DevOps Analytics
    • Azure Virtual Machines Health
    • Jira Health dashboard
    • Kubernetes Monitoring dashboard (with Prometheus)
    • M365
    • Microsoft Dynamics AX 2012: System Information Dashboard
    • Microsoft Teams
    • Octopus Deploy
    • PagerDuty
    • Pingdom dashboard
    • Salesforce
    • ServiceNow
    • SolarWinds Orion: Nodes and their health status
    • SQLFacts
    • SQL Page Timeframe
    • SQL Samples
    • Symantec Endpoint Protection
    • Team Presence
    • Teqwave
    • Uptime Robot
    • VM Insights Metrics
    • VM Updates
    • VMware: Status of VMs
    • Zendesk Support
  • How to integrate and visualize your external data
  • How to create a dashboard
  • Recycle Bin
  • Working with perspectives
  • Action buttons for dashboards and perspectives
  • VADA perspective
  • How to scope tiles
  • Timeframes for tiles
  • Grid Designer
  • Performance Metric Labels
  • How to use wildcards in metrics
  • How to show multiple metrics on one graph (v4.2 and below)
  • How to use Custom Labels
  • How to use criteria when scoping alerts
  • How to use criteria when scoping objects
  • How to run SCOM tasks
  • How to enable graph color matching
  • Sharing Dashboards with anyone - Open Access

dashboardingdashboard packssqlfacts

SQLFacts

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 shows data from custom tables there were created using the SQLFacts utility. The SQLFacts utility must be configured and running before importing the SQLFacts dashboard for data to appear.

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 SCOM

    New to SquaredUp?

    Try it for free

  2. Download and import this dashboard pack.

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

    2. In DS for SCOM go to the top right hand menu ☰ > Import Dashboard Packs and drag the zip file into the Manual Import box.
    3. 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.
    4. 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.
    5. Edit the imported dashboard as required.

  3. Within SquaredUp DS create a new SQL provider called SQLFacts that points to the database where you installed SQLFacts.

    1. Make sure you have access to the database you want to use.

      Access to the SCOM Data Warehouse

      Access to the SCOM Data Warehouse is configured during the SquaredUp DS setup process. If you are able to see graphs in SquaredUp DS, SQL queries have access to the SCOM Data Warehouse (see How to check and reconfigure the Data Warehouse connection).

      Access to other databases

      To be able to query other databases, such as the Operations Manager database, the SquaredUp DS application pool identity needs to be given the db_datareader role in SQL Server Management Studio for the database you wish to query. See How to configure access to a database for use with the SQL tile.

    2. Provider name:
      Enter a name for your provider that makes it easy for you to identify. You can't change the name after you created the provider.
    3. Driver and Connection String:
      The connection string depends on your database and the driver you've chosen:

      If you want to connect to the SCOM Data Warehouse:

      Tip: SquaredUp DS already comes with a default SQL provider that connects to your Data Warehouse, so you don't need to create a provider for this connection. In case you deleted this provider, you can always recreate it with the following connection string:

      global:dw

      If you want to connect to the Operations Manager database:

      Server=<SQLservername>;Database=<OperationsManagerDatabaseName>;Integrated Security=True;

      If the SquaredUp server and SQL server are in the same domain you can just use the SQL server name, if they are not in the same domain you should use the fully qualified domain name.

      Tip: If the Operations Manager database is on the same server as the Data Warehouse you can use the Data Warehouse provider in your tiles, but you need to remember in the Query panel that you have to put the following in front of the query:
      USE <OperationsManagerDatabaseName>;

      If you want to connect to any other data base:

      With integrated security:

      Server=<SQLservername>;Database=<DatabaseName>;Integrated Security=True;

      With username and password:

      Server=<SQLservername>;Database=<DatabaseName>;User Id=<username>;Password=<password>;

      If the SquaredUp server and SQL server are in the same domain you can just use the SQL server name, if they are not in the same domain you should use the fully qualified domain name.

      If you want to specify an instance

      Server=<SQLservername>\\<InstanceName>;Database=<DatabaseName>;Integrated Security=True;

      Example:

      Server=SQLServer1\\Main;Database=CRMDB;Integrated Security=True;

      If you want to specify a port

      Server=<SQLservername>,<PortNumber>;Database=<DatabaseName>;Integrated Security=True;

      Example:

      Server=SQLServer1,51433;Database=CRMDB;Integrated Security=True;

      Note: You need to use 64-bit ODBC drivers.

      Note: When an SQL tile uses an ODBC provider, you can't use mustache values for your queries in that tile.

      If you are using an ODBC driver

      After you've set up your ODBC driver in Windows on the SquaredUp server, add the following at to your connection string:

      Driver=<Name of your ODBC driver>;

      Example:

      Driver=<ODBCdriverName>;Server=<SQLservername>;Database=<DatabaseName>;User Id=<username>;Password=<password>;

      If you are using a System DSN

      Note: You need to use a System DSN, not a User DSN.

      After you've set up your System DSN in Windows on the SquaredUp server, enter the following instead of a connection string:

      DSN=<Name of your System DSN>;

      DSN=<DSNname>

    4. Click save to save your new provider.

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

Was this article helpful?


Have more questions or facing an issue?
Submit a ticket

On this page

  • Description
  • How do I import and configure this dashboard?

Footer

Sites

  • SQUAREDUP
  • SQUAREDUP DS
  • DOWNLOAD
  • COMMUNITY ANSWERS

Quick Links

  • SUBMIT A REQUEST
  • EVENTS
  • CAREERS

Small Print

  • PRIVACY POLICY
  • TERMS AND CONDITIONS
Youtubex (Twitter)LinkedIn

© SquaredUp 2025