I would like to make an online usage graph like the MRTG one at
http://www2.nw.com.br/modems/pm.3.html but I don't know if MRTG could access
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
From: Dale E. Reed Jr. <firstname.lastname@example.org>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
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. (email@example.com)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
> RadiusNT Mailing List firstname.lastname@example.org