Re: Need Quick script for deleting calls records!

Steve Williams ( (no email) )
Sun, 8 Mar 1998 11:09:06 +1000

I believe that all the information required for billing and accounting is
contained within the stop record. I deleted over 18,000 start records from
our database and it has not affected any reports.

Sly

-----Original Message-----
From: iml@interconnect.net <iml@interconnect.net>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Sunday, 8 March 1998 11:07
Subject: Re: Need Quick script for deleting calls records!

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 = 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....