I tought that SP1 would have something to clean up the logs...no  such luck.

IPSWITCH

please-please-please, we need a database script to clean those logs...I would take a script that delete and recreate that table...Mine is now approximate 3 millions rows now.

ogos,

Please read the "Cleaning database" thread, in which you will find instructions on how to clear out both the Active and Passive Monitor Log tables:

http://www.ipswitch.com/forums/shwmessage.aspx?ForumID=14&MessageID=5206

-- Nathan

Thanks to NathanA post...

I was able to change his SQL script from "Active" to "Passive" and  I was able to clean the Syslogs and SNMP traps etc.

I still do not like to do this manually...but is better than not able to acess them at all..

I am going to monitor these tables and see how long it takes (records in the table) before WUP chokes up with the SQL timeouts errors.

Thanks NAthanA

Just in case anyone else need to clear the Passive logs.....

just Replace in  NathanA script the word from "Active" to "Passive" and it will works great.

"

1. Stop the Ipswitch WhatsUp Engine, just to be on the safe side.

2. Run the OSQL command-line Transact-SQL interface:

osql -S (local)\whatsup -E

- OR -

osql -S (local)\whatsup -U sa -P <password>

(depending on whether you are authenticating to the database by DB user/pass or by NT credentials)

3. Run the following Transact-SQL statements (but supply a 'go' after every one just to make sure that you typed it in right and that it worked):

USE WhatsUp
ALTER TABLE ActiveMonitorActivityLog DROP CONSTRAINT FK_ActiveMonitorActivityLog_PivotActiveMonitorToDevice
ALTER TABLE ActiveMonitorSampleData DROP CONSTRAINT FK_ActiveMonitorSampleData_ActiveMonitorActivityLog
TRUNCATE TABLE ActiveMonitorActivityLog
TRUNCATE TABLE ActiveMonitorSampleData
ALTER TABLE ActiveMonitorSampleData ADD CONSTRAINT FK_ActiveMonitorSampleData_ActiveMonitorActivityLog FOREIGN KEY (nActiveMonitorActivityLogID) REFERENCES ActiveMonitorActivityLog (nActiveMonitorActivityLogID)
ALTER TABLE ActiveMonitorActivityLog ADD CONSTRAINT FK_ActiveMonitorActivityLog_PivotActiveMonitorToDevice FOREIGN KEY (nPivotActiveMonitorTypeToDeviceID) REFERENCES PivotActiveMonitorTypeToDevice (nPivotActiveMonitorTypeToDeviceID)
DBCC SHRINKDATABASE (WhatsUp)

4. Restart the Ipswitch WhatsUp Engine.

5. Set your Raw Data retention to 2 hours and cross your fingers.

Good luck,

-- Nathan

"