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.