RMS Core Configuration Database Tables

Updated: June 1, 2008

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

This topic describes the RMS core configuration database tables.

DRMS_ApplicationExclusionList

The following table lists information about excluded applications.

 

Name Data Type NULLs Description

ID

int

IDENTITY(100,1) Not NULL

Internal index

Name

nvarchar(256)

Not NULL

Application name

VersionMinMajor

int

NULL

Application minimum major version number

VersionMinMinor

int

NULL

Application minimum minor version number

VersionMinBuild

int

NULL

Application minimum build version number

VersionMinRevision

int

NULL

Application minimum revision version number

VersionMaxMajor

int

NULL

Application maximum major version number

VersionMaxMinor

int

NULL

Application maximum minor version number

VersionMaxBuild

int

NULL

Application maximum build version number

VersionMaxRevision

int

NULL

Application maximum revision version number

Description

nvarchar(256)

NULL

Application description

dt_DateUpdated

datetime

NULL

Update timestamp

dt_DateCreated

datetime

NULL

Creation timestamp

DRMS_AsynchronousQueue

The following table lists information about the message queue.

 

Name Data Type NULLs Description

AsyncQueueID

Int (PK)

IDENTITY (100,1) Not NULL

Internal index

QueueName

nvarchar(256)

Not NULL

Path to the message queue

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_CaType

The following table lists information about the type of certificate issued to the client.

 

Name Data Type NULLs Description

ID

Int (PK)

Not NULL

The ID for the certificate

TypeName

nvarchar(256)

Not NULL

Either Desktop, MobileDevice, or Server

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_ClusterConfiguration

The following table lists information about the current server licensor certificate that is in the DRMS_LicensorCertificate table.

 

Name Data Type NULLs Description

CurrentLicensorCertID

int (FK)

NULL

The active licensor certificate

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_ClusterPolicies

The following table lists information about the locations where the cluster policies are stored.

 

Name Data Type NULLs Description

PolicyID

Int (PK)

IDENTITY(100,1) Not NULL

ID of policy

PolicyName

nvarchar(64)

Not NULL

Name of policy

PolicyData

sql_variant

NULL

Policy data

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_ClusterServer

The following table lists information about the servers that are in the cluster.

 

Name Data Type NULLs Description

ServerID

Int (PK)

IDENTITY(100,1) Not NULL

ID of server

ServerName

nvarchar(256)

Not specified

Computer name for the server

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_GICExclusionList

The following table lists information about the excluded rights account certificates.

 

Name Data Type NULLs Description

PublicKeyIndex

Int (PK)

IDENTITY(100,1) Not NULL

Internal index

PublicKey

PublicKey

Not NULL

Public Key bytes

UserID

int

NULL

User ID index

ExpirationDate

datetime

NULL

Date when the rights account certificate expires

Description

nvarchar(256)

NULL

NAME associated with this excluded rights account certificate key

dt_DateUpdated

datetime

Not NULL

Update timestamp

dt_DateCreated

datetime

Not NULL

Creation timestamp

DRMS_LicensorCertificate

The following table lists information about the active server licensor certificate.

 

Name Data Type NULLs Description

i_CertID

Int (PK)

IDENTITY(100,1) Not NULL

ID of policy

s_CertGUIDType

nvarchar(64)

Not NULL

Key pair ID Type

s_CertGUID

nvarchar(128)

Not NULL

Key pair ID GUID

i_CertificateID

int (FK)

Not NULL

Pointer to actual certificate

dt_DateUpdated

datetime

NULL

Update timestamp

dt_DateCreated

datetime

NULL

Creation timestamp

DRMS_LicensorPrivateKey

The following table contains information about the private key of the active server licensor certificate.

 

Name Data Type NULLs Description

PrivateKeyID

Int (PK)

IDENTITY (100,1) Not NULL

Internal index

CertGUIDType

nvarchar(64)

Not NULL

Key pair ID Type

CertGUID

nvarchar(128)

Not NULL

Key pair ID GUID

PrivateKey

varbinary(2048)

NULL

Binary representation of the key

CSP

nvarchar(512)

NULL

Name of the cryptographic service provider (CSP)

CSPType

int

NULL

Type of CSP

KeyContainerName

nvarchar(512)

Not specified

Name of the key container

KeyNumber

int

NULL

Key number

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_PassportDenyList

The following table lists information about the Microsoft® .NET Passport accounts that are to be denied licenses.

 

Name Data Type NULLs Description

DenyID

Int (PK)

IDENTITY(100,1) Not NULL

Internal index

DenyAddressPattern

nvarchar(500)

Not NULL

User name/Domain name

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_Plugin

The following table lists information about plug-ins.

 

Name Data Type NULLs Description

PluginID

Int

IDENTITY(100,1) Not NULL

Internal index

PluginTypeID

int (FK)

NULL

Type of plug-in

NameSpace

nvarchar(128)

Not NULL

Namespace for this plug-in

PluginName

nvarchar(128)

Not NULL

Name of this plug-in

Ordinal

Int

Not NULL

Sequence number in which the plug-in executes

Path

nvarchar(512)

Not NULL

Path to the DLL file

ObjectTypeName

nvarchar(50)

NULL

Not used

DebugMode

int

NULL

Specifies whether to run a plug-in in debugging mode

PublicKey

PublicKey

NULL

Public key of the plug-in

Version

nvarchar(64)

NULL

Version of the plug-in

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_AllowedPluginVersions

The following table lists information about the plug-in versions allowed to participate in the RMS system.

 

Name Data Type NULLs Description

RowID

int

Not NULL

Internal index

PluginID

int

IDENTITY(100,1) Not NULL

Internal index

VersionInfo

nvarchar(64)

Not specified

Version of the plug-in

DRMS_PluginProperties

The following table lists information about the plug-in properties.

 

Name Data Type NULLs Description

PropertyID

int

IDENTITY(100,1) Not NULL

Internal index

PluginID

int (FK)

NULL

Plug-in ID to which the property belongs

PropertyName

nvarchar(256)

Not NULL

The property name for this configuration data

PropertyValue

text

Not NULL

The property value for this configuration data

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_PluginType

The following table lists information about the plug-in type.

 

Name Data Type NULLs Description

PluginTypeID

Int (PK)

Not NULL

Internal index

PluginTypeName

nvarchar(256)

Not NULL

Name of this plug-in

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_RightsTemplate

The following table lists information about rights policy templates.

 

Name Data Type NULLs Description

Guid

nvarchar(128) (PK)

Not NULL

GUID of the rights policy template

TemplateData

ntext

Not NULL

This field contains the XrML template data.

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_TrustedCertificateAuthorities

The following table lists the information about the trusted certification authorities.

 

Name Data Type NULLs Description

ID

Int (PK)

IDENTITY(1,1) Not NULL

Internal index

CertificateID

int (FK)

Not NULL

ID of the certificate

CertificateGUID

nvarchar(128)

Not NULL

GUID of the certificate

CaTypeID

int (FK)

Not NULL

Type of certification authority

DateUpdated

datetime

NULL

Update timestamp

DateCreated

datetime

NULL

Creation timestamp

DRMS_TrustedEmailDomains

The following table lists information about the e-mail domains that are trusted in the RMS environment

 

Name Data Type NULLs Description

ID

int (PK)

IDENTITY(100,1) Not NULL

Internal index

i_TrustedIdentityDomainID

int (FK)t

NULL

Internal index

s_EmailDomainName

nvarchar(256)

NULL

List of e-mail domain names that are valid for the trusted user domain

DRMS_TrustedIdentityDomain

The following table lists the information about trusted user domains and the trusted publishing domains.

 

Name Data Type NULLs Description

i_TrustedIdentityDomainID

Int (PK)

IDENTITY(100,1) Not NULL

Internal index

s_DomainType

nvarchar(64)

NULL

Type of domain

CertGUIDType

nvarchar(64)

Not NULL

Type of certificate GUID

CertGUID

nvarchar(128)

Not NULL

GUID of the certificate

i_CertificateID

int (FK)

NULL

ID of the certificate

i_allowSID

int

Not NULL

SID of domain

S_friendlyname

nvarchar(255)

NULL

Friendly name of certificate

dt_DateUpdated

datetime

NULL

Update timestamp

dt_DateCreated

datetime

NULL

Creation timestamp

DRMS_XrML_Certificate

The following table lists information about the XrML server licensor certificates that are referenced in the DRMS_LicensorCertificate table. It also maps the certificate chain.

 

Name Data Type NULLs Description

i_CertificateID

Int (PK)

IDENTITY(100,1) Not NULL

Pointer to actual certificate

s_Certificate

ntext

Not NULL

Pointer to actual certificate

i_ParentCertificateID

int (FK)

NULL

Pointer to actual certificate

Community Additions

ADD
Show: