Disk Arrays in CA Storage Resource Manager › Manage Disk Arrays to Generate Reports on SAN Storage › Manage and Generate Reports on SAN Storage › Defining a Query Service

Defining a Query Service

You can create a query using the Service Builder Wizard. The Service Builder Wizard contains predefined sets of sample services. After you complete the configuration steps, the service is ready to use. If you want to tailor a service, use the Query Service Builder Wizard to customize it.

The following example shows you how to query the database immediately for all EMC Symmetrix disk arrays.

Follow these steps:

1. Expand the CA SRM Object Tree, Open Systems, Services, Service Definitions, and then select Query.

   The Query table opens.

2. Select Configuration, and then New in the right pane.

   The Query Service Builder dialog opens.

3. Expand Network Storage, then Disk Arrays, and select Disk Arrays from the Template screen and click Next.
4. Select Disk Array Applications from the Selection Type drop-down list and select an application from the Select one or more disk array applications from the list and click Next.

   Note: If you defined classes that are based on disk arrays, the first choice in this dialog is Classes. You can use one of these classes in the query.

5. Select one of the following options for frequency execution and click Next.

   Immediately

   Defines the collection occurs immediately, but only once.

   Execute once

   Defines the collection occurs at a future date, but only once. Click the drop-down list to enter the date in the calendar.

   Execute periodically

   Defines the collection occurs at regular intervals. Designate the interval in the Every box. Type a number and select one of the frequency options:

   • Hours
   • Days
   • Weeks
   • Months
   • Business Days

   If you select Weeks, you can choose a specific day in the On box.

   Note: The On box is inactive for the other frequencies.

   The Retain Historical Data (Trending) option is only available when you enable periodic execution.

   Specific Time

   Defines the collection occurs at, or as soon as possible after, a specific time of day. If a server is down and CA SRM cannot collect at the specified time, it collects as soon as it can that day (before midnight).

   If you want to collect at a specific time, check this box. This only works with the Execute once and Execute periodically options. Use the spin box to designate the time of day you want the collection to occur.

   Hold

   Defines the service as available but the service does not run. The service remains on hold until you change the option to one of the frequencies listed. You can use the Hold option for situations where you want to kickoff this service from outside of CA SRM using the command-line option. The Hold option is not available for every service.

   The Summary dialog displays the parameters for the service that you have defined.

6. Select one of the following on the Summary dialog.
   • Click Save to save the service without executing it.

     CA SRM runs the service according to the configuration shown in this dialog.

     Note: If you change the Advanced dialog, you will have to use it for all of your future changes. After you use the Advanced dialog for a service, you can no longer edit the service in the Service Builder Wizard.

   • Click Launch to name the excute the service.
7. Type a name and description for the service in the dialog and click OK.

   The service executes or saves depending on what you selected in the previous dialog.

   You can use the CA SRM Activity Monitor to check the progress of any service that you create.

You can export the report from the Query Results under the Service Results in the Object Tree.