Tools & books: tools for SCCM and Intune, and two SCCM books

DeviceSonar

Intune tells you a lot about a device, but rarely everything you need. DeviceSonar collects the extra data you choose from Windows devices, from the registry, WMI or your own scripts, and turns it into reports.

• Collect values from the registry, WMI classes or scripts
• Fills gaps that Intune's built-in hardware inventory leaves
• Reporting designed for migrations, audits and troubleshooting

Intune HealthCheck Toolkit

The next version of the HealthCheck Toolkit, written in C#, and it brings health checks to Microsoft Intune.

• Written in C#
• Health checks for Microsoft Intune
• All public rules will be available in the GitHub repository
• Allow community to extend and fix bugs in the rules
• Over 250 categorised rules: account, application, compliance, conditional access, software updates, devices, and more
• Report in Word and/or PDF, with recommendations and possible fixes

SCCM HealthCheck Toolkit

First created in 2013 and rewritten in PowerShell, the SCCM HealthCheck Toolkit collects data from your Configuration Manager hierarchy, checks it against more than 400 rules and produces a report with recommendations and possible fixes.

• Over 400 categorised rules: sites and hierarchy, SQL Server, software updates, devices, discovery and more
• Three steps: CollectData.ps1, AnalyseData.ps1 and GenerateReport.ps1
• Report in Word or Excel, with recommendations and possible fixes

Intune Documentation Toolkit

ExportIntuneData.ps1 connects to Intune and Azure and writes the tenant's configuration to a document, so admins and consultants spend their time reviewing a design rather than copying settings into one.

• Word and HTML output
• Optional Microsoft Graph beta API
• Company name, website and email in the document header

Azure Documentation Toolkit

ExportAzureData.ps1 connects to Azure and documents what is there: compute, networking, storage, monitoring, backup, policy, Key Vault and, optionally, cost and metrics.

• Export everything or only what you need, for example virtual machines
• Include or exclude cost information and metrics
• Covers compute, network, storage, monitor, billing, Recovery Services, File Sync, policy, Logic Apps and Key Vault

Active Directory Documentation Toolkit

Two scripts: CollectADData.ps1 gathers Active Directory data into JSON files, and ExportADData.ps1 turns it into a report, so collection and documentation can run on different machines.

• Collect once to JSON, report many times
• Word and HTML output
• Flags dormant users and computers that haven't changed their password

SCCM SQL Queries & Scripts

The scripts and queries I use to manage and maintain Configuration Manager and related systems such as WSUS, published so you don't have to write them again.

• SQL queries for managing SCCM and related systems
• Hardware and software assessment queries for ConfigMgr
• PowerShell scripts for SCCM and WSUS maintenance

• ToolsPowerShell scripts for SCCM and WSUS, BSD-3-Clause
• SQLQuerySQL scripts for SCCM and related systems
• ConfigMgr SQL HW/SW AssessmentHardware and software assessment queries