Challenge
To ensure early detection of infrastructure issues, I developed a suite of health check scripts that automatically monitor Active Directory, Entra Connect, and SCCM. These scripts send daily email reports and log alerts to proactively surface replication failures, sync delays, and site status anomalies. To protect the company information the scripts won't be shared.
Tools & Technologies
- PowerShell (AD & Entra Connect Health Checks)
- SQL Server Management Studio (SCCM Site Status Job)
- Task Scheduler & SQL Agent
- SMTP Email Integration
- HTML-formatted Reporting
Implementation
- Created PowerShell script to query AD health: replication, FSMO roles, GPO shares, DNS, DHCP
- Logged warnings and sent daily email reports before shift start
- Alerted on any detected issues with elevated visibility
- Built PowerShell script for Entra Connect sync health: user sync, password sync, last sync time, duration
- Created SQL script inside SSMS to query SCCM site status and send HTML-formatted summary
- Scheduled all scripts via Task Scheduler and SQL Agent for automated delivery
Architecture Diagram
Impact
- Enabled proactive detection of infrastructure issues before user impact
- Reduced troubleshooting time through daily visibility and alerting
- Improved operational confidence across AD, Entra Connect, and SCCM
- Delivered polished HTML reports for executive and technical review