i was trying to update callsonline - serverports does the trick nicely!
thanks again,
Mike.
Dale E. Reed Jr. wrote:
> Mike Everest wrote:
> >
> > i have been trying to figure out how to manually update CallsOnline to
> > remove 'stuck' users.
> >
> > one day i may get around to setting up that SNMP failsafe, but am
> > looking for a quick fix where i can run an UPDATE query to set all or
> > specific AcctStatusType from 1 to 2 or remove them entirely.
>
> Try:
>
> Update ServerPorts Set AcctStatusType = 2
> Where UserName = 'xxxx'
>
> Or just:
>
> Update ServerPorts Set AcctStatusType = 2
>
> to clear them all.
>
> --
> Dale E. Reed Jr. (daler@iea-software.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> For more information about this list, including removal, please
> see this URL: http://www.iea-software.com/maillist.html
-- +------------------------------------------------------+ | Mike Everest - IT Services Manager | | __ |\ GSAT Ltd. | | / |__| \ Deakin University Woolstores Campus, | | .' \ PO Box 1818, | | / \ Geelong, Victoria, Australia, 3220. | | \ / Ph 61-3-5227-8022(Geelong), | | \ / 61-3-92446044(Melbourne), | | \_.-'\_o_/ 61-3-5563 3622(Warrnambool), | | FAX 61-3-5227-8023 | | V URL http://www.gsat.net.au | +------------------------------------------------------+
For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html