Using the query editor

Edit online

By adding panels to dashboards, you can effectively present your data in a visual format. Each panel must require at least one query to display a significant visualization.

Procedure

  1. Identify the dashboard for which you want to add visualization.
  2. Perform one of the steps described in the following table:
    Step description Step #
    If there are no panels added to the dashboard Perform step 3.
    If at least one panel is added to the dashboard Perform step 6.
  3. Click + Add visualization to add visualization to your data.
    Note: The navigation of the user interface can differ based on the Grafana version that is currently installed.
  4. Select the data sources from the Data source drop-down list.
    The Edit panel is displayed.
  5. Go to step 8.
  6. Click Add > Visualization from the dashboard header.

    adding visualization

    The Edit panel is displayed.
  7. Select the data sources from the Data source drop-down list.
  8. Enter a name for the panel in the Title field.
    Optionally you can also provide a description for the panel that you are creating.
    Tip: When you add the description for the panel, a notification icon Notification icon is displayed after the Panel title.
  9. Select one of the visualization types from the drop-down menu:
    Visualization drop-down list
    Tip: You can choose built-in Grafana visualization types from the drop-down list.
  10. Select the data sources from the Data source drop-down list.
  11. Click the Query tab and provide the following details for the Metrics:
    Options Actions
    Application Select the OMEGAMON product from the Application drop-down list for which you want to monitor the data.
    Attribute group Select the attribute group of the corresponding application from the Attribute group drop-down list.
    Managed systems Select the system to retrieve collected data from the Managed systems drop-down list.
    Note: The Managed systems can accept variables.
    Group by Optional: Use the Group by option to group the result set based on the selected value.
    Display attribute names Select the attributes to be displayed in the graph from the Display attribute names drop-down list.
    Filters Optional: Use the Filters option to narrow down the data of your interest when requesting a list of values.
    Perform the following steps to create a filter:
    1. Expand the Filters option.
    2. Click Create filter.
    3. Choose the attribute from the drop-down list.
    4. Select the one of the operator from the drop-down list.
      The available operators are as follows:
      Operators Meaning
      = Equals to
      < > Not equals to
      < Less than
      < = Less than or equal to
      > Greater than
      > = Greater than or equal to
      LIKE The value is similar to specified pattern.
      Note: The LIKE option supports wild card using *.

      For example, CICS*
    5. Enter a value for the chosen filter.
      Note: The Filters can accept variables.
    Remember: You can click the + icon and choose between AND or OR to add multiple filters to the query. You can also delete any unnecessary filters using the Delete icon.
    System.Parma Optional: Use the system parameters to manage different aspects of system operation and performance.
    Perform the following steps to define a system parameter:
    1. Expand the System.Parma option.
    2. Enter the parameter name in the designated field.
    3. Input the desired value in the corresponding field.
      Note: The System.Parma can accept variables.
    4. Specify the length of the parameter.

    For instance, if you have set TIMEOUT as a system parameter with a value of 300, this timeout value will be passed to TEMS to override the default settings of 55 seconds.

    Remember: You can delete any system parameter you have added using the Delete icon.
    Order by Use the Order by option to arrange the attribute values in either ascending or descending order.
    Get near-term history data Enable the Get near-term history data setting The toggle icon to ON to retrieve historical data from the persistent data store.
    Formula When you choose values, they appear as a query in the Formula section. If you change the options, the query in the Formula section is updated accordingly.

    You can adjust the values by modifying the query from the Formula section. You must click the Update Query Editor Form to change the corresponding options; otherwise, changes you made in the Formula section will be lost when you save the Panel.

    Alternatively, you can copy the query directly from Tivoli Enterprise Portal (TEP) and E3270 user interface and paste it into the Formula section, rather than selecting each value individually from the available options.
  12. Click the Time Picker drop-down list to select relative time range options and set custom absolute time ranges.

    The time picker option

  13. Click the Refresh dashboard The Refresh icon icon to query the OMEGAMON data source.
    Grafana provides you with a preview of your query results along with the corresponding visualization.
  14. Optional: Click Apply to view your changes applied to the dashboard.
  15. Click Save, and then enter a note describing the changes you have made.
  16. Click Save to store the changes made to the dashboard.

Results

You have applied visualization to your data.

What to do next

Grafana provides a range of visualizations that cater to different use cases. For more information about the built-in panels, options, and typical usage, refer to the Grafana documentation.

You can also configure the panel options based on your requirements. For more information refer to the Grafana documentation.