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