Skip to main content

0-SQL_InstanceDiscovery Job

The 0-SQL_InstanceDiscovery job enumerates and stores the list of SQL Server Instances running on the targeted servers.

Queries for the 0-SQL_InstanceDiscovery Job​

The 0-SQL_InstanceDiscovery job uses the SQL Data Collector for the following query:

Query Selection

  • SQL Server Instance Discovery — Collects the list of SQL Server Instances from target endpoints and populates the necessary instance connection information

Analysis Tasks for the 0-SQL_InstanceDiscovery Job​

Navigate to the Databases > 0.Collection > SQL > 0-SQL_InstanceDiscovery > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection

The default analysis tasks is:

  • SQL Instances — Brings SA_SQL_Instances table to view