All assigned Active Monitors

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