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 Facebook9Tweet 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>

four × 1 =

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.