Host Summary Volume Columns Inaccurate

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

If you include a Host Summary Chart (Volume) in Custom Report in NFA you may notice that the current column names do not match the data accurately.

<Please see attached file for image>

The “Average To” and “Average From” columns are showing higher volume values than the “Maximum To” and “Maximum From” which clearly does not make any logical sense.

 

This is simply due to incorrect column names. These are the correct column names:

<Please see attached file for image>

 

 

Environment

Windows Server 2003/2008/2012
NFA 9.1+
 

Resolution

To resolve this, we have some SQL commands to adjust the column names for saved reports and future reports.


1.   Open a CMD Prompt on the Console Server.

2.   Type “mysql reporter”

3.   Paste these commands into the CMD prompt;

update control_properties set PropertyValue = 'Max To Data Point ' where ControlID = 40055 and PropertyName = 'Column1_HeaderFormat';
update control_properties set PropertyValue = 'Max From Data Point' where ControlID = 40055 and PropertyName = 'Column2_HeaderFormat';
update control_properties set PropertyValue = 'Total To' where ControlID = 40055 and PropertyName = 'Column3_HeaderFormat';
update control_properties set PropertyValue = 'Total From' where ControlID = 40055 and PropertyName = 'Column4_HeaderFormat';
update control_properties set PropertyValue = 'Total Bidirectional' where ControlID = 40055 and PropertyName = 'Column5_HeaderFormat';
 

4.   The column names should be fixed.

 

Additional Information

This is resolved in NFA 10.0