The following table lists and describes the database views that are used when querying configuration information in the MDT DB.

 

View

Description

ComputerAdministrators

Used to find 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 to find all applications to be deployed to the target computer. The view is a join of the ComputerIdentity and Settings_Applications tables.

ComputerPackages

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

ComputerRoles

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

ComputerSettings

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

LocationAdministrators

Used to find 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 to find 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 to find 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 to find 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 to find 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 to find 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 to find 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 to find 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 to find 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 to find 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.

MakeModelSettings

Used to find 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 to find 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 to find all applications to be deployed to the target computers with a given role. The view is a join of the RoleIdentity and Settings_Applications tables.

RolePackages

Used to find 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 to find 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.

 


Related Topics

Tables and Views in the MDT DB