RMS Core Configuration Database Tables
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 |