Re: [Emerald] Ascend and SQL

Josh Hillman ( (no email) )
Mon, 17 May 1999 14:52:48 -0400

From: Jason Powell <>
>Would it hurt if I ran the following sql scripts....and would they give me
>more detailed call info

All calls stats are in the Calls table, so you can select whatever you want
out of there. Here's a script that we use all the time to generate
statistics (we're use Ascend Max NASes also). We very frequently email
these to our customers when they're running into problems (as proof or
whatever). Just enter in the user's username toward the bottom and let it
go. There's a lot more info in the Calls table than what we're extracting
below, but typically the stuff below is sufficient:

/* Call Statistics for a given username */

SELECT "Date/Time At End Of Call"=CallDate,
FROM Calls, Servers
WHERE IPAddress = NASIdentifier
AND AcctStatusType = 2
AND Username = ''
/* AND CallDate >= '3/1/99' */