Table heading in custom report do not match csv export

Document ID : KB000097164
Last Modified Date : 07/08/2018
Show Technical Document Details
Issue:
When exporting a Host Summary Table to a .csv file from a NFA Custom Report, the table headings may not match the column header names names in the csv file.



 
Cause:
Column names were updated to better represent each column after 9.3.3, however the csv files still use 
Resolution:
1. RDP to the NFA Console server.

2. Open and command prompt and login to mysql with:
mysql reporter

3. Run the following INSERT statement:
INSERT INTO control_properties (ControlID,PropertyName,PropertyValue) VALUES (40057, 'ExportHeaders', 'Host|Max To for Resolution|Max From for Resolution|Total To|Total From|Bidirectional Total||Name|RecordCount');

4. Run the custom report again, and when it completes, export the Host Volume Table to csv and observe that the names should now match the GUI.