 |  |
Yeah I had figured out the select CASE stuff. But I didn't think about
Re: Usage Question
From: Dennis B. Hopp
Date: Wednesday, July 23, 2003
Time: 6:56:24 am
doing the "as blah" part....I'll give that a try.
Thanks,
--Dennis
----- Original Message -----
From: "OurLink Technologies, Inc." <sales@ourlink.net>
To: <isp-list@optigold.com>
Sent: Wednesday, July 23, 2003 7:58 AM
Subject: Re: [Optigold ISP] Usage Question
> 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
> ---------------------------------------------------
>
---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page
| home | |
| products | |
| services | |
| support | |
| email lists |
| optigold isp | |
| optigold isp news | |
| home inspection | |
| inspectrix | |
| java companion | |
| oracle | |
| quickdns pro | |
| search engine | |
| veterinary |
| tips | |
| employees | |
| free tools | |
| portfolio | |
| jobs | |
| contact |
888/4-DPOINTSupport:
858/452-3696