Discovery Dictionary entries for Microsoft SQL Discovery

Discovery writes information to the Microsoft SQL Instance table.

Dictionary entries

Discovery writes the following information to the MSFT SQL instance [ cmdb_ci_db_mssql_instance] table.

Table 1. Dictionary entries
Label Field name
Name Name
Instance instance_name
TCP port tcp_port
Portdynamic port_dynamic
Version name version_name
Edition edition
Version version
Engine edition engine_edition

For SQL2000 servers, Discovery can match instance names to their process ID.

The following data is collected in the MSFT SQL Catalog [cmdb_ci_db_mssql_catalog] table:

Label Field name
Name name
Status status