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