This script will create one HTML file and send over E-Mail as an attachment. The HTML file contains below details,
• New User DB creation report – Weekly
• Database backup report – Monthly
• Disk space report – Monthly
• Sysadmin access report – Monthly
• DBMS availability – Monthly
• DBMS memory – Monthly
• Database size report – Monthly
• DBMS version – Monthly
• Maximum number of concurrent sessions – Monthly
• OS Specific
The single glance of the SQL Server health check. It includes more then ten types os status with well formatted HTML file. Easy graphical interface catchy and handy information for all servers mentioned in Server List.
Windows OS - Powershell
SqlServer Module need to be installed if not than type below command in powershell prompt.
Install-Module -Name SqlServer
SqlServer Module need to be installed if not than type below command in powershell prompt.
Install-Module -Name SqlServer
Open Powershell "C:\DBA_HealthCheck.ps1"
Server List - txt file with the name of the machines/servers which to examine.
Please set varibles like server list path, output file path, E-Mail id and password as and when guided by comment through code.
As per [Report.html] file.
Few Screenshots provided below.
Copyright 2020 Harsh & Sahista
- [Harsh Parecha] (https://github.com/TheLastJediCoder)
- [Sahista Patel] (https://github.com/Sahista-Patel)
We love contributions, please comment to contribute!
Contributors have adopted the Covenant as its Code of Conduct. Please understand copyright and what actions will not be abided.