How can I view the query that the Reporter execute into my database from DSM Reporter?

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

Question:

How can I view the query that the Reporter execute into my database from DSM Reporter?

 

Environment:                                          

CA Client Automation - All Versions

 

Answer:

Follow these steps below:

 

1-  1.  Open the DSM Reporter;

2-     2.  Select the desired report;

 

<Please see attached file for image>

<Please see attached file for image>

 

3-     3.  Click with the right mouse button to open the object menu to select the option that lets you export the query to a file;

 

<Please see attached file for image>

 

4-     4.  Chose the local path to save the file;

 

<Please see attached file for image>

  

5-     5.  Edit this file through a text editor, like NOTEPAD to check the query.

 

Additional Information:

 This procedure works only for All the default DSM reports.   This option is Not Applicable for custom report. 

Environment

Release: UASIT.99000-12.9-Asset Intelligence
Component:

Resolution

Please Update This Required Field