Hello Robert -
My first inclination would be to archive the accounting data on a periodic basis (every day, every week, every month, whatever). One easy way to do this is to set up a different table for each month (week, day, whatever) for example and then use the Radiator special characters in your AcctSQLStatement to specify the table name. I really wouldn't suggest storing the integer values as trying to post process the data will be very messy. regards Hugh On Fri, 4 Jan 2002 08:59, Robert Blayzor wrote: > We have a very high number of accounting records that get stored on our > SQL servers, our goal is to reduce space consumption a bit. Is there a > way to have Radiator store the actual value of the RADIUS accounting > attributes and not the dictionary definitions? > > > Ie: > > > EXEC sp_RadiusAcctInsert '0', '00000015', 'Stop', 'joeuser', '6894448', > '5184329030', '64.246.132.1','12', 'Async', 'Framed-User', 'PPP', > '64.246.132.11', '', 'User-Request', '2194', '1138', '63' > > > Instead "Stop", value would be integer 2. > > NAS-Port-Type, Framed-Protocol, etc, all are integers and use much less > space to store than their text meanings. -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.