SQL Server Surveyor is a tool which allows database administrators to easily create reports of their SQL Servers for the purposes of documentation, auditing, comparison with other servers, etc. This tool does not make any changes or updates to the server or its databases. It simply queries various aspects of the SQL server and presents this information in an accessible form.
Features:
- Version of SQL Server and operating system
- Licensing
- Collation
- Uptime
- Network configuration
- Disk information
- SQL Server statistics
- Linked servers
- Operators and Alerts
- SQL Jobs (Job history, failures and long running jobs)
- Maintenance Plans
- Database information (not schema)
- Database Replication
- Fixed database roles
- Login and access level to databases
- Windows Scheduled Tasks