"Monitoring Internet Service using IP SLA"
"Add MIB files to WUG"
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.
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.