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. |