Search Again: Re: Usage Question From: OurLink Technologies, Inc. Date: Wednesday, July 23, 2003 Time: 4:59:35 am Dennis, Not sure which database server that you are using, but you should be able to use a CASE statement in your select to perform the combining of the two records into one with a group by statement. Your SQL will look something like this; select case where charindex('@',login,1) > 0 then left(login,charindex('@',user_nm,1)-1) as user_nm else login as user_nm end , (rest of select fields) from (table name here) where (qualifiers here) group by user_nm, (rest of select fields here) ---------------------------------------------------------------------- Subject: Re: [Optigold ISP] Usage Question From: "Dennis B. Hopp" <dhopp@journey.com> Date: Wed, 23 Jul 2003 00:03:17 -0400 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