BMC Smart Reporting: Webinar - Large Query Reports Best Practices

Please join Alan as he covers Large Query Report Best Practices in the August 11, 2021 Webinar.

In this session, he will review general report design, best practice basics for avoiding long running queries, as well as how to optimize report execution while improving performance. Including the following topics:
· System improvements to avoid performance issues
· Best practices when scheduling a broadcast
· How to enable secondary connection pool for background tasks
· Recommendations to export reports to excel

Alan Medina is a Staff Technical Support Analyst

Webinar Index
00:44 Agenda
01:17 Overview
01:56 Report Creation Considerations
03:14 Prereq to Run Large Query Reports
03:56 Prereq Demo
20:41 Broadcasts
26:12 Troubleshooting
27:49 References & Summary

References
Remedy Smart Reporting Troubleshooting Performance Issues
https://community.bmc.com/s/article/R...

Remedy Smart Reporting - How does the Max-Entries-Per-Query and 'rowLimit' setting work?
https://community.bmc.com/s/article/R...

Remedy Smart Reporting - Best practices when scheduling broadcasts INCLUDES VIDEO
https://community.bmc.com/s/article/R...

Remedy Smart Reporting - Recommendations to export reports to Excel INCLUDES VIDEO
https://community.bmc.com/s/article/R...