View report SQL

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When creating a report you may want to see exactly what SQL statement is being used to run the report you created, this way you can verify the information being shown is correct. Here's how to view the SQL.

 

Environment

Applications Manager

Resolution

From the UI navigate to Object Admin> Development> Reports> Highlight a report, select Eedit> Select SQL: