Dashboard Pack - SQLFacts
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?
Ensure you're using Dashboard Server v5.4 or above.
Already a SquaredUp customer?
New to SquaredUp?
Download and import this dashboard pack.How to import a 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 Azure Edition 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.
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 scopes.
Edit the imported dashboard as required.
Within Dashboard Server create a new SQL provider called SQLFacts that points to the database where you installed SQLFacts.How to add a SQL provider
Make sure you have access to the database you want to use.Configuring access to a database for an SQL provider
To be able to query databases, such as the Operations Manager database, the Dashboard Server 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.
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.
Driver and Connection String:
The connection string depends on your database and the driver you've chosen:Connection strings when you are using Microsoft SQL Server Driver
Connection string for any database:
With integrated security:Copy
With username and password:Copy
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 instanceCopy
If you want to specify a portCopy
Server=SQLServer1,51433;Database=CRMDB;Integrated Security=True;Connection strings when you are using ODBC
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>;
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>;Copy
Click save to save your new provider.
Publish the dashboard.How to publish a dashboard
A newly created dashboard will not be visible to others until you publish it. 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