skatterbrainz/cm_healthcheck

Scripts for auditing and reporting a Configuration Manager site environment

cm_healthcheck's Issues

Extend Audit Scope to 1702 and 1703

Add inventory collection support for newer roles and features included with SCCM 1702 and 1703.

Enhancement - Custom Word Templates

Add an option to specify a custom Word document template

Enhancement - Pull DP Indication

Collect and report details to show if a DP is a pull configuratoin

Change Versioning Method to Align with SCCM

Rather than 0.xx, change to using YYMM and maybe a minor "dot" version as well, like 1707.01 if needed. Otherwise, just 1707 would be nice.

Add control over numeric precision on reports

The Database status reports show a lot of values, such as fragmentation, disk space, etc, as xx.xxxxxxxx (8) when they should be rounded to (2) decimals of precision. Not sure where this would be easiest/best to apply: in the Collection process or the Export process.

Add Custom Word Cover Page options

Add options to import a custom Word cover page during report creation

XML / SQL statement fails to produce output

During the processing of Get-CM-Inventory.ps1 using -Verbose, an error occurs...

SQL Query: select distinct stat.Component, stat.MessageID, stat.MessageID as Value from vStatusMessages AS stat where stat.Severity in (-1073741824, -2147483648) and stat.Component not in ('Advanced Client', 'Windows Installer SourceList Update Agent', 'Desired Configuration Management', 'Software Updates Scan Agent', 'File Collection Agent', 'Hardware Inventory Agent', 'Software Distribution', 'Software Inventory Agent') and stat.Time >= DATEADD(dd,-convert(int,7),GetDate()
)
SQL Query returned 18 records
ERROR/EXCEPTION: The following error occurred (continue).
Error 0x : Exception setting "Value": "Unable to cast object of type
System.Management.Automation.PSObject' to type 'System.IConvertible'.Couldn't store <5353> in Value Column. Expected type is Int32." connecting to Unable to update file: C:\users\sccmadmin\Desktop\hc\2017-07-27\cm01.contoso.com\ComponentErrorsSolution.xml
ComponentErrorsSolution Information...Done
Section... 6
Table..... SoftwareUpdateScanErrorsSolution - Information...Starting
Type...... sql

This causes the intended output to skip being written to file, and therefore doesn't appear in the exported MS Word report.

cmhealthcheck.xml has bugs

Multiple issues:

1. Look for "erors" and replace with "errors"
2. The SQL query for "SoftwareUpdateDeploymentErrorsSolution" at line 2352 throws a conversion error. The statement needs more testing.

Add Revision History Table

In the Export-CM-HealthCheck.ps1 script, add some code to insert a "Revision History" table with the first row (version 1.0) filled-in.

Provide a GUI form for each script

Provide a GUI for the collection script (get-cm-inventory.ps1) and another for the export script (export-cm-healthcheck.ps1)