Administrator Guide

Create a Threshold Query
Create a threshold query to test threshold definition settings against historical data. New queries can be run immediately or saved for
future use.
Steps
1. Click the Threshold Alerts view.
2. Click the Queries tab.
3. Perform the following steps in the Save Query Filter Values pane:
a) Click New. If the New button is grayed out, skip to step b.
b) Type a name for the query in the Name field.
c) To make the query available to other Storage Manager users, select the Public checkbox.
4. Perform the following steps in the Query Filter pane:
a) Select whether the query is for all Storage Centers or a specific Storage Center.
• To select all of the Storage Centers for the query, select the All Storage Centers check box.
• To select a specific Storage Center for the query, clear the All Storage Centers check box and select a Storage Center from
the drop-down menu.
b) Select the type of query to create from the first Definition drop-down menu.
c) Select the type of storage object to query from the second Definition drop-down menu.
d) Select the type of usage metric to query from the third Definition drop-down menu.
e) Select the period of time to query the data from the Start Time drop-down menu.
f) Type the threshold value that the usage metric must exceed in the Threshold Value field.
g) To specify the number of times that the usage metric must exceed the threshold value, type a value in the Occurrences field.
To only return results that occurred in consecutively, select the Consecutive Occurrences check box.
5. Run or save the threshold query.
• To save the query for future use, click Save As. The threshold query appears in the Saved Queries tab.
• To run the query, click Run. The results of the query appear in the Query Results pane at the bottom of the Queries tab.
Run a Saved Threshold Query
You can select and run a saved threshold query.
Steps
1. Click the Threshold Alerts view.
2. Click the Queries tab.
The public and personal queries are displayed in the Saved Queries pane.
3. In the Saved Queries pane, double-click the query to run.
4. Click Run.
The results of the query are displayed in the Query Results pane.
Export the Results of a Threshold Query
The results of a threshold results can be exported to CSV, text, Excel, HTML, XML, or PDF file formats.
Steps
1. Click the Threshold Alerts view.
2. Click the Queries tab.
The public and personal queries are displayed in the Saved Queries pane.
3. Select a query from Saved Queries pane.
4. Click Run.
The results of the query are displayed in the Query Results pane.
5. Click Export.
The Export Query Results dialog box opens.
556
Threshold Alerts