Description

This article explains why the port utilization report is showing empty even for more than 1 % utilization.

Symptoms

When generating the "port utilization" for greater than 1%, it will run the below query on the MySQL database:

 

mysql -ujboss -p$(grep mysql.jboss /etc/sysconfig/JunosSpace/pwd | awk -F= '{print $2}') build_db -e 'SELECT p.logicalSystemId,p.physicalDeviceSerialNumber,SUBSTR(p.path, p.portNamePathOffset + 1, LENGTH(p.path)), p.latestUtilizationPercent, p.latestIfInOutOctetsRate FROM PortTrafficDataEntity p WHERE p.portNamePathOffset IS NOT NULL AND p.latestUtilizationPercent > 1 ORDER BY p.latestUtilizationPercent DESC ;'

 

If it is showing empty, the report will not show any data.

 

The report will show data only if there is high port utilization at the time of generation. It will not show the historical Port utilization.

 

Solution

This is according to design. Port utilization report will only show the realtime data at the time of generation

Modification History

2025-03-12 : Article Created