SQL Instances
The SQL Instance agent is able to document both Microsoft SQL Server on-premises installations and Microsoft Azure SQL databases1.
The data located by these tasks includes the following information types:
- Always On High Availability
- Databases
- Assemblies
- Database Options
- Files and Filegroups
- Stored Procedures
- Tables
- Table Columns
- Table Foreign Keys
- Triggers
- User Defined Functions
- Host Information
- Management Settings
- Database Mail Accounts
- Resource Governor Settings
- Security Settings
- Credentials
- Cryptographic Providers
- Logins
- Server Roles
- Server Objects
- Backup Devices
- Endpoints
- Server Properties
- SQL Server Agent
- Alerts
- Jobs
- Operators
- Proxies
1 Some information is only available for Microsoft SQL Server on-premises installations.