v_Advertisement

Lists information about the advertisements at the site, including the advertisement ID, advertisement name, package ID, program name, collection ID, advertisement flags, and so forth. 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 the advertisements at the site, including the advertisement ID, advertisement name, package ID, program name, collection ID, advertisement flags, and so forth. 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 advertisements, 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 for the software distribution and software updates packages in the Configuration Manager site hierarchy and provides the package ID, NAL path to the distribution point, site code, site name, source site, last refresh time, status, and so forth.

The view can be joined to other views by using the PackageID and ServerNALPath columns.

v_DistributionPointGroup

Lists the distribution point group name and NAL path of the distribution point.

The view can be joined to other views by using the NALPath column.

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, and so forth.

The view can be joined to other views by using the ServerName and NALPath columns.

v_OS_Details

Lists the Configuration Manager supported platforms, including operating system, architecture, and versions, on which the 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_Package

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 distribution packages, deployment packages, boot image packages, and so on.

The view can be joined to other views by using the PackageID column.

v_Program

Lists the programs for the packages 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_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_AdvertisementStatusRootSumm

Lists summary status for advertisement information, including the advertisement ID and advertisement status summarizer data, as well as package, program, and collection information.

The view can be joined to other views by using the AdvertisementID, PackageID, and CollectionID columns.

v_AdvertisementStatusSummarize

Lists summary status for advertisement information, including the advertisement ID, site code, and advertisement status summary data.

The view can be joined to other views by using the AdvertisementID column.

v_ClientAdvertisementStatus

Lists all advertisements with the associated status for system 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 software distribution advertisements, 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_ClientUpdateAdvertisementStatus

Lists all client update advertisements, by advertisement ID, and the status for system resources that have been targeted by the advertisement.

The view can be joined to other views by using the AdvertisementID, ResourceID, and LastStatusMessageID columns.

v_PackageStatus

Lists the status for all software distribution and software update deployment packages, as well as the package server location, last update time, and so on.

The view can be joined to other views by using the PackageID column.

v_PackageStatusDetailSumm

Lists all packages, by PackageID, 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_PackageStatusDistPointSumm

Lists all packages, by PackageID, 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 packages, by PackageID, 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.