RMS Logging Database Tables
Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2
This section describes the RMS logging database tables.
DRMS_Log_Master
The following table lists an entry for each logging record.
Name | Data Type | NULLs | Description |
---|---|---|---|
i_LogID |
int |
IDENTITY(100,1) Not NULL |
Unique ID for this logging record |
s_HostMachineName |
nvarchar(64) |
NULL |
Server that generated this record |
s_HostMachineRequestId |
nvarchar(64) |
NULL |
Request ID |
dt_RequestTime |
datetime |
NULL |
Date and time of request |
s_RequestPath |
nvarchar(128) |
NULL |
URL path of the request |
s_RequestType |
nvarchar(64) |
NULL |
Type of request |
s_RequestUserAddress |
nvarchar(32) |
NULL |
IP address of the client |
s_RequestUserAgent |
nvarchar(128) |
NULL |
User agent header of the client |
s_AuthenticatedState |
nvarchar(64) |
NULL |
Authentication status of the request |
s_SecureConnectionState |
nvarchar(64) |
NULL |
SSL protection of the request |
s_AuthenticatedId |
nvarchar(128) |
NULL |
ID of the authenticated user |
s_ReceivedXrML |
ntext |
NULL |
XrML received from the client in the request |
s_IssuedXrML |
ntext |
NULL |
XrML license issued in the request |
s_Metadata |
ntext |
NULL |
Metadata |
s_SuccessOrFailure |
nvarchar(32) |
NULL |
Success or failure of the request |
s_ErrorInformation |
ntext |
NULL |
Error data |
dt_LogCreateTime |
datetime |
Not NULL |
Log creation time |
DRMS_Log_Detail
The following table lists additional data for a logging record. Typically, XrML data is logged in this table.
Name | Data Type | NULLs | Description |
---|---|---|---|
i_LogDetailID |
int (PK) |
IDENTITY(100,1) |
Internal index |
i_LogID |
int (FK) |
Not NULL (FK) |
ID of the parent logging record |
s_Name |
nvarchar(128) |
Not NULL |
Name of the property |
s_Value |
ntext |
NULL |
Value of the property |
DRMS_Log_Filter
The following table lists the fields that the logging listener service logs.
Name | Data Type | NULLs | Description |
---|---|---|---|
i_ID |
int |
IDENTITY(100,1) Not NULL |
Internal index |
s_FieldName |
nvarchar(255) |
Not NULL |
Name of the field |
s_FieldDescription |
nvarchar(1024) |
NULL |
Description of the field |
i_IsIncluded |
int |
Not NULL |
Whether the field is logged |