>Michael Whisenant wrote:
>> I understand that RadiusNT can track the users DNIS information as well
>> Emerald(SQL) can store that information into the database. Here is what
>> want to do and I know someone has or can tell me how to perform this
>> 1. A user calls a specific number (DNIS) and I bill him per minute
>> access for that call. This could be done outside of Emerald if
>I've been looking into DNIS billing but haven't completed support
>for it yet.
>> 2. I would like a script that queries the database that will print
>> following based on a match of the DNIS information.
>> NAS called, login in name, Real name, ANI (originating number),
>> time, stop time, time online.
>Select NASIdentifier, UserName, sa.FirstName, sa.LastName, NASPortDNIS,
> Start=DateAdd(Second, (0-AcctSessionTime-AcctDelayTime), CallDate),
> Stop=DateAdd(Second, (0-AcctDelayTime), CallDate)
>From calls, subaccounts
>Where DateDiff(Day, GetDate, Calldate > 0)
> and NASPortDNIS = '5551212'
> and (sa.login = username or sa.shell = username or sa.email = username)
>Order By UserName, Start
>> 3. The ability to have this script run nightly as a maintainence
>> and print the results to either a file or to the printer.
>What I would to is just use the script to add charges to the customer's
>accounts. This could be a two-step process. Turn the above into a stored
>procedure called NewTollCalls and then use a statement like:
>Insert Into TollCalls
> Exec NewTollCalls
>which will put the daily stats into the NewTollChargs table (which you
>would have to create). At that point, you could then roll up the usage
>into a single Charges table entry for the customer before billing is