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