Generate report using SQL Queries
search cancel

Generate report using SQL Queries

book

Article ID: 431668

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

A report containing a lot of fields are taking long time and a lot of memory to be generated.

Example :

Is it possible to generate the report above using SQL Queries ?

Environment

Client Automation - All Versions

Resolution

See attached the file report_query_example.sql which is an example of SQL Query to generate the report above.

Attachments

report_query_example.sql get_app
Powered by Wolken Software