MEM.Zone-Dashboards

Release version Release date Issues count Commits since release Chat on discord Follow on X

MEM.Zone Dashboards

This is a solution of dashboards and reports, for Microsoft Endpoint Configuration Manager.

Notes All sub-reports can be run standalone. The installation can be done manually or via the included PowerShell installer.

Main page

See main.

Latest release

See releases.

Changelog

See changelog.

Help

See help.

Credit

Dashboards and Reports

.
+-- (D) _Dashboard - Software Updates
    +-- (C) Device Update Compliance
    |   +-- (R) Software Update - Compliance by Collection
    |       +-- (R) Software Update - Compliance by Device
    |
    +-- (C) Missing updates by Classification
    |   +-- (R) Software Update - Compliance by Collection
    |       +-- (R) Software Update - Compliance by Device
    |
    +-- (C) Device Update Agent Scan States
    |   +-- (R) Software Update - Scan Status by Collection
    |
    +-- (C) Overall Update Groups Compliance
    |
    +-- (C) Top 5 Devices with Missing Updates by Classification
    |   +-- (R) Software Update - Compliance by Collection
    |       +-- (R) Software Update - Compliance by Device
    |
    +-- (T) Critical Alerts
    |   +-- (R) Site - Alerts
    |
    +-- (T) Last Successful Synchronization Time
        +-- (R) Software Update - Update Point Sync Status
+-- (R) Application - Compliance by Collection
+-- (R) Baseline - Compliance by Collection
+-- (R) Bitlocker - Compliance by Collection * Bitlocker (MBAM)
+-- (R) Bitlocker - Compliance by Collection * Bitlocker
+-- (R) Operating System - Version Compliance by Collection
+-- (R) Operating System - Windows 11 Readiness by Collection
+-- (R) Package - Compliance by Collection
+-- (R) Package - Compliance by Deployment
+-- (R) Software Update - CU Compliance by Collection

## Legend
'()'  - 'to' or 'from' navigation element
'(D)' - Dashboard
'(R)' - Report
'(C)' - Chart
'(T)' - Text

Preview (Not up-to-date)

This preview is not up-to-date, it represents version 2.0.0. A new preview will be available shortly.

Prerequisites

Discovery

Notes Run the user and device discovery after adding the l and co attributes.

Software

SQL User Defined Functions (UDF)

SQL SELECT Rights for smsschm_users (CM Reporting)

Notes You can find the code that automatically grants SELECT rights to the functions and tables above in the perm_CMDatabase.sql file.

Installation - Automatic

Use the provided PowerShell installer. You can find the standalone repository for the installer here.

## Get syntax help
Get-Help .\Install-SRSReport.ps1

## Typical installation example
#  With extensions
.\Install-SRSReport.ps1 -ReportServerUri 'http://CM-SQL-RS-01A/ReportServer' -ReportFolder '/ConfigMgr_XXX/SRSDashboards' -ServerInstance 'CM-SQL-RS-01A' -Database 'CM_XXX' -Overwrite -Verbose
#  Without extensions (Permissions will still be granted on prerequisite views and tables)
.\Install-SRSReport.ps1 -ReportServerUri 'http://CM-SQL-RS-01A/ReportServer' -ReportFolder '/ConfigMgr_XXX/SRSDashboards' -ServerInstance 'CM-SQL-RS-01A' -Database 'CM_XXX' -ExcludeExtensions -Verbose
#  Extensions only
.\Install-SRSReport.ps1 -ServerInstance 'CM-SQL-RS-01A' -Database 'CM_XXX' -ExtensionsOnly -Overwrite -Verbose

Notes If you don’t use Windows Authentication (you should!) in your SQL server you can use the -UseSQLAuthentication switch. PowerShell script needs to be run as administrator. If you have problems installing the SQL extensions run the script on the SQL server directly and specify the -ExtensionsOnly switch. If this still doesn’t work check out the Manual Installation Steps.

Installation - Manual

Upload reports to SSRS, update the datasource, grant the necessary permissions and optionally install the helper function.

Upload Reports to SSRS

Notes Reports must be placed in the same folder on the report server.

Configure Imported Report

Create the SQL Helper Function

The ufn_CM_GetNextMaintenanceWindow is needed in order to display the next maintenance window.

Notes You need to have access to add the function and grant SELECT on ufn_CM_GetNextMaintenanceWindow, fnListAlerts, vSMS_ServiceWindow and vSMS_SUPSyncStatus for the smsschm_users (ConfigMgr reporting). If the ufn_CM_GetNextMaintenanceWindow is not present you will get a ‘Missing helper function!’ instead of the next maintenance window. To resolve the error codes, or get more info, just hover over the table cell.

Build

This repository includes a build script that automates the process of preparing the dashboards and reports for distribution

Build Prerequisites

Instructions

Build Script

This uses the default Build-Config.json configuration file and creates a versioned zip file in the output/ directory.

.\Build-Script.ps1

## Build with Custom Version override
.\Build-Script.ps1 -Version '6.2.0'

Build Process

Build Output

This site is open source. Improve this page.