Configure Trend View CSV Export table output in Performance Management

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Is it possible to create report that will present the data in multiple columns tablular format?

Performance Management Trend reports with multiple metrics exported to CSV formats create a single table for each metric in the export. This is the default behavior.

The behavior can be modified to provide a single table with each metric included, side by side.

Environment

All supported Performance Management releases

Cause

Default behavior doesn't provide the report format end users prefer.

Resolution

The change involved requires connection to the PC MySql netqosportal database. We will enter the database via MySql prompt and run a command to change the value for an attribute in the general table.

To make this change complete the following steps:

1. As the root user or install owner go to the (default path) /opt/CA/MySql/bin directory. Run the command:
   • ./mysql -uroot -p netqosportal
   • When prompted enter the secure MySql password created during installation
2. This query can be run to check the current value set:
   • select * from general where attribute like 'CSV%';
3. This command is run to change the value from default false to true:
   • update general set value='true' where attribute='CSV.Multiple.Trend.Output';
4. Reuse the command from step 2 to verify change is set properly.

Allow a few minutes for the change to propagate in the system. Launch a fresh UI browser tab for PM and test a CSV export to confirm the change provides what is sought. If it doesn't simple reset the value back to false.

Additional Information

NOTE: This applies to Trend Views only. No other View will be affected by this change.