<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Michael,<br>
What you're trying to do is just honestly not going to get much
support from the user lists, mainly because interacting directly
with the SQL database is not recommended, and is suggested that
networking is disabled on the SQL to increase the performance of
other applications.<br>
<br>
All of the information is surely there though, but like I said
you're sort of on your own there. If you'd like to try and create a
PHP frontend to another database that you populate with information
provided from the Provisioning server and the CDR Export methods,
this is highly suggested and more efficient. Infact, it makes more
sense to start off this way and populate your Provisioning server
with information from your customer database. :)<br>
<br>
This is how it's done here at XATel, if you need more information on
this perhaps we can talk off list because it's not directly related
to anything that will help anyone else out here.<br>
<br>
<pre class="moz-signature" cols="72">--
Jonathan Scott Knox
Systems Administrator
XATel Communication
7 Green Street, Biddeford ME. 04005
(207)391.1000 (Mon - Thur, 9AM - 6PM. Friday - 9AM - 5PM.)</pre>
<br>
<br>
On 10/17/2011 4:50 AM, Michael Molina wrote:
<blockquote cite="mid:BAY166-W60604188F8DECB14DF583BD6E40@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<div dir="ltr">
Trying to create a query that will show the shopuser (as account
number), customer name, customer last name, customer street
address, city and zip code. It is important to fetch also the
values for the phone numbers associated with this account as
customers can have several phone numbers (subscribers) linked to
them. I am using the program Navicat Premium to connect to the
mySQL server and hence being able to create the query and from
the query create the report. I have made a query by using the
tables "customers" field "contact_id" and "contracts" field "id"
from the database "billing", if you join them and run the query
you get the information required but I can not find a way to
fetch the DIDs associated with each account. I looked
everywhere, "provisioning", "kamailio" even accounting but that
one only shows the cdrs. I believed I could have gotten what we
need in the "billing" database table "voip_numbers" but to no
avail. The idea is perhaps to select for instance, a "shopuser"
and get the CDRs for that customer, weather he has one or ten
phone numbers. Maybe for billing purposes or traffic
control even load control. It does not matter, the point is
being able to create a report that can be printed and possibly
select inbound and outbound traffic for a specific customer. I
would really love and appreciate some help in the matter. Thank
you all.<br>
<br>
Michael Molina<br>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="http://lists.sipwise.com/listinfo/spce-user">http://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>