Read next article:

"Monitoring Internet Service using IP SLA"

Read previous article:

"Add MIB files to WUG"

Query devices with specific Active Monitor Type and Description

In Default | 0 comments

This query is used to select the devices based on a specific Active Monitor type and associated comment. For example, we are going to list all devices that have Interface Active Monitor and these monitors has comment contains Ethernet.

device with specific Active Monitor description


SELECT DISTINCT Device.nDeviceID, Device.sDisplayName FROM Device 
LEFT OUTER JOIN PivotActiveMonitorTypeToDevice ON PivotActiveMonitorTypeToDevice.nDeviceID = Device.nDeviceID 
LEFT OUTER JOIN ActiveMonitorType ON ActiveMonitorType.nActiveMonitorTypeID = PivotActiveMonitorTypeToDevice.nActiveMonitorTypeID     
WHERE Device.bRemoved = 0 AND 
ActiveMonitorType.sMonitorTypeName LIKE N'Interface' 
AND PivotActiveMonitorTypeToDevice.sComment LIKE '%Ethernet%'
You can use this query to create Dynamic group and generate reports for these devices only.


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>

five × two =


Unable to display Facebook posts.
Show error

Error: (#10) This endpoint requires the 'manage_pages' or 'pages_read_user_content' permission or the 'Page Public Content Access' feature. Refer to and for details.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.