View and Export Accounting Logs

  1. Consolidate data from the servers. See Consolidate Data from Multiple Servers.
  2. Select Tools, point to Log, then click View Accounting.

     

  3. Important: AAA Server logs do not contain any sensitive data (such as LDAP and static passwords).
    Only usernames and device serial numbers are logged.
  4. For the Time Criteria, specify the From and To dates for the time period required.
  5. For the General Criteria:

    1. Select the Server for the accounting data that you want to view.
    2. To view the logs for a specific server with a pool of servers, select the Server IP address for the required server.
    3. To view data for a specific user, enter the user’s ID in the User ID field.
    4. To view data for a specific attribute set in an accounting profile, enter the attribute’s name in the Attribute field.
  6. Click Show to display the accounting data corresponding to the specified criteria.
  7. Use Print to print the data displayed.

    To produce more sophisticated statistics with standard reporting tools, you can directly access the data from the AAA Server database. (The data is stored in the A_AHLOG table.) Use a tool that supports ODBC.

  8. To export the accounting log to a .csv file, click Export.
  9. In the Save As window, select a file name and location for the exported log, then click Save.

    The log is exported to a text file with the data values separated by commas.