RADREP is a general-purpose tool that can be used to generate end user usage and billing reports from RADIUS accounting log files, often also referred to as detail files.

Accounting log formats supported by RADIUS include Microsoft IAS, Livingston, Funk Steel Belted Radius, CISCO Secure (ACS) and other RADIUS servers which write their logs as .CSVs (Comma Separated Values).

The extended ability to group users into Office/Location and Department/Business Unit allows those using RADREP for corporate charge-back and usage reporting purposes to accurately allocate costs associated with providing a network access or remote access service. Billing rates and charges can be allocated based on either a users connect/usage time or on the amount of traffic (data volume) which they transfer during the selected reporting period.

Most free and commercial RADIUS servers (including many of those which are bundled with token based authentication systems) do not give much attention to the reporting side of the RADIUS protocol.

The design of RADREP is such that it can be used as a stand-alone RADIUS reporting engine, or in an integrated manner specifically with the RSA SecurID ACE/Server.

The RADIUS server which is bundled with the RSA ACE/Server v4.x, 5.x and 6.x does not include any reporting mechanism for RADIUS accounting, so this tool can provide invaluable and meaningful reports by extracting useful information from both the RADIUS accounting logs and/or the ACE/Server database.

All users are presented in a selectable hierarchical representation which is categorized by Site, Group, and User. Report selection criteria includes Site/Office, Group/Department and User-Name/Login-ID details as well as the report start and end date range.

To generate a report for all Sites, Groups and Users, the 'Entire Company', at the root level of the hierarchy, can be selected. Configuration options allow the setting of any relevant fixed and variable billing charges, TAX to be applied, file locations of the RADIUS log files, the report output directory, and numerous other options.

Report output formats include comma delimited (CSV files) for easy importing into Microsoft Excel (or other text editors/viewers) and web based (HTML) output for viewing within a web browser. CSV report output gives you the ability to further manipulate the report output data in Microsoft Excel, while the web based reports provide an easy navigable way to view reports from a standard web browser.

To see some sample report output please refer to the 'RADREP Sample Reports' document or for the most up to date sample reports view them online at http://www.radiusreporting.com
Here are some key features of "RADREP RADIUS Reporting Billing Tool":

· Easy to configure and use Windows 98/NT4/2000/XP/2003 GUI application.
· Quick setup time means you will be generating reports from your RADIUS logs within minutes.
· Supports all well known RADIUS server accounting log formats.
· Generates 'Usage' reports showing user usage patterns and aiding in diagnosis of connection problems.
· Generates 'Billing' reports for internal charge back and cost allocation purposes.
· Ideal for Wireless Infrastructure usage reporting and billing.
· Ability to group users, and hence view reports by Site/Location, Group/Department. Concise analysis of even the largest RADIUS accounting logs. A true RADIUS log analysis and reporting tool. No intermediate databases to setup or import log data to before generating reports. No hidden Implementation or Database licensing costs.


The following RADIUS Servers and Client device log output has been tested and verified to work with RADREP:

· Microsoft IAS/RAS *Both 'Database compatible file format' and 'IAS standard format' are supported in Windows 2000/2003 Server.
· Livingston
· Funk Steel Belted Radius
· CISCO Secure (ACS)
· Novell BorderManager (BMAS) RADIUS Services *Standard log format is preferred. E.g. LOAD RADIUS fileFormat = standard
· SafeWord PremierAccess
· RSA ACE/Server * In ACE/Server 5.X and greater Text Format (standard) is the preferred accounting log format.
· ClearBox RADIUS Server (www.xperiencetech.com)
· Aradial RADIUS Server (www.aradial.com)
· TCCRadius (Talon Computer Consulting Radius) *Compatibility mode enabled via 'radrep.ini' configuration parameter.
· Aventail
· Juniper
· Nortel
· 3Com
· Ascend Radius
· Lucent NavisRadius
· ActivCard/ActivPack AAA RADIUS *ActivPack Logs must be converted to Livingston Logs first using the 'activ2liv.exe' conversion utility .
· Shiva/Intel
· FreeRADIUS
· Cistron RADIUS
· Radiator

Reports generated by RADREP are in HTML (web) and CSV (comma separated value) formats. The web report output can easily be hosted on a web server of your choice for easy viewing by anyone with a web browser.

Report output formats:

· HTML for viewing in Internet Explorer and other web browsers.
· CSV for viewing and further manipulation in Microsoft Excel.

All web reports are also fully locally navigable as HTML files. The CSV reports are provided as an alternative format for viewing the user based usage and billing reports in Microsoft Excel or other tools which can view CSV files.

If you would rather try it yourself then download RADREP and give it a go in your environment, you won't be disappointed with how easily and quickly it can generate detailed usage and billing reports from RADIUS accounting logs.

Limitations:

· If you choose to purchase RADREP, you will receive a version that states in the 'About' dialogue box that it is licensed to you. It will not be limited to reporting on 25 users, and have the demonstration/evaluation banner removed from each of the HTML (web) reports. Maintained customers will also automatically be eligible for any new releases of RADREP (within the first 12 months of purchase) that will contain added features, enhancements and additional reporting capabilities.

What's New in This Release: [ read full changelog ]

· Added 2 User-Name retrieval filter options
· Added a configuration field called MAX_USERNAME_CHARS in the [Hidden Settings] sections of the radrep.ini configuration file that allows you to modify the maximum number of characters in the user-name field. The default is 40 characters. Increasing this value will allow the support of usernames that have very long REALM/ROLE or FQDN suffixes. In most cases a user-name field of more than 40 characters indicates that there is some sort of corruption or problem within the log file being processed