View report SQL

book

Article ID: 194345

calendar_today

Updated On:

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: