Re: online-usage cgi

Danny Sinang ( (no email) )
Sun, 24 May 1998 18:06:32 +0800


I would like to make an online usage graph like the MRTG one at but I don't know if MRTG could access
RRAS's info.

So, I would want to base the graph on the Calls table populated by RadiusNT.
I've been pushing my brain to the limit on how to do it, but I just can't
think of a neat, clean-cut SQL-based way of doing it.

All I've figured out so far is to programmatically create a "Stack" table
and "Push" values ( Calldate, NasPort, Username ) in for each login, along
with an incrementing counter value ( to indicate increase in number of ports
being used ). For each logout, I would "Push" a row also, but this time
with decrementing ctr value ( to indicate a decrease in ports in use ).

Then after this "Stack" table is populated, I would simply use Crystal
Reports Web Report to graph the increasing / decreasing Counter value
against their associated Calldate's.

Can you show me a better way of doing this ?

- Danny Sinang

-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
Date: Thursday, May 14, 1998 3:38 PM
Subject: Re: online-usage cgi

>Danny Sinang wrote:
>> Is there an online version of this graph that we can view ?
>Not publically. :( I did a lot of Cold Fusion scripts and such for
>an earlier version of Emerald that is still used in several intranet
>installations of Emerald (including adding, updating, tsgraph, etc).
>A lot of the work will be available in Emerald 3.0 based on our
>own engine rather than CF.
>The particular TS Graph I referenced uses the old Graphlets that
>I don't think Allaire supports anymore (although you can get them
>from their ftp site). They are really cool for graphing things and
>I used them in several places.
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> RadiusNT Mailing List