search cancel

Cannot send scheduled reports in CSV format as a link in the email instead as of an attachment

book

Article ID: 240711

calendar_today

Updated On:

Products

DX NetOps CA Performance Management - Usage and Administration

Issue/Introduction

Generating some big scheduled reports in CSV format and trying to send them out via email. 
Instead of sending the full CSV report as an attachment in the email message, would like to send it as a time-sensitive link to the report.
But looks like this only works for PDF reports and not CSV reports.

Cause

This is a current limitation in Performance Management.

For CSV and single-paged PDF, the report is attached and sent in an email message. For full-paged PDF, an email message is sent with a time-sensitive link to the report. 

Environment

Release : 21.2.9

Component : Performance Management Dashboards/Reports

Resolution

Currently can only send reports in CSV format as attachments. This was done because the PDF report can be quite large in number of bits and often the mail servers have a limitation as to attachment size. While normally a CSV report is not so large that mail server can block it.

So having CSV reports to be an hyperlink in the email is currently not supported.

If using Performance Management 21.2.9 and higher there is a potential workaround, but this is a manual process.

For this need to have the 'Send Reports to Archive' role right and archive reports enabled, so that Portal saves dashboard data as scheduled reports.
Go to the Managed Scheduled Reports and use the hyperlink under the 'Report Name' column to be used in an email.

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=+n9cjFkzHWml4R28X/TkFw==

 

Additional Information

For more details on setting up the suggested workaround refer to

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/21-2/administrating/performance-center-administration/set-the-email-server.html

and

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/21-2/using/share-data-with-other-users/archive-scheduled-reports.html#concept.dita_cdec81e5-79aa-443b-a07b-cd15be7ba656_ViewArchivedReports