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>

17 + 16 =

Facebook

Unable to display Facebook posts.
Show error

Error: Unsupported get request. Object with ID 'orchtechsoftwarehouse' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api
Type: GraphMethodException
Code: 100
Subcode: 33
Please refer to our Error Message Reference.