Exporting Data

The VPN audit log is stored in a Btrieve* file on the Novell BorderManager 3.7 server and is maintained by CSAUDIT.NLM. The audit 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 popular trend analysis software packages, such as WebTrends*.

To export the VPN audit log, complete the following steps:

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

  2. Select Novell BorderManager 3.7 from the Tools menu.

  3. From the Novell BorderManager 3.7 menu, select Export Logs.

  4. Click Set Range and enter the date range.

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

  5. 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 will 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 will not have incremented to the current date.

  6. (Optional) If the default filename is unacceptable, enter a new filename in the File field.

  7. (Optional) If you want to combine the VPN audit log with audit logs from other Novell BorderManager 3.7 services, check the Combine Log Files check box.

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

  8. Under Log Selection, check the VPN check box.

  9. (Optional) If you checked Combine Log Files in Step 8, under Log Selection, check all other Novell BorderManager 3.7 audit log files to be combined with the VPN audit log file.

  10. Click OK.

The audit log is exported to an ASCII file. VPN audit log entries are messages created by various processes and do not follow a fixed format. The messages will be copied to the export file without change.

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
(Novell IP 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 checked the boxes for HTTP proxy, FTP proxy, and VPN, the following logs would result:



  Previous Page: Checking the Status of a VPN Client Connection