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

book

Article ID: 40106

calendar_today

Updated On:

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>

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;

 

<Please see attached file for image>

2-10.png

 

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

 

<Please see attached file for image>

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. 



Environment

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

Resolution

Please Update This Required Field

Attachments

1558723664098000040106_sktwi1f5rjvs16wxz.png get_app
1558723661358000040106_sktwi1f5rjvs16wxy.png get_app
1558723659423000040106_sktwi1f5rjvs16wxx.png get_app
1558723657247000040106_sktwi1f5rjvs16wxw.png get_app
1558723655326000040106_sktwi1f5rjvs16wxv.png get_app
1558723653265000040106_sktwi1f5rjvs16wxu.png get_app