callaccounting.ws forum
Welcome,
Guest
. Please
login
or
register
.
July 31, 2010, 10:41:18 AM
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Search:
Advanced search
Did you know Call Accounting Mate was downloaded in all 5 continents within 24 hours of being released.
432
Posts in
223
Topics by
1020
Members
Latest Member:
coolcars99
callaccounting.ws forum
General Category
Call Accounting Mate FAQ
(Moderator:
sergey
)
Explanation of Maintenance --> Purge Calls
« previous
next »
Pages:
[
1
]
Author
Topic: Explanation of Maintenance --> Purge Calls (Read 4003 times)
sergey
Moderator
Sr. Member
Offline
Posts: 48
Explanation of Maintenance --> Purge Calls
«
on:
February 27, 2005, 01:09:08 PM »
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
«
Last Edit: February 28, 2005, 09:53:29 AM by Administrator
»
Logged
Pages:
[
1
]
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Call Accounting Mate FAQ
=> News from CallAccounting.ws
=> Asterisk Integration
=> Exporting Records to Other Applications and Posting to PMS Systems
=> Endorsements
=> Enhancement Suggestions for Call Accounting Mate
Loading...