Expiring Messages

If you want manually expire old event messages from the database for a device, perform the following steps:

Warning: Use extreme caution when issuing SQL delete statements. Kaseya recommends that you have a current backup of the database and that you verify each command before execution. Failure to take proper precautions can result in corruption or lost data.

Expiring Messages on Windows

1. Open the message windows and record the Device Address for the device.
2. Log in to each Traverse DGE and execute the following commands:

C:

cd <TRAVERSE_HOME>

apps\mysql\bin\mysql -u root --password= aggregateddatadb

(then, at the mysql> prompt)

UPDATE ALARMS set expireTime=1081262436203 WHERE deviceAddress='n.n.n.n' and expireTime=-1;'

quit;

where n.n.n.n is the IP address. When the database table updates, the messages no longer display in the message window.

Expiring Messages on UNIX

1. Open the message windows and record the Device Address for the device.
2. Then log in to each Traverse host and execute the following commands:

cd <TRAVERSE_HOME>

etc/dgedb.init admin dge

1. Then, at mysql> prompt enter

UPDATE ALARMS set expireTime=1081262436203 WHERE deviceAddress='n.n.n.n' and expireTime=-1;'

quit;

where n.n.n.n is the IP address. When the database table updates, the messages no longer display in the message window.