ThinWorld Citrix Knowledgebase

Tuesday, 4 August 2009

Delete AppSense Events from SQL Database

Appsense has no automated method of cleaning up all the events it records.
This can mean the SQL database can grow very large. My current database is around
4GB.

To clean up the database I perform the following actions within the appsense management console to delete older events that i no longer need.

Open Appsense Management Console
Click Alerts Tab
Click Delete Event
Choose time range of the data to be deleted (I typically delete anything older than 1 month)
It may take some time to delete but you should get an completed message along with a count of how many events were deleted.

It would be a nice feature if the appsense console automated this housekeeping but for the moment this manual process is required.

Labels:

0 Comments:

Post a Comment



<< Home