To view a dashboard, right-click a server, or database and select Manage.

Server Properties Contains the properties of the server, including Version, Edition, Computer Name, and OS version.

Tasks Contains commons tasks such as Restore and New Query.

Search Databases Easily look up existing databases stored on the server, including tables.

Backup Status Easily look up the backup status for existing databases.

It is highly recommended that you follow the tutorial for setting up your dashboard, which can be found here.

In addition, make sure to check out the How-To on configuring insight widgets.

After following this tutorial, read on to learn more about specific widgets that are not covered in the tutorial.

The Insight details flyout provides more detailed information for a related insight widget.

• An Insight widget renders an at-a-glance summary view with count, line, chart etc.
• The Insight details flyout provides "drill in" details, listing deeper data insights for each item listed in the high-level Insight widget.
  • The details flyout contents are defined with a separate SQL query to the main widget's query.

There is no set requirement for an Insight details query, but the layout is standard.

• The top half of the view is always a 2-column "summary" view. Which columns to use are defined by the "label" and "value" properties of the JSON configuration
• On clicking on a row in the summary table, the bottom half of the flyout will list the full set of column information for that row.

Sample Insight Details flyout configuration

"details": {
    "queryFile": "./relative_path_to_sqlfile_from_package_json_file.sql",
    "label": {
        "icon": "database",
        "column": "first_column_name_for_summary_list_view",
        "state": [
            {
                "condition": {
                    "if": "equals",
                    "equals": "0"
                },
                "color": "red"
            },
            {
                "condition": {
                    "if": "equals",
                    "equals": "1"
                },
                "color": "orange"
            },
            {
                "condition": {
                    "if": "equals",
                    "equals": "2"
                },
                "color": "green"
            }
        ]
    },
    "value": "second_column_and_condition_check_value_column_for_summary_list_view",

With an insight widget and insight details, you can easily come up an action plan to mitigate an issue or manage. For example, you will think of executing DBCC CHECKDB, read error logs or Restore the database when a database is in a recovery pending. Or it can be any of actions that you wish to perform.

Using [!INCLUDEname-sos]'s Insight Actions configuration, you can map a built-in actions like restore, or bring your own action defined with a sql script.

Configuration of custom actions using sql script is under development and it is not available in the private preview build yet.

"actions"{} defines an insight action. Action can be defined over a specific scope such as "server", "database" and so on and [!INCLUDEname-sos] passes the current connection context information to the action.

For example, when restore action is launched for WideWorldImporters database, "database": "${Database}" definition indicates to pass Database column value in your query result to the restore action. Then restore action starts for the database. "types" is a json array and multiple actions can be listed in the array. It basically becomes a context menu on Insight Details dialog that user can click and perform the action.

[!INCLUDEname-sos] preview 0.17.1 has enabled "backup", "restore", "new-query" and "new-database" as action types.

"details": {
    "queryFile": "./sql/database_state_detail.sql",
    "label": {...},
    "value": "state",
    "actions": {
        "database": "${Database}",
        "types": ["restore"]
    }
}