Tables and Views in the Deployment Workbench Database

  • Article

In BDD 2007, you can store many property settings (normally configured in the CustomSettings.ini file) in a database. Configuring the properties in a database helps create a generic CustomSettings.ini file that requires fewer modifications and allows one CustomSettings.ini file to be used in more images (because the file is more generic).

You can customize the database through the Database node in the Deployment Workbench console tree. Through Deployment Workbench, you configure the deployment settings, which are saved in tables.

However, queries about the information in the tables are done through views. The views help simplify the queries by joining results from multiple tables. ZTIGather.wsf queries the views to return the result set specified by the Parameters and ParameterCondition properties.

For more information on configuring deployment settings through the Database node in Deployment Workbench, see “Configuring the Rules in the Deployment Workbench Database” in the Deployment Configuration Guide.

On This Page

Tables in the Deployment Workbench Database Tables in the Deployment Workbench Database
Views in the Deployment Workbench Database Views in the Deployment Workbench Database

Tables in the Deployment Workbench Database

Table 2 lists the database tables that Deployment Workbench creates and manages.

Table 2. Tables That Deployment Workbench Manages and Their Descriptions

Table

Description

BDDAdminCore

Provided for backward compatibility for BDD 2.5; not managed by Deployment Workbench.

ComputerIdentity

Used to identify a specific computer by 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).

LocationIdentity

Used to identify geographic locations by using the Location property. The values for this property are stored 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 by using the Make and Model properties. The values for these properties are stored in corresponding columns in the table.

PackageMapping

Used in associating the name presented in the Add or Remove Programs Control Panel item with an SMS 2003 package and program to be deployed in place of the application in Add or Remove Programs. For more information on this table see “Deploying Applications Based on Previous Application Versions” in Deployment Configuration Samples Guide.

RoleIdentity

Used to identify the purpose of a computer or the users of a computer by using the Role property. The values for this property are stored 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 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 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 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 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 Deployment Workbench.

Views in the Deployment Workbench Database

Table 3 lists the database views that are used for querying configuration information from the database and their description.

Table 3. Views Used in Querying Database and Their Description

View

Description

ComputerAdministrators

Used for finding all accounts to be made members of the local Administrators group on the target computer. The view is a join of the ComputerIdentity and Settings_Administrators tables.

ComputerApplications

Used for finding all applications to be deployed to the target computer. The view is a join of the ComputerIdentity and Settings_Applications tables.

ComputerPackages

Used for finding all packages to be deployed to the target computer. The view is a join of the ComputerIdentity and Settings_Packages tables.

ComputerRoles

Used for finding all roles to be associated with the target computer. The view is a join of the ComputerIdentity and Settings_Roles tables.

ComputerSettings

Used for finding all property settings to be configured for the target computer. The view is a join of the ComputerIdentity and Settings tables.

LocationAdministrators

Used for finding all the accounts to be made a member of the local Administrators group on the target computers within a location. The view is a join of the LocationIdentity, LocationIdentity_DefaultGateway, and Settings_Administrators tables.

LocationApplications

Used for finding all the applications to be deployed to the target computers within a location. The view is a join of the LocationIdentity, LocationIdentity_DefaultGateway, and Settings_Applications tables.

LocationPackages

Used for finding all the packages to be deployed to the target computers within a location. The view is a join of the LocationIdentity, LocationIdentity_DefaultGateway, and Settings_Packages tables.

LocationRoles

Used for finding all the roles to be associated with the target computers within a location. The view is a join of the LocationIdentity, LocationIdentity_DefaultGateway, and Settings_Roles tables.

Locations

Used for finding the IP addresses for the default gateways within a location or for all the locations that contain a specified IP address for a default gateway. The view is a join of the LocationIdentity and LocationIdentity_DefaultGateway tables.

LocationSettings

Used for finding all the property settings to be configured for the target computers within a location. The view is a join of the LocationIdentity, LocationIdentity_DefaultGateway, and Settings tables.

MakeModelAdministrators

Used for finding all accounts to be made members of the local Administrators group on the target computers with a given make and model. The view is a join of the MakeModelIdentity and Settings_Administrators tables.

MakeModelApplications

Used for finding all applications to be deployed to the target computers with a given make and model. The view is a join of the MakeModelIdentity and Settings_Applications tables.

MakeModelPackages

Used for finding all packages to be deployed to the target computers with a given make and model. The view is a join of the MakeModelIdentity and Settings_Applications tables.

MakeModelRoles

Used for finding all roles associated with the target computers with a given make and model. The view is a join of the MakeModelIdentity and Settings_Roles tables.

MakeModeSettings

Used for finding all property settings to be configured for the target computers with a given make and model. The view is a join of the MakeModelIdentity and Settings tables.

RoleAdministrators

Used for finding all accounts to be made members of the local Administrators group on the target computers with a given role. The view is a join of the RoleIdentity and Settings_Administrators tables.

RoleApplications

Used for finding all applications to be deployed to the target computers with a given role. The view is a join of the RoleIdentity and Settings_Applicaitons tables.

RolePackages

Used for finding all packages to be deployed to the target computers with a given role. The view is a join of the RoleIdentity and Settings_Packages tables.

RoleSettings

Used for finding all property settings to be configured for the target computers with a given role. The view is a join of the RoleIdentity and Settings tables.

Download

Get the Microsoft Solution Accelerator for Business Desktop Deployment 2007

Update Notifications

Sign up to learn about updates and new releases

Feedback

Send us your comments or suggestions