The Novell IP Gateway 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*.
There are two ways to export the Novell IP Gateway audit log information from NetWare Administrator:
If you use the second method, you can combine the audit log files from other Novell BorderManager 3.7 services with the Novell IP Gateway audit log file into a single ASCII file.
To export records from the IP Gateway Users Statistics window, complete the following steps:
In NetWare Administrator, click the Server object representing the Novell BorderManager 3.7 server.
Select Novell BorderManager 3.7 from the Tools menu.
Click IP Gateway > select View Audit Log from the Object menu.
If the records you want to export do not appear, click Display Records, enter the dates for the records you want to display > click OK.
In the IP Gateway Users Statistics window, click Export Data and enter the path and filename or click Browse to select a destination for the export file.
Select one of the following sort formats under Information Output Selection > click OK:
(Conditional) 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 5.
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:
Use the Export Logs selection from the Novell BorderManager 3.7 pull-down menu to export the Novell IP Gateway audit log. This procedure extracts the same data from the Btrieve database, but offers additional export options that cannot be activated from the IP Gateway Users Statistics window.
To export the Novell IP Gateway audit log using the Export Logs menu selection:
In NetWare Administrator, click the Server object representing the Novell BorderManager 3.7 server.
Select Novell BorderManager 3.7 from the Tools menu.
From the Novell BorderManager 3.7 menu, select Export Logs.
Click Set Range > enter the date range.
This is the range of dates comparable to the dates used to display records in the IP Gateway Users Statistics window. The default range is the current server date.
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.
(Optional) If the default filename is unacceptable, enter a new filename in the File field.
(Optional) If you want to combine the Novell IP Gateway 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.
Under Log Selection, check the IPX gateway check box.
NOTE: Checking the box for IPX gateway exports the entire audit log file for the Novell IP Gateway, not just the records for the IPX/IP gateway service.
(Optional) If you checked Combine Log Files in Step 7, under Log Selection, check all other Novell BorderManager 3.7 audit log files to be combined with the Novell IP Gateway audit log file.
Click OK.
The audit 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 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.
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 IPX gateway, the following logs would result: