skatterbrainz / cm_healthcheck Goto Github PK
View Code? Open in Web Editor NEWScripts for auditing and reporting a Configuration Manager site environment
License: GNU General Public License v3.0
Scripts for auditing and reporting a Configuration Manager site environment
License: GNU General Public License v3.0
Add inventory collection support for newer roles and features included with SCCM 1702 and 1703.
Add an option to specify a custom Word document template
Collect and report details to show if a DP is a pull configuratoin
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.
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 options to import a custom Word cover page during report creation
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.
Multiple issues:
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 for the collection script (get-cm-inventory.ps1) and another for the export script (export-cm-healthcheck.ps1)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.