Cleanup Help Desk Database

Follow the steps given below to cleanup the help desk database:

1. Open a command window on the central server and navigate to the below path
   
   /program files/adventnet/me/central/mysql/bin
2. Execute the command mysql.exe -u root -P 23306 supportcenter
3. Execute the below queries one by one
   
   Mysql> delete from aaaaccsession;
   Mysql> delete from auditrecord;
   Mysql> delete from recentitems;
   Mysql> delete from errorlog;
4. Restart the central service once
5. If you want to delete the request history related info, execute the following on each of your probes:
   
   1. Connect to the probe database by following the procedures in the link below
      
      http://help.mspcenterplus.com/Connecting-to-MySQL-DB.html
   2. Execute the below query
      
      delete from availabilityelementid where elementid not in (select moid from managedobject);
   3. Restart the probe service once

Help desk database has been successfully cleaned.