This script answers the following questions about your SQL Servers.
- What is the uptime of each SQL Server?
- What is the status of each database?
- What is the status of each Availability Group?
- What is the backup status of each database?
- What is the available disk space?
- Are there any SQL Agent failed jobs in the last 24 hours?
- What errors appeared in the SQL errorlog in the last 24 hours?
For a full description of how this script works, read the article here. https://blogs.msdn.microsoft.com/samlester/2017/12/29/sql-server-dba-morning-health-checks/