How to get the SQL query running in CA Clarity PPM Solution Pack (CSP) /Crystal reports

book

Article ID: 48903

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM On Premise

Issue/Introduction

How can I get the SQL query running in CA Clarity PPM Solution Pack (CSP)/Crystal reports? Is there a way to get SQL Trace Statements outside of Crystal Reports?


Note: Crystal Reports allow the user to gather and present data in different ways. Reports from CA Clarity PPM Solution Pack (CSP) don't use universes.

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus

Resolution

  1. Go to Crystal Reports 2008 and open a CA Clarity PPM Solution Pack (CSP) report, ie: 
    "Missing Time".



  2. Right click on "command":



  3. Click on "Set Datasource Location..."


  4. Click on "View command":


  5. Enter DB login and the SQL query used will be shown:
Alternatively, an action trace could be used to get the query used via Clarity. Here are the steps to enable an action trace: Article ID: 9353

Attachments

1558721575223000048903_sktwi1f5rjvs16w3w.gif get_app