Maximum calllogs of xHistory

[hashimoto.kotaro]

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

[Dharmesh Nandoria]

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

[hashimoto.kotaro]

Thank you Dharmesh,

So, an endpoint can store 2147483647 calllogs at most?

Best Regards,

Kotaro Hashimoto

[thobonho]

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.

[Danny De Ridder · Accepted solution]

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"

[hashimoto.kotaro]

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