Using Custom Queries to Generate Graphs - Server Management

Teradata Server Management Web Services User Guide

Product
Server Management
Release Number
12.08
Published
May 2018
Language
English (United States)
Last Update
2017-04-10
dita:mapPath
gym1510697168895.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-5350
Product Category
Hardware
Software
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.