Unfortunately, I personally can't, but someone else here might be able
to; or you might get some help on the Forum ( http://www.ipswitch.com/forums/messages.aspx?ForumID=14 )
...
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hart, Donald (Corporate, Consultant)
Sent: Tuesday, September 27, 2005 3:24 PM
To: [email protected]
Subject: RE: [WhatsUp Forum] List of events associated with devicesDo you have some time that if I asked for help you would be able to.I have been looking for a way to get the same look as the old whatsup Pro and need some help./
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Leonard
Sent: Tuesday, September 27, 2005 12:51 PM
To: [email protected]
Subject: RE: [WhatsUp Forum] List of events associated with devicesHere 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-----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
