Mike Rockwell (Progress Software) asked a question.
Show devices with passive monitors assigned
- SELECT DISTINCT Device.nDeviceID
- FROM Device INNER JOIN
- PivotPassiveMonitorTypeToDevice ON Device.nDeviceID = PivotPassiveMonitorTypeToDevice.nDeviceID INNER JOIN
- PassiveMonitorType ON PivotPassiveMonitorTypeToDevice.nPassiveMonitorTypeID = PassiveMonitorType.nPassiveMonitorTypeID
This will show all devices which have passive monitors assigned