Here
is a SQL statement that will do that:
SELECT Device.sDisplayName,
PassiveMonitorType.sMonitorTypeName
FROM Device
JOIN PivotPassiveMonitorTypeToDevice
ON Device.nDeviceID = PivotPassiveMonitorTypeToDevice.nDeviceID
JOIN PassiveMonitorType
ON PivotPassiveMonitorTypeToDevice.nPassiveMonitorTypeID = PassiveMonitorType.nPassiveMonitorTypeID
WHERE ISNULL(Device.bRemoved, 0) = 0
AND ISNULL(PivotPassiveMonitorTypeToDevice.bRemoved, 0) = 0
AND ISNULL(PassiveMonitorType.bRemoved, 0) = 0
ORDER BY Device.nDeviceID
PassiveMonitorType.sMonitorTypeName
FROM Device
JOIN PivotPassiveMonitorTypeToDevice
ON Device.nDeviceID = PivotPassiveMonitorTypeToDevice.nDeviceID
JOIN PassiveMonitorType
ON PivotPassiveMonitorTypeToDevice.nPassiveMonitorTypeID = PassiveMonitorType.nPassiveMonitorTypeID
WHERE ISNULL(Device.bRemoved, 0) = 0
AND ISNULL(PivotPassiveMonitorTypeToDevice.bRemoved, 0) = 0
AND ISNULL(PassiveMonitorType.bRemoved, 0) = 0
ORDER BY Device.nDeviceID
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sotherland Scott Contractor 16CS/SCBB
Sent: Tuesday, September 27, 2005 12:00 PM
To: [email protected]
Subject: [WhatsUp Forum] List of events associated with devicesIs there a asp script that can list all devices and the events they have associated to them? I need to list all monitored events by device.
"The information provided is only as good as the information provided"
Scott J. Sotherland
Team EITC / Hurlburt Field, FL
Configuration Management
850.884.6775 / DSN 579-6775
