Share

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%'
Notes:
You can use this query to create Dynamic group and generate reports for these devices only.

 

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>

9 + 13 =

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
Please refer to our Error Message Reference.