This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build this I’ll use SQL Server with simple PowerShell script and cmdlets which generate JSON data and displays results in HTML

Article highlights

• Defines the objective of JSON
• Explains the PoSH JSON cmdlets internals and other details on its usage
• Proactive Monitoring of Service(s) over multiple servers – Covers fundamentals of how to Monitor SQL service(s). This sample code can be implemented to monitor any services on a Windows environment
• Automated Process – Easy to implement If you don’t have a monitoring tool
• Easier customization of services list and input servers list
• Seamless Integration of PowerShell and SQL using SQL 2016 JSON constructs
• HTML Report – shows how to do effective reporting using XML parsing and Database Mail
• Summary of data