Explanation of Maintenance --> Purge Calls

[sergey]

This page allows to purge old calls data. Purge Calls page has several options allowing user to control the way data is removed from internal database.

These options are described below:

Date from
This parameter is used to specify low date bound for calls to be purged

Date to
This parameter is used to specify high date bound for calls to be purged. Please note that Date to bound is excluded from date
range, i.e. calls for the date specified in this field will not be purged. Thus, for example, to preserve calls only for current month
(e.g. Feb 2005) you should specify 1 Feb 2005 in Date to field and leave Date from field empty; in this case all calls having start time less
than 1 Feb 2005 00:00:00 will be removed.

Purge raw data
Mark this option to remove all raw SMDR data within date bounds. Please note that in this case you will not be able to restore calls information as the raw smdr would have been deleted.

Shrink database
Mark this option to reclaim free space used in internal database file back to operating system. When data is deleted  free space inside internal database file is marked for future use but is not returned to operating system. This is done for optimization purposes. This option allows to return free space from internal database file back to operating system.

To select calls to be purged section
This section contains 2 options allowing you to control which calls to be purged. Every call record has two dates associated with it: date reported by a PBX and computer date when the call was registered by a system. In some cases these dates may differ, for example, when
PBX reports invalid date or operating system has incorrect locale option specified. Date reported by a PBX is displayed in every view and  report except Raw Data views and reports. To view computer date associated with a call use Views/List/Raw Data page.

 
   Use only PBX date - 
   Mark this option to use dates reported by a PBX to select calls to be purged

   Use both PBX and computer date
   Mark this option to delete as much data as possible, it is recommended to use this option in case when PBX and computer dates match.

Finally, below is an example of purging all calls except current month (e.g. Feb 2005) reclaiming as much free space as possible:
- open Maintenance/Purge Calls page
- specify 1 Feb 2005 in Date to field
- mark Purge raw data option
- mark Shrink database option
- mark Use both PBX and computer date option in To select calls to be purged section
- press Ok button to start operation
- the operation may take up to several minutes depending on database size and computer speed