Using the NetShow Server Event Log

The NetShow Server Event Log redirects events to a Data Access Objects (DAO) database file where the data can be analyzed. The .mdb (Microsoft Access) file can be accessed by Microsoft Access, Microsoft Excel, or any product that can interpret the DAO format.

To begin logging events, you must enable the NetShow Server Event Log; it is disabled by default. To set up logging, you must supply the name of a database (.mdb) file and table to which you want to write event messages. You can use the default settings for the database (Nslog.mdb) and database table (NetShow Server Events). By default, the database is stored in the directory C:\Program Files\Microsoft NetShow\Server.

If you specify a database name that does not exist, the database is automatically created.
If the .mdb file you specify already has the exact schema and table name as the defaults, new messages are appended to the .mdb file. If the .mdb file does not have the table you specify, the table is automatically created.
If the .mdb file has the same table name you specify, with the same fields and field types, but also includes additional fields in the table, records are appended to the table.
If the .mdb table you specify exists, but the fields do not, they are automatically created. If the fields exist, but they are not large enough, an error message is displayed.

The following table describes the default database table fields, data types, and data.

Field name Data type Data

EventDate Date/Time Date/Time

ClientID Text - field size: 15 IP address

Event Type Text - field size: 20 Administrative
Client
Alerts
Server

Event Description Text - field size: 255 See messages description in the Event Types and Database Values section.

Field name	Data type	Data
EventDate	Date/Time	Date/Time
ClientID	Text - field size: 15	IP address
Event Type	Text - field size: 20	Administrative Client Alerts Server
Event Description	Text - field size: 255	See messages description in the Event Types and Database Values section.