Using Custom Queries to Generate Graphs

Teradata Server Management Web Services User Guide

brand
Hardware
Software
prodname
Server Management
vrm_release
12.07
category
User Guide
featnum
B035-5350-097K
Use the Measurement Graph Manager to create and work with custom queries. The custom queries retrieve information from the CMIC Measurement Database for the selected components and generate graphs based on the queries. You use the SQL Statement tab to edit the SQL statement generated from the options selected on the General tab. You can also edit, rename, and delete existing custom queries.
  1. From the Tree View, select one or more chassis.
    A message appears if you select a chassis that does not have sensors in common.
  2. Select Event Mgmt > Measurement Graph > Custom Queries. The Measurement Graph Manager dialog box appears.
  3. Do one of the following:
    Option Description
    Create a new custom query
    1. Click New.

      The Measurement Graph dialog box appears.

    2. Choose the sensor, graph, and time criteria options that you want to use.
      You can select only one unit of measurement from the Sensors list; for example, Amps. You can, however, expand the unit of measurement and select one or more individual sensors; for example, node or CMIC Power Supply : PS1 +12V Current.
    3. [Optional] If you want to edit the resulting SQL query, click the SQL Statement tab and select the Edit SQL check box.
      If you edit the SQL query, the Sensors and Time Options on the General tab are not available.
    4. Click Create Graph.
    5. Do one of the following:
      • Save the custom query or graph.
      • Close the graph without saving the custom query or graph.
      • To work with a different chassis or set of chassis, close the graph, and then click Cancel on the Measurement Graph dialog box, and repeat all steps.
    Edit an existing custom query
    1. Select an existing custom query, and click Edit.

      The Measurement Graph dialog box appears.

    2. Make the applicable changes on the General tab and, if applicable, the SQL Statement tab.
    3. Click Create Graph.
    4. Do one of the following:
      • Save the custom query or graph.
      • Close the graph without saving the custom query or graph.
      • To work with a different chassis or set of chassis, close the graph, and then click Cancel on the Measurement Graph dialog box, and repeat all steps.
    Rename an existing custom query
    1. Select an existing custom query, and click Rename.

      The Rename Query dialog box appears.

    2. Enter a new name for the query.
    3. Click Save.

      The new name appears in the Select Custom Query list.

    Delete an existing custom query
    1. Select an existing custom query, and click Delete.
    2. Click Yes to confirm.

      The custom query no longer appears in the Select Custom Query list.