The Configuration Manager report views contain information about the reports and dashboards in a site, such as report names, report IDs, dashboard ID, which reports are part of a dashboard, which column to use when navigating to linked reports, the SQL statement for the report, and so forth. Most often these views will be joined to other report views by using the ReportID column and possibly to other views by using the SecurityKey column. The report views are described in the following table.

Report View Description

v_Report

Lists all reports in the Configuration Manager hierarchy by report ID, security key, report name, report description, report category, SQL query, and so forth.

The view can be joined to other views by using the ReportID or SecurityKey columns.

v_ReportCategory

Lists the report categories and object key for the category.

It is unlikely that this view will be joined to other views.

v_ReportDashboard

Lists all reporting dashboards in the Configuration Manager hierarchy by dashboard ID, dashboard name, column count, and the vertical limit for each row.

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

v_ReportDashboardReports

Lists all reporting dashboards in the Configuration Manager hierarchy and associated reports by dashboard ID and report ID.

The view can be joined to other views by using the DashboardID or ReportID columns.

v_ReportDrillThroughColumns

Lists all reports in the Configuration Manager hierarchy by report ID and the column that will be used when drilling down into a linked report.

This view can be joined to other views by using the ReportID column.

v_ReportParameter

Lists all reports in the Configuration Manager hierarchy and associated prompt information including variable name, prompt text, whether the prompt can be empty, what the default variable value is, and the prompt SQL statement, when applicable.

This view can be joined to other views by using the ReportID column.

See Also