Documentation forOrion Platform

Configure table widgets for modern dashboards

This topic applies to all Orion Platform products.

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

See the THWACK post on modern dashboards for an overview of the feature.

How to configure table widgets

  1. Specify the title and other details for the widget.
    In Presentation, select sorting (optional) .
  2. Define data to be displayed.
  3. Configure what should be displayed in the first column: click Add new column.
  4. If you want to display more columns, repeat the previous step: click Add new column.
  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.

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.

      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: Specify a column for the table

  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.

Step 4: Add another column

  1. Repeat step 3 for each column you want to add to the table.
  2. When finished, save the changes.