Share

Read next article:

"SNMP and Security"

Read previous article:

"Devices with Memory Utilization Exceeds 85%"

Devices with Specific Performance Monitor

In Default | 0 comments

This query used to detect the devices that has a specific Performance monitor.

SELECT DISTINCT Device.nDeviceID FROM Device
LEFT OUTER JOIN PivotStatisticalMonitorTypeToDevice ON PivotStatisticalMonitorTypeToDevice.nDeviceID = Device.nDeviceID
LEFT OUTER JOIN StatisticalMonitorType ON StatisticalMonitorType.nStatisticalMonitorTypeID = PivotStatisticalMonitorTypeToDevice.nStatisticalMonitorTypeID
WHERE Device.bRemoved = 0 AND StatisticalMonitorType.sStatisticalMonitorTypeName LIKE N'%cpu%'
Note:
You should replace cpu in LIKE N'%cpu%'with the required Performance monitor name. 
Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

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>

four × one =

Facebook

Unable to display Facebook posts.
Show error

Error: Error validating application. Application has been deleted.
Type: OAuthException
Code: 190
Please refer to our Error Message Reference.