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

Document ID : KB000040106
Last Modified Date : 14/02/2018
Show Technical Document Details
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;

 

1-10.png

 

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;

 

2-10.png

 

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

 

3-10.png

  

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. 

Instructions:
Please Update This Required Field