SolarWinds UDT - Filtering and Grouping Data in Resources; SQL Syntax

For detailed information on creating a new report, see "Creating and Modifying
Reports".
Filtering and Grouping Data in Resources
You can reorganize and filter data within a resource using SQL or SolarWinds Query
Language (SWQL), a SQL-like filter syntax. The filter description on each resource tells
you whether to use SQL or SWQL.
Grouping Applications
The following procedure walks you through changing the way node data is grouped
in a resource.
To group resource data by category:
1.
Log on to the Orion Web Console.
2. Click the DEVICE TRACKER tab.
3. Click EDIT on the resource with the grouping you want to change.
4. Select the category that you want to group by from the Level 1 list.
5.
If you want to group by more subcategories, select additional categories from
the Level 2 and the Level 3 lists.
6. Click SUBMIT.
Filtering Data Using Filter Criteria
The following procedure explains how to limit the data sources in a resource by
setting filter criteria in SQL syntax. For more information about the filter syntax, see
"SQL Syntax"
To filter node data using filter syntax:
1.
Log on to the Orion Web Console.
2. Click the DEVICE TRACKER tab.
3. Click EDIT on the resource that you want to change.
4. Type your filter criteria in the Filter Nodes (SQL) field.
5. Click SUBMIT.
SQL Syntax
Some resources allow you to filter data using the SQL syntax described below.
98
Filtering and Grouping Data in Resources