Creating a Query

You can create two types of Queries in JAMS to help you filter the data that is displayed:

• Monitor Queries
• History Queries

Accessing Query Management

1. Expand the Execution option in the main menu.
2. Click Query Management.

Query Management screen

• Query Name – This option is the name of the Query.
• Description – This option is an optional summary of the Query and its Filters.
• Type – This option defines the screen where the Query will be used. This can be displayed in the Monitor or History screen.
• Default – This option displays a checkmark icon if the Query is set as a default Query.

Adding a Monitor Query

You can create a Query to filter the data that is displayed in the Monitor to help ensure you find the information you need. You can modify the steps to build additional Queries or add other Filters.

1. Open the Query Management screen.

2. Click Add.

3. In the Query Name field, enter a name for the Query.

4. In the Query Type field, select Monitor.

5. Click Save and Continue to Edit.

6. Optional - On the Summary tab, click SET DEFAULT to pin the Query to the top of the drop-down menu in the Monitor.

7. Click the Filters tab.

8. Add a Filter for the Agent:

   1. Click + Add Filter.
   2. Select a Filter from the drop-down menu. In the screen capture below, we've used Executing Agents.
   3. Click APPLY FILTERS. The empty Filter displays "0 filter applied".
      
   4. To set a value for the Filter, click on the Filter named Executing Agents.
   5. Select the Agent type and Agent name.
      
   6. Click + ADD FILTER. The Filter Value is displayed.
      
   7. Click Apply to add the Filter Value.

9. Repeat these steps to add additional Filters as needed.

10. Click Save. The Query is now ready to use.

Viewing the Query in the Monitor

After the Query is added, you can quickly go to it and view it in the Monitor.

1. From the Query Management screen, go to the row for the Query you created.
2. Click under the Actions column for the Query.
3. Select View in Monitor. The Monitor screen is opened with the Query selected.
4. Verify that you see the desired data.

Adding a History Query

You can create a Query to filter the data that is displayed in the History to help ensure you find the information you need. You can modify the steps to build additional Queries or add other Filters.

1. Open the Query Management screen.

2. Click Add.

3. In the Query Name field, enter a name for the Query.

4. In the Query Type field, select History.

5. Click Save and Continue to Edit.

6. Optional - On the Summary tab, click SET DEFAULT to pin the Query to the top of the drop-down menu in the History view.

7. Click the Filters tab.

8. Add a Filter for the Completion time:

   1. Click + Add Filter.
   2. Select a Filter from the drop-down menu. In the screen capture below, we've used Past Window.
   3. Click APPLY FILTERS. The empty Filter displays "0 filter applied".
      
   4. To set a value for the Filter, click on the Filter named Past Window.
   5. Enter 01:0:00 for the Time and CompletionTime for the Category.
      
   6. Click + ADD FILTER. The Filter Value is displayed.
      

9. Repeat these steps to add additional Filters as needed.

10. Click Save. The Query is now ready to use.

Viewing the Query in the History

After the Query is added, you can quickly go to it and view it in the History.

1. From the Query Management screen, go to the row for the Query you created.
2. Click under the Actions column for the Query.
3. Select View in History. The History screen is opened with the Query selected.
4. Verify that you see the desired data.

Query Management Properties

Summary Tab	Description
Query Name	This option is the name of the Query.
Query Type	This option defines the screen where the Query will be used. This can be displayed in the Monitor or History views.
Default	This option displays a checkmark icon if the Query is set as the default Query.
Description	This option is an optional summary of the Query and its Filters.
Last Changed	The Last Change property displays the date and time the Query was last modified.

Filters Tab	Description
Add Filter	This option is used to add one or more Filters to a Query.
CLEAR ALL	This option is used to remove all Filters from a Query.