<div dir="ltr">You can use acc module for #1 and 2 <div><a href="http://www.opensips.org/html/docs/modules/1.6.x/acc">http://www.opensips.org/html/docs/modules/1.6.x/acc</a></div><div>It does all type of call logs. you can find the details in the documentation.<br><div><br></div></div><div>Regarding #3, you can filter out different soft phone using predefined $ua (useragent field), but this UAC defined field can be manipulated by any intelligent subscriber. </div><div><br></div><div>Regarding #4, I think this is not possible using MI interface, you can write any external script to connect to db and use MI commands. </div><div><br></div><div><br></div><div>Regards,</div><div>Muhammad Faheem</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 14, 2015 at 11:03 PM, Rodrigo Pimenta Carvalho <span dir="ltr"><<a href="mailto:pimenta@inatel.br" target="_blank">pimenta@inatel.br</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div style="font-size:12pt;color:#000000;background-color:#ffffff;font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Dear OpenSIPS-Users,</p>
<p><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">I have some doubts about recording calls information on the OpenSIPs database:</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">1. Let´s suppose OpenSIPS is version 2.2 and it is using SQLite. After receiving a SIP INVITE, or SIP OK, or SIP CANCEL, etc, does OpenSIPS record information about the call? For example: who has
called, when the call was originated, who was called, missed calls, answered calls, dialed calls,  dialed numbers? The software we are  building must list the record of past calls. So the needing of keeping and retrieving such kind of information.</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">2 What are the tables in the OpenSIPS SQLite DB that keep such information? I have analyzed some tables in my OpenSIPS and I have noticed that some of it still remain empty even after some calls. </p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">3. In my project there are 3 kinds of SIP clients (softphones for  door bells, for ordinary users, for special users). Only calls originated from a specific set of softphones must have information
recorded in the database. How to configure OpenSIPS to record only calls from such softphoes?</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">I will start today studying about MI interface.</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">4. Does such interface provide some way to read data from the OpenSIPS SQLite Database, so that I can use it in a external script? </p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">Any hint will be very helpful!</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif">Best regards.</p><span class="HOEnZb"><font color="#888888">
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<p style="font-family:Calibri,Arial,Helvetica,sans-serif"><br>
</p>
<div>
<div name="divtagdefaultwrapper">
<div><font size="2">
<div>RODRIGO PIMENTA CARVALHO<br>
Inatel Competence Center<br>
Software<br>
Ph: <a href="tel:%2B55%2035%203471%209200" value="+553534719200" target="_blank">+55 35 3471 9200</a> RAMAL 979<br>
</div>
</font></div>
</div>
</div>
</font></span></div>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>