How do I View and Modify a SQL statement associated with a Query?

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

I would like to modify the SQL statement of a query to create custom reports. How do I modify the SQL statement associated with the query?

Environment

Client Automation - All version

Resolution

1. Right-click Queries in the DSM Explorer and select New from the context menu.
   
   

   

2. In the 'Select Target' window select the object on which you want to create a query and click OK. Ex: Computers.
   
   

   

3. In the 'Query Designer' window insert the arguments required to create the new query and click OK.
   
   

   

   
   

   

4. The Save Query dialog box will displayed. Enter the unique name for the query.
   
   

   

5. The query is created with the given name and displayed under the Queries folder in DSM Explorer. Right-click the query and select Properties.
   
   In the 'Query Designer' window right-click the argument and select Edit SQL.
   
   

   

6. Edit the SQL statement as desired and click OK.