Generate an SRM Report with an Ad Hoc Query

Required Capability: Capabilities and Permitted Actions

To generate an SRM report with an ad hoc SQL query:

1. From the CommCell Browser, expand Reports and SRM Report Manager.
2. Click a report category. The specified category Report Window will appear.
3. Select the client(s) and client computer group(s) to be included in the report from the Client Selection filter.
4. Select the category/columns of data to be reported in the Column Selection filter, and click Add. The column represents the type of data to be garnered from the database for the selected client(s) and client computer group(s).
5. Change the Display Units and modify the Chart Options if desired. Note the display units is intended for the chart display only. When entering numerical values in ad hoc queries, they must be entered in bytes. 
6. From the Adhoc Query filter, construct the SQL query as follows:
   1. Select a column in which you want to specify a condition (e.g., Windows Entities - Computer). The columns that were selected in Step 3. are displayed.
   2. Specify the Condition for the column selected in the previous step. Either type the condition in directly or click ... to display the Select Filter Condition dialog box.
   3. If ... was selected in the previous step, in the Select Filter Condition dialog box, double-click the operator and in the Condition field, enter the values of the condition, such as the following examples illustrate:
       

      Column	Condition
      Windows Entities- Computer	='client1'
      Windows Entities- Client Computer Group	like '%trenton%'
      Windows Entities - Disk	<>'c:\'
      Windows Entities - Disk	='c:\' OR 'd:\'
      Windows Entities - Disk	NOT'c:\'
      File Level Analytic Details - Type	=1

   4. After specifying the condition, click Add.
   5. Optionally, click Get Query. The query that is displayed is Read-only and can be copied and pasted and used in SQL Server Management Studio.
7. Optionally, click Schedule in the Schedule Details dialog box, select a Report Name and Schedule and Start Time for the report.

   Only if you select the One Time Schedule Policy do you need to specify a Date and Time. To run it immediately, accept the default start time.

   • To create a custom schedule for this report, click Edit, and enter the appropriate parameters in the Schedule Details dialog box.
   • Click on Options and select a time zone from the Advanced Schedule Options dialog box.
   • If Predictive Trending is available for the report, you can optionally select Trending.
8. Click Generate.