Exporting Data

The access control log is stored in a Btrieve file on the Novell BorderManager 3.8 server and is maintained by csaudit.nlm. The access log cannot be edited or manipulated from the server; however, the data can be exported for analysis. The format of the exported data is compatible with trend analysis software packages, such as WebTrends.

There are two ways to export the access control log from NetWare Administrator:

If you use the second method, you can also combine the audit log files from other Novell BorderManager 3.8 services with the access control log into a single ASCII file.


Exporting Data from the Access Control Users Statistics Window

  1. In NetWare Administrator, click the server object representing the Novell BorderManager 3.8 server.

  2. Click Tools > Novell BorderManager 3.8, then click View Access Control.

  3. Click Display Records, specify the dates for the records you want to display, then click OK.

  4. In the Access Control Users Statistics window, click Export Data and specify the path and filename.

    or

    Click Browse to select the destination of the export file.

  5. Select one of the following sort formats under Information Output Selection, then click OK.

    • Entry Time (connection by connection): (Default selection) Sorts records from the earliest entry time to latest entry time.
    • Access by users: Sorts records in alphabetic order based on the user's NDS or eDirectory username.
    • Access by hosts: Sorts records in ascending order (for IP addresses) or alphabetic order (for DNS hostnames).
  6. If the export filename already exists under the directory path selected, you are prompted to replace the file. Click Yes to overwrite the file or No to specify the destination as described in Step 4.

The record fields are written to disk with a tab as the delimiter. Each record ends with a carriage return and line feed. The exported data has the following format:


Exporting Data Using the Export Logs Option

The procedure to export access control data using the Export Logs option from the Novell BorderManager 3.8 menu extracts the same data from the Btrieve database, but offers additional export options that cannot be activated from the Access Control Users Statistics window.

To export the access control log:

  1. In NetWare Administrator, click the server object representing the Novell BorderManager 3.8 server.

  2. Click Tools > Novell BorderManager 3.8, then click Export Logs.

  3. Click Set Range to specify the date range.

    This is the range of dates comparable to the dates used to display records in the Access Control Users Statistics window. The default range is the current server date.

  4. Click Browse to select the drive mapped to the destination for the export file.

    This is the path and filename for the export file. The default destination is a:\yyyymmdd.log, where yyyy is the current year, mm is the current month, and dd is the current day. If you change the filename from the default format, the filename does not reflect the current server date. For example, if you change the filename format to mmddyyyy.log, the next time you try to export logs on another day, the log filename would not have incremented to the current date.

  5. (Optional) If the default filename is unacceptable, specify the filename in the File field.

  6. (Optional) If you want to combine the access control log with audit logs from other Novell BorderManager 3.8 services, select the Combine Log Files check box.

    This feature allows log files from different services to be combined into a single output file. When log files are combined, they are appended to one file, service by service.

  7. Under Log Selection, select the box for ACL.

    If the Combine Log Files feature has been selected, select all the services whose data will be combined into the export log file.

  8. (Optional) If you selected Combine Log Files in Step 6, under Log Selection, select all other Novell BorderManager 3.8 services audit log files to be combined with the access control log file.

  9. Click OK.

The access control log is exported to an ASCII file. The record fields are written with a tab as the delimiter. Each record ends with a carriage return and line feed. The exported access control data has the following fields:

If the Combine Log Files feature is not selected and you select one or more services under the Log Selection field, a separate export file is created for each service under a subdirectory of the export destination path.

The export subdirectories used are shown in the following table.

Log Type Export Subdirectory

HTTP Proxy

HTTP

FTP Proxy

FTP

NNTP Proxy

NNTP

Mail Proxy

SMTP

RealAudio* and Real Time Streaming Protocol (RTSP) Proxies

RAUDIO

DNS Proxy

DNS

Generic Proxy

GENERIC

SOCKS Client

SOCKS

IPX Gateway

IPXGW

VPN

VPN

ACL (access control)

ACL

For example, if you specified an export destination of vol1:logs\19981019.log, did not select the Combine Log Files feature, and selected the boxes for HTTP Proxy, SOCKS client, and ACL, the following log files would result: