Documentation forOrion Platform

Configure table widgets for modern dashboards

This topic applies to all Orion Platform products.

Watch SolarWinds Lab #93 on creating modern dashboards (46:48) | Read the THWACK Post

Table widgets display data or information in a tidy grid format. You can use them on modern dashboards.

Orion Platform 2020.2.5 updates for table widgets

  • Columns added by default

  • Options to search and sort data

  • Options to customize how often data is refreshed

  • If the table contains too many rows, only the visible ones are loaded to improve the performance. Once you hover over the table widget, a scroll bar is displayed and additional rows are loaded as you scroll down.

How to configure table widgets

  1. Specify the title and other details for the widget.
  2. Define data to be displayed.
  3. Customize columns for the table: click Add new column.
  4. Customize sorting and add search bar (optional, done in Presentation).
  5. Save Changes.

See Edit widgets for details on resizing widgets, changing widget position, or deleting widgets.

Step 1: Specify the title and other details for the widget

  1. In Presentation, expand Title and description.

  2. Provide the title and subtitle.

  3. If you want to have a link with more details on the widget, provide it in the Widget link URL.

  4. You can also provide a description that might help others to reuse the widget.

  5. Starting with Orion Platform 2020.2.5, you can also set how often you want data in the widget to refresh. See Refresh rate.

Step 2: Define the data to be displayed

  1. Expand Data and Calculations.

  2. Define the data model with the graphical query builder or manually.

    Use the graphical builder

    1. Select Use the graphical query builder and click Edit.

    2. Select the entity you want to display metrics for and click Next.

    3. Drag columns that contain the raw data you want to see in the widget.

    4. To display entities with specific values for one of the defined columns, click Add a filter and specify the values to be included.

    5. See your current settings in the Model preview.

    6. When you are satisfied with the preview, click Save model. Your settings are displayed in the data model and in the widget preview.

    Manually

    1. Select Hand-edit a SWQL Query and click Edit.

    2. Copy the following query into the SWQL query field and click Save model.

      Copy

      Select top 25 events (SWQL)

      SELECT TOP 25 COUNT(e.EventID) as value, t.Name as type
      FROM Orion.Events e JOIN Orion.EventTypes t ON e.EventType = t.EventType
      GROUP BY type ORDER BY value DESC
    3. The scripts are not supported under any SolarWinds support program or service. The scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.

Step 3: Customize columns for the table

Starting with 2020.2.5, columns mentioned in the Data model section are added automatically.

To add columns:

  1. Click Add new column.
  2. Expand Description and provide the label for the column. You can also specify a fixed width for the column or hide the column.
  3. Expand Property and formatting and specify the format for displayed data:
    OptionDescriptionExample
    No format

    Displays the value as is.

     
    Link Displays the value as a link. You need to specify the URL and the label to use links. 
    Simple number

    Displays numeric values. You can optionally prefix it with an icon and add text at the end.

    Status labelAutomatically maps numeric value on Orion Status.
    Threshold Value Shows numeric value together with metric (%, ms, ...) defined by selected threshold and linear bar chart (optional). The icon and color of value change, when exceeds specific threshold level.
    Orion EntityDisplays Orion entities as a clickable link with additional icon and entity status. You can either select the icon manually or use a vendor icon.
  4. When finished, save the changes.

Step 4: Specify sorting and search for table widgets (optional)

Starting with Orion Platform 2020.2.5, you can define sorting and add a search box for your table.

By default, the table is sorted by the value in the first column, in ascending order.

Customize sorting

  1. In Presentation, expand Sorting, and select the column to sort by in the drop-down.

    The values in the drop-down are labels you specified for your columns.

  2. To sort in descending order, select the Descending box.

Add a search box for the table widget

In Presentation, expand Search, and switch on the Enable toggle. This adds a search box at the top of the table widget. You search for data displayed in any of the columns.