Administrator Guide

c Specify whether or not to make the query available to other Storage Manager users by selecting or clearing the Public check
box. By default, a new query is a personal query and is not available to other users.
4 Perform the following steps in the Query Filter pane:
a Select whether the query is for all Storage Centers or a specic Storage Center.
• To select all of the Storage Centers for the query, select the All Storage Centers check box.
• To select a specic 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 rst Denition drop-down menu.
c Select the type of storage object to query from the second Denition drop-down menu.
The available storage objects are dependent on the type of query selected in step b.
d Select the type of usage metric to query from the third Denition drop-down menu.
The available threshold metrics are dependent on type of query selected in step b and the type of object selected in step c.
e Select the period of time to query the data from the Start Time drop-down menu.
f Enter the threshold value that the usage metric must have reached in the Threshold Value eld.
g To specify the number of times that the usage metric must have reached the threshold value, enter a value in the Occurrences
eld.
To only return results that occurred in sequence, 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 run a saved query without changing the query. You can also use a saved query as a starting point and modify it as needed.
1 Click the Threshold Alerts view.
2 Click the Queries tab. The Queries tab appears.
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 appear in the Query Results pane.
Export the Results of a Threshold Query
Threshold query results can be exported to CSV, text, Excel, HTML, XML, or PDF.
1 Click the Threshold Alerts view.
2 Click the Queries tab. The Queries tab appears.
The public and personal queries are displayed in the Saved Queries pane.
3 Select a query from Saved Queries pane or create a new query
4 Click Run.
5 Click Save Results. The Save Results dialog box appears.
6 Select a le type for the output: CSV (.csv), Text (.txt), Excel (.xls), HTML (.htm), XML (.xml), or PDF (.pdf).
7 Click Browse to specify the le name and location to save the le.
8 Click OK. The results of the query are exported.
Related link
Create a Threshold Denition
Create a Threshold Query
Storage Center Threshold Alerts
619