NetOps Portal - Where are scheduled reports information stored

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

When scheduling a report in NetOps Portal, where is that schedule report and its details saved?

Environment

Any NetOps Portal release

Resolution

The schedule of the reports goes into the email_schedules table on NetOps Portal mysql database - netqosportal.

This includes the report's Subject and other information, but not the actual PDFs.

NetOps Portal directory /opt/CA/performanceCenter/DM/repository is where the scheduled Full PDF reports (saved with All Pages of multiple page views option under PDF Information Scope) are saved.

To see the report's Subject and other fields can run a query like the following on the NetOps Portal database:

mysqldump -p netqosportal email_schedules > /tmp/email_schedules.txt