No problem :)
> We had it narrowed down to one or two customers and the second querie
> gave us the answer we needed.
>
> Is there a way to put this in "CR6" and have it pop up and ask for the
> username?
>
> And via vi input the port address and output the username?
I have no idea. We still have CR 4.5 on our machine. I think we have 5.0
(came with Cold Fusion 2.0 or some other program) but I've never messed
around with that or 6.0.
I've always wanted to make reports that I could run and have it ask for
things like start/end dates or a username, etc. Emerald has the option to
select date ranges, but as far as I know, you can't add your own reports to
that section. The custom reports section doesn't give you any options for
dates, etc.
Josh Hillman
hillman@talstar.com
> At 12:58 PM 4/28/1998 -0400, you wrote:
> >> From: John Lange <radadmin@palacenet.net>
> >> 1. I need to report all users on a "particular" port during a
specified
> >> time period. Either DNS port name and or ip address.
> >
> >If you have SQL, use ISQL/w:
> >Here's a script that I use on occasion. It's not exactly what you're
> >looking for, but you might be able to use it/manipulate it a little to
fit
> >your needs...
> >
> >/* How many sessions were online at any given point in time */
> >DECLARE @datetime char(20)
> >SELECT @datetime = '4/25/98 10:17PM'
> >SELECT Username,
> > FramedAddress,
> > "Start Of Call"=DateAdd(Second, 0-AcctSessionTime-AcctDelayTime,
> >CallDate),
> > "End Of Call"=DateAdd(Second, 0-AcctDelayTime, CallDate),
> > "Seconds Online"=AcctSessionTime
> >FROM Calls
> >WHERE DateAdd(Second, 0-AcctSessionTime-AcctDelayTime, CallDate) <=
> >@datetime
> >AND DateAdd(Second, 0-AcctDelayTime, CallDate) >= @datetime
> >AND AcctStatusType = 2
> >AND NASPort = 20109 /* change this to whatever you need it to be */
> >AND NASIdentifier = 123.123.123.123 /* this is your NAS IP address
> > and is only needed if you have multiple NASes */
> >ORDER BY CallDate
> >
> >> 2. Then I need a report that shows a "particular" user and the
"time",
> >> "port" and "ip" if possible, this user was online.
> >
> >SELECT "Date/Time at END of call"=CallDate, NASPort, FramedAddress,
> >"Seconds Online"=AcctSessionTime
> >FROM Calls
> >WHERE UserName = 'whoever'
> >ORDER BY CallDate
> >
> >> Is there a way to certify that this info is accurate?
> >
> >I have no idea about "certification" but I would definately not delete
the
> >data for a while...
> >
> >Josh Hillman
> >hillman@talstar.com
> >
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
> >
> >
> >
>
> John C. Lange, Sr. PALACE dot NET, INC.
> microjl@palacenet.net MICRO-TECH Computers, Inc.
> 608.742.1601 & 6980 2800 New Pinery Road
> http://www.palacenet.net/ Portage, WI 53901
> Visit our online store @ http://www.microt.com/
> Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
>
> --- __o
> --- _-\<,_ Fastest Service in Town
> --- (_)/ (_)
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com