Search Again: Re: Usage Question From: Dennis B. Hopp Date: Tuesday, July 22, 2003 Time: 10:01:46 pm I think I *might* have a solution but I have another question... If the results are returned with 2 lines containing the same username will optigold combine those two? This SQL query is getting ugly enough as it is.... --Dennis ----- Original Message ----- From: "Dennis B. Hopp" <dhopp@journey.com> To: "Optigold ISP List" <isp-list@optigold.com> Sent: Wednesday, July 23, 2003 12:03 AM Subject: Re: [Optigold ISP] Usage Question > Hrmph.... > > Anybody know how I can create a SQL query to join the two (i.e. just add the > usage data for user and user@journey.com)? I've been trying to figure it > out for the last couple of hours... > > I have to keep the domain in my accounting logs for wholesale dialup billing > records but our local users have been able to dialing in with both (and > since we use CISP for our roaming customers being able to dial in with the > domain is a must) > > --Dennis > > ----- Original Message ----- > From: "Shawn Hogan" <shawn@digitalpoint.com> > To: "Optigold ISP List" <isp-list@optigold.com> > Sent: Tuesday, July 22, 2003 11:56 PM > Subject: Re: [Optigold ISP] Usage Question > > > > Dennis B. Hopp wrote: > > > > > I'm finally setting up opti to pull in usage reports. It seems to be > > > working well but I have one question. > > > > > > In my radius logs the user may be stored as "user@journey.com" or just > > > "user" (depending on how the user logged in). Does optigold by default > > > append all usage information to whatever username is before the @ symbol > if > > > it encounters that? Or how is that handled? > > > > Optigold will try to match up whatever is in the first field of your > import > > to the customer's login... so if you are importing it as "login", it will > > match up to the customer's "login"... So, if the import doesn't match the > > customer's login exactly (if Optigold has a domain in the login and the > > import does not), it will not match. > > > > - Shawn > > > > ---------------------------------- > > Shawn D. Hogan > > President, Digital Point Solutions > > http://www.digitalpoint.com > > (858) 452-3696 > > > > > > --------------------------------------------------- > > To subscribe, unsubscribe or to search list archive > > please visit http://www.optigold.com/lists/isp.html > > --------------------------------------------------- > > > > > > --------------------------------------------------- > To subscribe, unsubscribe or to search list archive > please visit http://www.optigold.com/lists/isp.html > --------------------------------------------------- > --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: usage question by Brendan McAlpine on Nov 14, 2001 at 12:02:07 pm usage question by Brendan McAlpine on Nov 14, 2001 at 1:38:54 pm Re: usage question by Shawn Hogan on Nov 14, 2001 at 4:29:10 pm Re: usage question by Brendan McAlpine on Nov 15, 2001 at 3:41:25 pm Re: usage question by Shawn Hogan on Nov 15, 2001 at 5:20:08 pm Re: usage question by Brendan McAlpine on Nov 15, 2001 at 6:24:52 pm usage question by Dawn D. Pfaltzgraff on Mar 18, 2003 at 12:25:58 pm Re: usage question by Shawn Hogan on Mar 18, 2003 at 12:34:29 pm Usage Question by Dennis B. Hopp on Jul 22, 2003 at 6:40:30 pm Re: Usage Question by Shawn Hogan on Jul 22, 2003 at 8:57:10 pm Re: Usage Question by Dennis B. Hopp on Jul 22, 2003 at 9:04:25 pm Re: Usage Question by Dennis B. Hopp on Jul 22, 2003 at 10:01:46 pm Re: Usage Question by OurLink Technologies, Inc. on Jul 23, 2003 at 4:59:35 am Re: Usage Question by Dennis B. Hopp on Jul 23, 2003 at 6:56:24 am Usage question by SNC-OG on Jul 27, 2003 at 3:55:15 am Re: Usage question by Shawn Hogan on Jul 28, 2003 at 9:53:36 am usage question by Patti Jones on Dec 8, 2003 at 7:13:26 pm Re: usage question by Shawn Hogan on Dec 12, 2003 at 12:23:03 pm Re: usage question by Patti Jones on Dec 12, 2003 at 12:50:38 pm