NFA Custom Report using the 'Aggregate Results by Subnet' option is not showing all data and subnets

Document ID : KB000095453
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
When running a Custom Report on 4 or more Host Subnet filters and checking the 'Aggregate Results by Subnet' check box, not all of the subnets may be seen, and there may be gaps in the data.

This is especially seen when running a month or longer report at 15 minute resolution.

 
Resolution:
1. On the Console server open a command prompt and run:
mysql reporter

2. Then run the following update command to change the defaultValue from 100 to 12000:
update parameter_descriptions set DefaultValue = '12000' where Parameter = 'maxRecordsPerInterface';
 
3. Then try running the report again and see if you get the expected results.