Creating queries for resource monitoring usage data

After you execute a test to collect resource monitoring usage data, you can create queries to retrieve the data.

Before you begin

You must have added resource monitoring sources to a project.

About this task

You can no longer view the monitoring usage data in graphs 3 minutes after completion of the test. However, you can create queries to retrieve the list of activities and events in your tests. You can use the following procedure as an example to create your own queries.

Procedure

  1. Follow these steps to filter the list of activities that are collected for a duration of less than 300 seconds:
    1. Click Activities.
    2. Enter 'Type is RMsource and duration < 300' in the Query filters field.
    3. Enter 'time ASC' in the Sort by field to sort data by ascending order.
    4. Click Run Query.
    5. Click Save as.
    6. Enter a name to identify the new query and click Save.
    The list of activities that are collected for a duration of less than 300 seconds is displayed in the query result table, and this list is sorted in an ascending order.
  2. Follow these steps to filter the list of observations that are performed during a test execution and defined by the test result identifier:
    1. Click Events.
    2. Enter the following filters in the Query filters field:

      type is observation and anyParentActivity matches ( anyChildActivity matches (requesterNature = 'test-result' and requesterId=1202 ))

    3. Enter 'time ASC, parentActivity.description ASC, specifier ASC' in the Sort by field to sort data by ascending order.
      Note: You can use the Ctrl-Space keyboard shortcut to enter the properties and operators.
    4. Click Run Query.
    5. Click Save as.
    6. Enter a name to identify the new query, and then click Save.
    The new query results are displayed in the table of activities and events.
  3. Follow these steps to manage your query:
    • Click the action menu action menu that is next to the Save button and select Reset if you have just modified a query and you want to undo your modification.
    • Click the action menu action menu and select Delete to delete the new query from the Events and activities queries list.
  4. Follow any of these steps to configure the query result table:
    • Click the action menu action menu in a column of the table to change the column display, and then perform any of the following actions:
      • Click Insert new column, enter a field name in Search new column and click Add.
      • Click Move to move a column in the table.
      • Click Remove to remove a column from the table.
    • Follow these steps to add a column at the end of the table:
      1. Click Add column.
        Result: A window opens.
      2. Enter a field name in Search new column.
      3. Click Add.
  5. Click Save to save the configuration of the results table.

Results

You have created two queries in your project to display:
  • The list of activities that are collected for a duration of less than 300 seconds.
  • The list of observations that are performed during a test execution and defined by the test result identifier.