05-27-2013 01:25 AM - edited 03-18-2019 01:11 AM
Hi all,
Does anybody know how many calllogs a C20 can keep?
I mean, how many calllogs can I get at most by using xHistroy?
Best Regards,
Kotaro Hashimoto
Solved! Go to Solution.
05-29-2013 01:42 PM
In TC6 releases I see we use an sql database which can have at most 100 entries. If we exceed 100 entries the database gets trimmed. I would assume less recent entries get deleted then?
[dderidde-sx20:/config] $ ls -lrt call_history_module_sqlite3.db
-rw-r--r-- 1 root root 5120 May 28 14:53 call_history_module_sqlite3.db
[dderidde-sx20:/config] $
sqlite> .tables
CallHistory
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE CallHistory (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
CallId INTEGER,
RemoteNumber TEXT,
CallbackNumber TEXT,
DisplayName TEXT,
Direction INTEGER,
Protocol INTEGER,
CallRate INTEGER,
CallType INTEGER,
EncryptionType TEXT,
CallPriority INTEGER,
BookingId TEXT,
StartTime INTEGER,
EndTime INTEGER,
DisconnectCause TEXT,
DisconnectCauseCode INTEGER,
DisconnectCauseOrigin TEXT,
DisconnectCauseType TEXT,
OccurrenceType INTEGER,
HistoryEntryStatus INTEGER);
INSERT INTO "CallHistory" VALUES(1,2,'sip:dderidde.ex90.home@cisco.com','sip:dderidde.ex90.home@cisco.com','dderidde.ex90.home',0,1,
1400000,1,'Aes-128',0,'',1368786543,1368787216,'Normal',0,'SIP','RemoteDisconnect',2,0);
INSERT INTO "CallHistory" VALUES(2,3,'sip:dderidde.ex90.home@cisco.com','sip:dderidde.ex90.home@cisco.com','dderidde.ex90.home',1,1,
1400000,1,'Aes-128',0,'',1368790080,1368790122,'Normal',0,'SIP','RemoteDisconnect',1,0);
INSERT INTO "CallHistory"
05-27-2013 08:22 AM
Hi Kotaro hashimoto-san,
I have seen 2xx calls is x history in my codec , As per following commnad value is quite high .
xCommand CallLog Clear
Clear call logs stored in the system. If a logtag is given as argument, that specific call is deleted from the
logs. If not logtag is give, all call logs will be deleted.
Parameters:
LogTag: <0..2147483647> ###### call numbers :-).
Example:
xCommand CallLog Clear
*r ClearResult (status=OK):
** end
hth
Kind regards,
Dharmmesh
05-27-2013 09:40 PM
Thank you Dharmesh,
So, an endpoint can store 2147483647 calllogs at most?
Best Regards,
Kotaro Hashimoto
05-29-2013 12:52 PM
2,147,483,647 is the maximum value for a 32-bit signed integer, integer being the data type of the input parameter for that command. It only means paramater must be an integer value but I doubt the endpoint can actually store such a large number of call logs.
Only a developer could answer your question I'm afraid.
05-29-2013 01:42 PM
In TC6 releases I see we use an sql database which can have at most 100 entries. If we exceed 100 entries the database gets trimmed. I would assume less recent entries get deleted then?
[dderidde-sx20:/config] $ ls -lrt call_history_module_sqlite3.db
-rw-r--r-- 1 root root 5120 May 28 14:53 call_history_module_sqlite3.db
[dderidde-sx20:/config] $
sqlite> .tables
CallHistory
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE CallHistory (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
CallId INTEGER,
RemoteNumber TEXT,
CallbackNumber TEXT,
DisplayName TEXT,
Direction INTEGER,
Protocol INTEGER,
CallRate INTEGER,
CallType INTEGER,
EncryptionType TEXT,
CallPriority INTEGER,
BookingId TEXT,
StartTime INTEGER,
EndTime INTEGER,
DisconnectCause TEXT,
DisconnectCauseCode INTEGER,
DisconnectCauseOrigin TEXT,
DisconnectCauseType TEXT,
OccurrenceType INTEGER,
HistoryEntryStatus INTEGER);
INSERT INTO "CallHistory" VALUES(1,2,'sip:dderidde.ex90.home@cisco.com','sip:dderidde.ex90.home@cisco.com','dderidde.ex90.home',0,1,
1400000,1,'Aes-128',0,'',1368786543,1368787216,'Normal',0,'SIP','RemoteDisconnect',2,0);
INSERT INTO "CallHistory" VALUES(2,3,'sip:dderidde.ex90.home@cisco.com','sip:dderidde.ex90.home@cisco.com','dderidde.ex90.home',1,1,
1400000,1,'Aes-128',0,'',1368790080,1368790122,'Normal',0,'SIP','RemoteDisconnect',1,0);
INSERT INTO "CallHistory"
05-31-2013 01:19 AM
Thank you Danny,
I wrote a Tera Term macro which repeats making a call and disconnect it 100 times, and confirmed a log.
As you mentioned, the maximum number of calllog was 100.
And If I make call more than 100 times, I see the oldest entry is deleted.
FYI:
On EX60(TC6.1.1), the maximum number of calllog is 100, but E20(TE4.1.1) could store more than 100 calllogs.
Best Regards,
Kotaro Hashimoto
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide