Application Management Views in Configuration Manager

 

Updated: April 1, 2014

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The Configuration Manager application management views can be used to query for information about applications, packages and programs, deployments, distribution points, and more. These views will most often be joined to other views by using the AdvertisementID, PackageID, or CollectionID columns. Many of the status views also provide information about the status for applications and deployments. For more information about Configuration Manager applications, see Application Management in Configuration Manager.

The following sections provide detailed information about application management views and application management status views.

Application Management Views

The application management views are described in the following table.

Application management View	Description
v_Advertisement	Lists information about the deployment of packages and programs, including the deployment ID (AdvertisementID), deployment name (AdvertisementName), package ID, program name, collection ID, schedule information, and more. The v_Advertisement view is similar to the v_AdvertisementInfo view, but with additional time and flag data. The view can be joined to other views by using the AdvertisementID, PackageID, and CollectionID columns.
v_AdvertisementInfo	Lists information about deployed packages and programs, including the deployment ID (AdvertisementID), deployment name (AdvertisementName), package ID, program name, collection ID, schedule information and more. The v_AdvertisementInfo view is similar to the v_Advertisement view, but with additional package data. The view can be joined to other views by using the AdvertisementID, PackageID, and CollectionID columns.
v_CurrentAdvertisementAssignments	Lists the current application deployments, by advertisement ID, and the resource ID that is assigned the advertisement. The view can be joined to other views by using the AdvertisementID or ResourceID columns.
v_DistributionPoint	Lists the distribution points and the application and software updates packages contained on each in the Configuration Manager site hierarchy. This view also provides the package ID, NAL path to the distribution point, site code, site name, source site, last refresh time, status, and more. The view can be joined to other views by using the PackageID and ServerNALPath columns.
v_DistributionPointInfo	Lists the distribution points in the Configuration Manager site hierarchy, including server name, share name, NAL path, site code, whether it is a branch distribution point, whether it is a pull distribution point and more. The view can be joined to other views by using the ServerName and NALPath columns.
V_MDMApplications	Lists information about applications created for mobile devices including the application name, description, publisher and more. It is unlikely that this view will be joined to other views.
v_OS_Details	Lists the Configuration Manager supported platforms, including operating system, architecture, and versions, on which each specified software distribution program can run. The view contains the package ID, program name, operating system name, platform, and minimum and maximum operating system versions. The view can be joined to other views by using the PackageID column.
v_SMSPackage	Lists the packages in the Configuration Manager site hierarchy, including package ID, package name, the path of the package source files, source site, priority, package flags, last refresh time, and so forth. All packages are listed, including software deployment packages, boot image packages, and more. The view can be joined to other views by using the PkgID column.
v_Program	Lists the programs for each package in the Configuration Manager site hierarchy, including program name, package ID, program command line, dependent programs, program flags, and so forth. The view can be joined to other views by using the PackageID column.
v_UserTargetedApps	Lists each Configuration Manager application that has been deployed to a user. Includes the application ID (CI_ID), the collection to which the application has been deployed (if any), and whether the application requires approval. This view can be joined to other views by using the CI_ID or CollectionID columns.
v_UserTargetedClassicApps	Lists each package and program that has been deployed to users. Includes the program ID, the category, the publisher, the package and program name and more. This view can be joined to other views by using the ProgramID, PackageID, or CollectionID columns.
v_DeploymentSummary	Lists all deployments that are currently active at the site. Includes the collection to which the deployment was targeted, the name of the deployment, the deployment time, deployment statistics and more. This view can be joined to other views by using the CollectionID or PackageID columns.
v_ApplicationModelInfo	Lists the applications, by CI_ID that have been created. Also lists the deployment type technology and any secured key for the application. This view can be joined to other views by using the CI_ID column.
v_AppModelTargetingDeploymentInfo
v_AppModelTargetingInfo
v_Package	Returns all packages that contain content for an application, package and program, or a task sequences at this site. This view can be joined to other views by using the PackageID column.
v_ClassicAppTargetingDeploymentInfo
v_ClassicAppTargetingInfo
v_ClassicDeploymentAssetDetails	Lists information and status for standard package and program deployments by deployment ID. This includes the program name, package name, collection to which it has been deployed, and more. This view can be joined to other views by using the DeploymentID, PackageID, CollectionID and DeviceID columns.
v_AppDeploymentSummary	Lists deployment statistics for about Configuration Manager applications that have been deployed to clients. This includes the CI_ID, target collection, localized display name, description and more. This view can be joined to other views by using the CI_ID, AssignmentID and TargetCollectionID columns.
v_AppDTDeploymentSummary	Lists information about deployment types that have been deployed to devices, by CI_ID. This includes the deployment type name, the target collection, and status information about the deployment. This view can be joined to other views by using the CI_ID, AssignmentID and TargetCollectionID columns.
v_AppDTLaunchSummary	Lists information, by AppCI, about deployment types that have run on client devices. This includes the assignment ID, the collection, the deployment type technology and more. This view can be joined to other views by using the AppCI column.
v_AppEvalErrors	Lists all devices, by machine ID where the application evaluation failed, for example, if the application failed any requirements rules. This view can be joined to other views by using the MachineID column.
v_AppInTaskSequenceDeployment	Lists, by task sequence name, all deployed task sequences that contain an application deployment. This includes the collection to which the task sequence was deployed and the deployment ID. This view can be joined to other views by using the Name column.
v_AppIntentAssetData	Lists for each computer (and each user if deployed to a user), compliance state information by AssignmentID and Application ID (AppCI). State information includes ComplianceState, EnforcementState, applicability, and desired compliance state. This view can be joined to other views by using the ID columns and to vAppStatSummary by using the AppCI column.
v_AppInTSDeployment	Lists, by name, all applications that are deployed by a task sequence. This view can be joined to other views by using the Name column.
v_ApplicationAssignment	Lists detailed information about Configuration Manager application deployments, by AssignmentID. This includes the name of the application, the collection to which it was deployed, the creation time and more. This view is particularly useful when you want to examine the status of your cmshort deployments. This view can be joined to other views by using the AssignmentID and CollectionID columns.
v_CatalogAppModelProperties
v_CatalogClassicAppProperties
v_UserAppRequests	Lists details about users requests for applications, sorted by CI_UniqueID. This includes the application ID, the name of the user requesting the application, the display name of the application and the device from which the request was made. This view can be joined to other views by using the CI_UniqueID, Unique_User_Name0 and Netbios_Name0 columns.
v_UserAppsLocalizedPropsForCatalog

Application Management Status Views

The application management status views contain status and status summary information about application deployments, applications and packages and programs. For more information about status views, see Status and Alert Views in Configuration Manager. The status views that contain application management information are described in the following table.

Application management view	Description
v_AdvertisementStatusInformation	Lists all advertisement status message IDs, the message state, and the message name, such as succeeded, expired, failed, and retrying. The view can be joined to other advertisement status views by using the MessageID column.
v_ClientAdvertisementStatus	Lists all package and program deployments with the associated status for resources that have been targeted. The view can be joined to other views by using the AdvertisementID, ResourceID, and LastStatusMessageID columns.
v_ClientOfferSummary	Lists the package and program deployments, by OfferID, the count of Configuration Manager client computers that have been targeted, and the count of computers reporting not started, waiting, running, retrying, failed, and succeeded status for the advertisement. The view can be joined to other views by using the OfferID column, which is the same as the AdvertisementID column in other views, and PkgID column, which is the same as the PackageID column in other views.
v_PackageStatus	Lists the status for all software distribution and software update deployment packages, as well as the package server location, last update time, last status and more. The view can be joined to other views by using the PackageID column.
v_PackageStatusDetailSumm	Lists all applications and packages and programs, by Package ID, the originating site code, package name, site name, source version, the date for the summary information, the targeted count for each package, and the count for installed, retrying, and failed status. The view can be joined to other views by using the PackageID column.
v_PackageStatusDistPointsSumm	Lists all packages, by package ID, and the installation status for the package source files on all associated distribution points. The view also provides information such as the site code, path to the distribution point, path to source location, time of last copy, and so on. The view can be joined to other views by using the PackageID and ServerNALPath columns.
v_PackageStatusRootSummarizer	Lists all applications and packages and programs, by package ID, the package name, source version, source date, the source site, size of the source files, the targeted count for each package, and the count for installed, retrying, and failed status. The view can be joined to other views by using the PackageID column.
v_PeerDPStatusInfo	Lists the peer distribution point states and associated state names. It is unlikely that this view will be joined to other views.
v_ProgramOffers	Lists all programs that have been deployed as part of a package and program. This is sorted by package ID and the program name. The view can be joined to other views by using the PkgID column.

User Device Affinity Views

The user device affinity views contain information about configured relationships between users and primary devices. The views that contain user device affinity information are described in the following table.

User device affinity view	Description
v_UsersPrimaryMachines	Lists, by user resource ID, the primary devices for that user. This view can be joined to other views by using the MachineID or UserResourceID columns.
v_UserMachineIntelligence	Lists information, by resource ID about user logons to devices. This information can be used by user device affinity to create automatic affinities. The information collected includes the user name, device name, client type, number of logons, and time spent for each session. This view can be joined to other views by using the MachineResourceID column.
v_UserMachineRelation	Lists detailed information about user device relationships in the Configuration Manager site including the relationship ID, the user name, the device ID, the creation time and more. This view can be joined to other views by using the MachineResourceID column.
v_UserMachineRelationship	Lists information about users and their primary devices in the site. Includes the user name, the device resource ID, the time the relationship was created, and more. This view can be joined to other views by using the UniqueUserName or MachineResourceID columns.
v_UserMachineSourceRelation	Lists all user device affinity relationships, by relationship resource ID, when they were created, and who created them. This view can be joined to other views by using the RelationshipResourceID column.
v_UserMachineTypeRelation	Lists user and device relationships by relationship resource ID, relationship type, and creation time. It is unlikely that this view will be joined to other views.

See Also

SQL Server Views in System Center 2012 Configuration Manager