
Interface Performance using SQL Query
Sometimes you need to use the SQL queries to get the performance data instead of using WUG Reports. You can use the following queries to get the required data for Interface utilization.
SELECT Device.nDeviceID, Device.sDisplayName, sIfDisplayName, sIfDescr, sIfPhysAddress, dPollTime, nIfSpeedIn, nIfInOctets_Avg, nIfInOctets_Min, nIfInOctets_Max, nIfOutOctets_Avg, nIfOutOctets_Min, nIfOutOctets_Max
FROM dbo.StatisticalInterface
LEFT OUTER JOIN dbo.StatisticalInterfaceIdentification ON
StatisticalInterfaceIdentification.nStatisticalInterfaceIdentificationID = StatisticalInterface.nStatisticalInterfaceIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalInterfaceIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC
Interface Cache data, the latest Interface utilization data (i.e. exactly one record per monitored Interface)
SELECT Device.nDeviceID, Device.sDisplayName, sIfDisplayName, sIfDescr, sIfPhysAddress, dPollTime, nIfSpeedIn, nIfInOctets_Avg, nIfInOctets_Min, nIfInOctets_Max, nIfOutOctets_Avg, nIfOutOctets_Min, nIfOutOctets_Max
FROM dbo.StatisticalInterfaceCache
LEFT OUTER JOIN dbo.StatisticalInterfaceIdentification ON
StatisticalInterfaceIdentification.nStatisticalInterfaceIdentificationID = StatisticalInterfaceCache.nStatisticalInterfaceIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice ON
PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID = StatisticalInterfaceIdentification.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON
Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID
ORDER BY dPollTime DESC