"Export all Passive Monitor"
"Devices added on certain period of time"
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