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
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. <daler@iea-software.com>
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. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>