The following table lists the database tables that Deployment Workbench creates and manages.

 

Table

Description

BDDAdminCore

Provides backward-compatibility for Microsoft Business Desktop Deployment (BDD) 2.5; not managed by Deployment Workbench.

ComputerIdentity

Used to identify a specific computer using any combination of the AssetTag, UUID, SerialNumber, and MACAddress properties. The table includes a Description column to provide a user-friendly method of describing the computer (usually the computer name).

Descriptions

Contains descriptions of all properties configurable via the database.

LocationIdentity

Used to identify geographic locations using the Location property. The values for this property are stored in a corresponding column in the table.

LocationIdentity_DefaultGateway

Relates the default gateway values with a location identified in the LocationIdentity table. There is a one-to-many relationship between this table and the LocationIdentity table.

MakeModelIdentity

Used to identify a specific make and model of a computer using the Make and Model properties. The values for these properties are stored in corresponding columns in the table.

PackageMapping

Used to associate the name presented in the Add or Remove Programs Control Panel item with a Configuration Manager 2012 or Configuration Manager 2007 R3 package and program to be deployed in place of the application in Add or Remove Programs. For more information on this table, see the section, Deploying Applications Based on Earlier Application Versions, in the MDT document Microsoft Deployment Toolkit Samples Guide.

RoleIdentity

Used to identify the purpose of a computer or the users of a computer using the Role property. The values for this property are stored in a corresponding column in the table.

Settings

Identifies the settings that are applied to an individual computer or a group of computers based on the settings in the Computers, Roles, Locations, and Make and Model nodes in the Database node in the Deployment Workbench.

Settings_Administrators

Identifies the user accounts to be added to the local Administrator group on the target computer based on the settings in the Computers, Roles, Locations, and Make and Model nodes in the Database node in the Deployment Workbench.

Settings_Applications

Identifies the applications to be deployed to the target computer based on the settings in the Computers, Roles, Locations, and Make and Model nodes in the Database node in the Deployment Workbench.

Settings_Packages

Identifies the packages to be deployed to the target computer based on the settings in the Computers, Roles, Locations, and Make and Model nodes in the Database node in the Deployment Workbench.

Settings_Roles

Identifies the roles to be associated with the target computer based on the settings in the Computers, Locations, and Make and Model nodes in the Database node in the Deployment Workbench.

 

Related Topics

Tables and Views in the MDT DB