Share

Read next article:

"CPU Performance using SQL Query"

Read previous article:

"Memory Performance using SQL Query"

Interface Performance using SQL Query

In Default | 0 comments

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

 

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

2 + 15 =

Facebook

Unable to display Facebook posts.
Show error

Error: (#10) This endpoint requires the 'manage_pages' permission or the 'Page Public Content Access' feature. Refer to https://developers.facebook.com/docs/apps/review/login-permissions#manage-pages and https://developers.facebook.com/docs/apps/review/feature#reference-PAGES_ACCESS for details.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.