This section contains the following commands:
For information on how to interpret netsh command syntax, see Formatting Legend.
Accounting commands
The following entries provide details for each command.
reset filelog
Restores the log file configuration to the default settings.
Syntax
reset filelog
Remarks
By default, the following information is logged by Network Policy Server (NPS):
- Accounting requests
- Authentication requests
- Periodic accounting status
- Periodic authentication status
The default log file format is database-compatible, and a new log file is created monthly. When the hard disk is full, old log files are automatically deleted to create disk space for new log files. The default log file directory is windir\System32\LogFiles.
reset sqllog
Restores the Microsoft SQL Server™ logging configuration to the default settings.
Syntax
reset sqllog
Remarks
By default, SQL Server logging settings are not configured.
set filelog
Sets the configuration for the NPS log file.
Syntax
set filelog [ [ accounting = ] Enable | Disable [ authentication = ] Enable | Disable [ periodicstatus = ] Enable | Disable [ directory = ] directory [ format = ] IAS | ODBC [ deleteold = ] Enable | Disable [ frequency = ] Daily | Weekly | Monthly | Unlimited | Size [ maxsize = ] maxsize ]
Parameters
- accounting
- Optional. Specifies whether accounting requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- authentication
- Optional. Specifies whether authentication requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- periodicstatus
- Optional. Specifies whether periodic status requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- periodicauthstatus
- Optional. Specifies whether periodic authentication status requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- directory
- Optional. Specifies the folder location where log files are stored. If no folder location is specified, the default folder location is windir\System32\LogFiles.
- format
- Optional. Specifies the logging format used by NPS. If you specify IAS, IAS format is used. If you specify ODBC, database-compatible format is used.
- deleteold
- Optional. Specifies whether old log files are deleted when hard disk space is full. If you specify Enable, old log files are automatically deleted when disk space is full. If you specify Disable, old log files are not deleted when disk space is full. The default is Enable.
- frequency
- Optional. Specifies the frequency at which new log files are created by NPS. If you specify Daily, new log files are created on a daily basis. If you specify Weekly, new log files are created every seven days. If you specify Monthly, new log files are created once per month. If you specify Unlimited, a new log file is never created and NPS always logs to the same file. If you specify Size, NPS creates a new log file when the old log file reaches the size specified with the maxsize parameter. The default is Monthly.
- maxsize
- Optional. Specifies the maximum size, in megabytes (MB), for the NPS log file. 1-100000 are valid sizes. If you specify a value for maxsize, you must also specify frequency=Size. If you specify frequency=Size and you do not specify a value for maxsize, the value for maxsize is automatically set to 10 MB.
Remarks
You must provide at least one parameter for this command to change log file settings. If you do not supply at least one parameter, no settings are changed.
set sqllog
Modifies the SQL Server logging settings in the NPS configuration.
Syntax
set sqllog [ [ connection = ] connection [ description = ] description [ accounting = ] Enable | Disable [ authentication = ] Enable | Disable [ periodicstatus = ] Enable | Disable [ maxsessions = ] maxsessions ]
Parameters
- connection
- Optional. Specifies the SQL Server connection initialization string. The basic format of a connection string is based on the Open Database Connectivity (ODBC) connection string. See Remarks for more information.
- description
- Optional. Specifies a description for the SQL Server connection.
- accounting
- Optional. Specifies whether accounting requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- authentication
- Optional. Specifies whether authentication requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- periodicstatus
- Optional. Specifies whether periodic status requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- periodicauthstatus
- Optional. Specifies whether periodic authentication status requests are logged by NPS. If you specify Enable, these requests are logged. If you specify Disable, these requests are not logged. The default is Disable.
- maxsessions
- Optional. Specifies the maximum number of concurrent sessions allowed between the NPS server and the server running SQL Server. 1-100 are valid values. If you do not specify a value for maxsessions, the value for maxsessions is automatically set to 2.
Remarks
- You must provide at least one parameter for
this command to change SQL Server logging settings. If you do not
supply at least one parameter, no settings are changed.
- The format of a SQL Server connection string
is based on ODBC connection string syntax. For more information,
see the topic Connection String Syntax in the "OLE DB Programmer's
Reference" on the Web at
http://go.microsoft.com/fwlink/?LinkId=70406.
Example
set sqllog connection ="Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=database_name;Data Source=server_name"
show filelog
Displays the log file configuration for the local NPS server.
Syntax
show filelog
Remarks
This command displays the accounting configuration for the NPS server on which the command is run. In the NPS console, this information is displayed in Accounting.
Example
Following is an example of the log file settings that are displayed when you run the show filelog command.
|
Accounting |
= Enabled |
|
Authentication |
= Enabled |
|
Periodic status |
= Enabled |
|
Periodic authentication status |
= Enabled |
|
Directory |
= C:\Windows\system32\LogFiles |
|
Format |
= ODBC formatting |
|
Delete old logs |
= Enabled |
|
Frequency |
= Monthly logs |
|
Max size |
= 10 MB |
show sqllog
Displays the SQL Server logging configuration for the local NPS server.
Syntax
show sqllog
Remarks
This command displays the SQL Server accounting configuration for the NPS server on which the command is run. In the NPS console, this information is displayed in Accounting.
Example
Following is an example of the SQL Server logging settings that are displayed when you run the show sqllog command.
|
Connection |
= |
|
Description |
= |
|
Accounting |
= Enabled |
|
Authentication |
= Enabled |
|
Periodic status |
= Enabled |
|
Periodic authentication status |
= Enabled |
|
Max sessions |
= 2 |