Overview

This script is part 2 of a 2-part process for generating an audit report of a System Center Configuration Manager site environment. Get-CM-Inventory.ps1 is part 1. This script consumes the data exported from using Get-CM-Inventory.ps1 and creates a Microsoft Word document (report).

• Extract Export-CM-HealthCheck.ps1, messages.xml and cmhealthcheck.xml into a folder.
• Open a PowerShell console using "Run as administrator"
• Run the script (examples shown below)
• This script is based on the awesome work of Rafael Perez (rflsystems.co.uk)

Notes / Requirements

• Must be executed using an account which has FULL ADMINISTRATOR permissions to the SCCM hierarchy, the Windows Server host, and the SQL Server instance which supports the SCCM hierarchy.
• Requires PowerShell version 3 or later
• Works best when executed ON a Windows client running Windows 10 and Office 2013 or later
• Has been tested on Windows 7, 8.1 and 10 with Office 2013 and 2016 ProPlus and Office 365/2016

Syntax Examples

• Export-CM-HealthCheck.ps1 -ReportFolder ".\2017-05-23\cm01.contoso.com" -Detailed -CustomerName "Contoso" -AuthorName "Ben Franklin"
• Export-CM-HealthCheck.ps1 -ReportFolder ".\2017-05-23\cm01.contoso.com"
• Export-CM-HealthCheck.ps1 -ReportFolder ".\2017-04-03\abc1.fubar.com" -CustomerName "Fubar" -AuthorName "Sam Jackson" -CoverPage "Slice (Light)" -HealthcheckFilename "cmhealthcheck.xml" -HealthCheckDebug:$True -Overwrite

Change Log

Version 0.1 - Raphael Perez - 24/10/2013

• Initial Script

Version 0.2 - Raphael Perez - 05/11/2014

• Added Get-MessageInformation and Get-MessageSolution

Version 0.3 - Raphael Perez - 22/06/2015

• Added ReportSection

Version 0.4 - Raphael Perez - 04/02/2016

• Fixed issue when executing on a Windows 10 machine

Version 0.5 - David Stein (4/10/2017)

• Added support for MS Word 2016
• Changed "cm12R2healthCheck.xml" to "cmhealthcheck.xml"
• Detailed is now a [switch] not a [boolean]
• Added params for CoverPage, Author, CustomerName, etc.
• Bugfixes for Word document builtin properties updates
• Minor bugfixes throughout

Version 0.6 - David Stein (4/18/2017)

• Set table styles to be consistent

Version 0.6.1 - David Stein (4/23/2017)

• Added CmdletBinding() and some other additions

Version 0.6.2 - David Stein (5/16/2017)

• Minor formatting updates