Re: Need Quick script for deleting calls records!

iml@interconnect.net
Sat, 07 Mar 1998 19:03:59 -0600

Is it safe to delete the those records without effecting any history
for billing and accounting purposes?

On Sun, 8 Mar 1998 10:46:06 +1000, you wrote:

>delete from Calls where AcctStatusType =3D 1
>
>Sly
>
>
>-----Original Message-----
>From: Barry Kiesz <barry@hdc.net>
>To: Emerald@iea-software.com <Emerald@iea-software.com>
>Date: Sunday, 8 March 1998 10:39
>Subject: Need Quick script for deleting calls records!
>
>
>>Does anyone (Dale) have ,or could kick out quickly, a SQL script that =
would
>>delete the Radius start records in Emerald.. Our Calls records is now =
up
>to
>>800,000 and it's getting a little slow when we look up someone's time
>on....
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com