Share

Read next article:

"Export all Passive Monitor"

Read previous article:

"Devices added on certain period of time"

All assigned Active Monitors

In Default | 0 comments

This query displays all assigned Active Monitors for all Devices

SELECT Device.nDeviceID,
       Device.sDisplayName,
       sMonitorTypeName,
       sMonitorTypeDescription

FROM Device
LEFT OUTER JOIN DeviceType ON
Device.nDeviceTypeID = DeviceType.nDeviceTypeID
LEFT OUTER JOIN PivotActiveMonitorTypeToDevice ON
Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID
LEFT OUTER JOIN ActiveMonitorType ON
PivotActiveMonitorTypeToDevice.nActiveMonitorTypeID = ActiveMonitorType.nActiveMonitorTypeID

ORDER BY nDeviceID
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>

5 × four =

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.