Search Again: Re: Usage Question From: Dennis B. Hopp Date: Tuesday, July 22, 2003 Time: 9:04:25 pm 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 ---------------------------------------------------

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