Creating another query to the monitoring server

Use this method to createCloud Pak System Software Monitoring Server queries and to create queries similar to existing ones.

Before you begin

Your user ID must have permission for Modify Query and for Workspace Author Mode. If you do not see the Queries tool, your user ID does not have View or Modify Query permissions. If you can see the tool but it is disabled, your user ID does not have Workspace Author Mode permission. If you can open the Query editor but the tools are disabled, your user ID does not have Modify Query permission.

If your product has been upgraded to a new release, with new attributes or attribute groups added, and you see no new attributes in the query or queries for that attribute group or you see no query for a new attribute group, do not use these steps. Instead, use the procedure for creating a new query.

Procedure

  1. Complete one of the following steps to open the Query editor:
    • Click Queries.
    • In the title bar of the table or chart view where you would like to apply the new query, click Properties >   Click here to assign a query.
  2. Click expand to expand the Monitoring agents and attribute group folders to see the queries.
  3. Find a query similar to the one you want, select the query and click Create Another Query.
  4. In the Name field, type a name of up to 32 letters, numbers, underscores (_) and spaces, then click OK.
    A duplicate of the original query is displayed with the name you entered.
  5. In the Description field, type a new description.
  6. Edit the specification for any changes you want to make:
    • Add an attribute to the query by clicking Add Attributes and selecting the attributes you want to include. The attributes available are from the group used in the original query.
    • Remove an attribute by right-clicking the column heading and clicking Delete. (You can also right-click a row and delete it.)
    • Include an attribute in the filter, but do not retrieve it by clearing Disabled check box that column.
    • Clear the filter criteria by right-clicking the cell, column, or row, and clicking Clear Contents.
    • Insert a row by right-clicking the row and clicking Insert.
    • Cut, copy, or paste by right-clicking the cell or row and clicking Cut, Copy, or Paste. When you paste, the contents of the clipboard overwrites the cell or row.
    • Add filter criteria by clicking in a cell and writing the expression.
    • Add a column function by clicking in the column heading and selecting a function from the list; then click Advanced and select the column to Group By.
    • Specify a sort order by clicking Advanced, and selecting the column to Sort By. Note that if you selected a Group By column, you cannot also specify a sort order.
    • Adjust column order by dragging a column heading and dropping at the insertion point.
    • Restrict the rows (data series) that show in the table view or bar chart to a specific number. Restrict the first rows retrieved from the monitoring agent or the most recent (last rows) by clicking Advanced, selecting First or Last, and specifying the the number or rows to retrieve.
  7. Optional. If you opened the Query editor from the view properties, you can change the list of managed systems the query will extract data from.
    1. Click the Query Results Source tab.
    2. Select Let user assign explicitly, then remove managed systems from the Assigned list and add them from the Available list.
    Regardless of the managed systems assigned to a query, a gauge chart can show data from only one managed system. If you are using the query in a workspace where multiple systems are applicable, such as at the Enterprise- or Platform level of the Navigator Physical view, the data shown is from the first managed system in the Assigned list.
  8. When you are finished, click Apply to save the query and keep the window open or click OK to save the query and close the window.
    If you opened the Query editor from the Properties window, clicking OK also selects the query for the current view.