The Database tab displays the database instances successfully identified during discovery. The tab groups discovered database devices by technology, allowing you to view the number of discovered instances for each supported database type and access the corresponding device records.
Database discovered devices include the following:
Select a database technology to view its discovered instances. The discovered-device list provides information such as the hostname or instance name, instance ID, IP address or endpoint, database engine, device type, discovery method, mapping status, mapped asset, and discovery status.
SQL Server
The SQL Server discovered-device details provide the properties collected from a discovered SQL Server instance during a deep scan. Discovery organizes the collected properties into the following categories:
The properties displayed under each category can vary based on the SQL Server version, configuration, discovery access permissions, and the information available on the discovered instance.
Identity
The Identity category provides the primary identification and connection details of the discovered SQL Server instance. These properties identify the database technology, vendor, product, version, edition, and instance.
The category also provides the endpoint, port, and network protocol used to connect to the SQL Server service. These details help distinguish the discovered instance from other database instances in the environment.
Field | Description | Example |
|---|---|---|
Technology | The database technology identified during discovery. | SQL Server |
Vendor | The organization that develops or distributes the database technology. | Microsoft Corporation |
Product | The name of the discovered database product. | Microsoft SQL Server |
Version | The version of the database software running on the discovered instance. | 16.0.1000.6 |
Edition | The edition of the discovered SQL Server product. The edition indicates the licensing or feature variant of the database software. | Enterprise Edition |
Build | The build number or build identifier of the SQL Server software. | 16.0.1000.6 |
Instance | The name assigned to the discovered SQL Server instance. The instance name distinguishes the database instance from other instances running on the same host or in the same environment. | MSSQLSERVER |
Endpoint | The hostname or IP address and port used to connect to the SQL Server service. | 1xx.1xx.xxx.1xx:1433 |
Port | The network port on which the SQL Server service listens for incoming database connections. | 1433 |
Protocol | The network transport protocol used to communicate with the SQL Server service. | TCP |
Inventory
The Inventory category provides information about the databases or containers available within the discovered SQL Server instance and the users or roles configured for database access. These details help identify the database resources hosted by the instance and review the accounts and roles associated with the database environment.
Field | Description | Example |
|---|---|---|
Databases / containers | Displays the databases or containers identified within the discovered database instance. Select the field to view the collected database or container details. | 4 items |
Users / Roles | Indicates whether discovery collected information about the users and roles configured in the database instance. Select the field to view the collected user and role details. | Collected |
Storage
The Storage category provides information about the directories used to store the SQL Server data and log files. The category also provides the total size of the databases hosted by the discovered instance and information about available database backups.
Field | Description | Example |
|---|---|---|
Data directory | The directory where SQL Server stores its data files. | C:\Program Files\Microsoft SQL |
Log directory | The directory where SQL Server stores its transaction log files. | C:\Program Files\Microsoft SQL |
Total size | The combined size of the databases identified on the discovered SQL Server instance. | 117243904 |
Backup timestamps | Indicates whether discovery collected backup timestamp information. Use the details to review available backup records and their corresponding dates and times. | Collected |
Security & Auth
The Security & Auth category provides information about the authentication method and language-related configuration of the discovered SQL Server instance. These details help identify how users connect to the instance and how SQL Server stores, compares, and sorts character data.
Field | Description | Example |
|---|---|---|
Auth mode | The authentication mode configured for the SQL Server instance. The mode determines whether the instance accepts Windows accounts, SQL Server accounts, or both. | Mixed Mode (SQL + Windows) |
Character set | The character-encoding configuration of the database instance. Discovery displays Not applicable when the database technology uses collation rather than a separately configurable character set. | Not applicable |
Collation | The collation configured for the SQL Server instance. The collation defines the rules used to store, compare, and sort character data, including case and accent sensitivity. | SQL_Latin1_General_CP1_CI_AS |
HA / Replication
The HA / Replication category provides information about the high-availability and replication configuration of the discovered SQL Server instance. These details help determine whether the instance operates independently or participates in a replicated, clustered, or Always On availability environment.
Field | Description | Example |
|---|---|---|
Replication role | The role of the discovered SQL Server instance in a replication or high-availability configuration. A standalone role indicates that the instance is not part of a configured replication or high-availability arrangement. | standalone |
Replication peer | The peer SQL Server instance associated with the discovered instance for replication, when configured. | Not configured |
Cluster | The cluster associated with the SQL Server instance, when the instance participates in a clustered environment. | Not configured |
Always On / AG | The Always On availability group associated with the SQL Server instance, when configured. | Not configured |
Vendor HA detail | Additional vendor-specific information about the high-availability configuration of the SQL Server instance. | Not configured |
Jobs & Runtime
The Jobs & Runtime category provides information about the operational state and runtime activity of the discovered SQL Server instance. The category includes the SQL Server Agent status, configured agent jobs, current database connections, instance uptime, and available CPU count.
Field | Description | Example |
|---|---|---|
SQL Agent status | The current operating status of the SQL Server Agent service. SQL Server Agent runs scheduled administrative tasks and jobs. | Running |
Agent jobs | The number of SQL Server Agent jobs identified on the discovered instance. | 5 items |
Event scheduler | The status of the database event scheduler. Discovery displays Not applicable because the event scheduler does not apply to SQL Server. | Not applicable |
Scheduled events | The scheduled database events identified on the discovered instance. Discovery displays Not applicable because scheduled events do not apply to SQL Server. | Not applicable |
Active connections | The number of active connections to the SQL Server instance at the time of discovery. | 29 |
Max connections | The maximum number of connections supported or configured for the SQL Server instance. | Max connections not returned |
Uptime | The length of time the SQL Server instance has been running. The displayed value uses the unit returned during discovery. | 1675741 |
CPU count | The number of logical processors available to the SQL Server instance. | 16 |
Configuration
The Configuration category provides the configuration parameters collected from the discovered SQL Server instance. These parameters help review the settings that control the behavior and operation of the database instance.
Field | Description | Example |
|---|---|---|
Config parameters | The configuration parameters collected from the SQL Server instance. Select the field to view the names, configured values, and related details of the collected parameters. | [object Object] |
MySQL
The MySQL discovered-device details provide the properties collected from a discovered MySQL instance during a deep scan. The collected information helps identify the MySQL installation, review the databases and users available on the instance, examine storage and security settings, and monitor replication and runtime details.
Discovery organizes the collected properties into the following categories:
The properties displayed under each category can vary based on the MySQL version, edition, configuration, access permissions, and information returned by the discovered instance.
Identity
The Identity category provides the primary identification and connection details of the discovered MySQL instance. The collected properties identify the database technology, vendor, product, version, edition, and instance name.
The category also provides the endpoint, port, and network protocol used to connect to the MySQL service. These details help distinguish the discovered instance from other database instances in the environment.
Field | Description | Example |
|---|---|---|
Technology | The database technology identified during discovery. | MySQL |
Vendor | The organization that develops or distributes the discovered database technology. | Oracle Corporation |
Product | The name of the discovered database product. | MySQL |
Version | The version of the MySQL software running on the discovered instance. | 8.0.46 |
Edition | The edition or distribution of the discovered MySQL product. The edition can show the licensing model or feature variant of the database software. | MySQL Community Server - GPL |
Build | The build number or build identifier of the MySQL software, when applicable. Discovery displays Not applicable when build information does not apply to the discovered product. | Not applicable |
Instance | The name assigned to the discovered MySQL instance. The instance name helps distinguish the database instance from other instances in the environment. | DevAutomation |
Endpoint | The network address used to connect to the MySQL service. The endpoint includes the IP address or hostname and the service port. | 1xx.xxx.xx.xx:3306 |
Port | The network port on which the MySQL service listens for incoming database connections. | 3306 |
Protocol | The network transport protocol used to communicate with the MySQL service. | TCP |
Inventory
The Inventory category provides information about the databases and user accounts available on the discovered MySQL instance. These details help identify the databases hosted by the instance and review the users and roles configured for database access.
Field | Description | Example |
|---|---|---|
Databases / containers | The databases or containers identified within the discovered MySQL instance. If the discovery process cannot retrieve the database list, the field displays a corresponding message. | Database list not returned |
Users / Roles | The number of users and roles identified on the discovered MySQL instance. Select the field to view the collected user and role details. | 5 items |
Storage
The Storage category provides information about the directories and storage used by the discovered MySQL instance. The category identifies the directory where MySQL stores data files, the directory used for log files, the total database size, and backup timestamp information.
Field | Description | Example |
|---|---|---|
Data directory | The directory where MySQL stores its database files. | C:\ProgramData\MySQL\MySQL Server 8.0\Da |
Log directory | The directory where MySQL stores its log files. If discovery cannot retrieve the directory, the field displays a corresponding message. | Log directory not returned |
Total size | The combined size of the databases identified on the discovered MySQL instance. If discovery cannot calculate the size, the field displays a corresponding message. | Total size not calculated |
Backup timestamps | The date and time information associated with available database backups. Discovery displays Not applicable when backup timestamp collection does not apply to the discovered MySQL instance. | Not applicable |
Security & Auth
The Security & Auth category provides information about the character encoding and collation settings configured for the discovered MySQL instance. These settings determine how the MySQL instance stores, compares, and sorts character data.
Field | Description | Example |
|---|---|---|
Auth mode | The authentication mode configured for the MySQL instance. Discovery displays Not applicable when a single instance-level authentication mode is unavailable for the discovered MySQL instance. | Not applicable |
Character set | The default character set configured for the MySQL instance. The character set determines how the MySQL instance encodes and stores character data. | utf8mb4 |
Collation | The default collation configured for the MySQL instance. The collation defines how the MySQL instance compares and sorts character data, including case and accent sensitivity. | utf8mb4_0900_ai_ci |
HA / Replication
The HA / Replication category provides information about the replication and high-availability configuration of the discovered MySQL instance. These details help identify the role of the instance and determine whether it uses a replication peer, belongs to a cluster, or participates in a vendor-specific high-availability configuration.
Field | Description | Example |
|---|---|---|
Replication role | The role of the MySQL instance in the replication configuration. A primary instance serves as the source from which replica instances receive database changes. | primary |
Replication peer | The peer MySQL instance associated with the discovered instance for replication. If discovery cannot retrieve the peer information, the field displays a corresponding message. | Replication peer not returned |
Cluster | The MySQL cluster associated with the discovered instance. If discovery cannot retrieve the cluster information, the field displays a corresponding message. | Cluster not returned |
Always On / AG | The Always On availability group associated with the database instance. Discovery displays Not applicable because Always On availability groups are specific to SQL Server and do not apply to MySQL. | Not applicable |
Vendor HA detail | Additional MySQL-specific information about the high-availability configuration. If discovery cannot retrieve the information, the field displays a corresponding message. | HA detail not returned |
Jobs & Runtime
The Jobs & Runtime category provides information about the current activity and operational state of the discovered MySQL instance. The category includes the number of active and maximum connections and the length of time the MySQL instance has been running. It also indicates whether job scheduling and processor information apply to the discovered instance.
Field | Description | Example |
|---|---|---|
SQL Agent status | The operating status of the SQL Server Agent service. Discovery displays Not applicable because SQL Server Agent is specific to SQL Server and does not apply to MySQL. | Not applicable |
Agent jobs | The SQL Server Agent jobs identified on the database instance. Discovery displays Not applicable because SQL Server Agent jobs do not apply to MySQL. | Not applicable |
Event scheduler | The operating status of the MySQL Event Scheduler, which runs scheduled database tasks. Discovery displays Not applicable when Event Scheduler information does not apply to the discovered instance. | Not applicable |
Scheduled events | The scheduled events identified on the MySQL instance. Discovery displays Not applicable when scheduled-event information does not apply to the discovered instance. | Not applicable |
Active connections | The number of connections that were active on the MySQL instance at the time of discovery. | 2 |
Max connections | The maximum number of simultaneous client connections permitted for the MySQL instance. | 151 |
Uptime | The length of time the MySQL instance has been running. The displayed value uses the unit returned during discovery. | 691857 |
CPU count | The number of processors available to the MySQL instance. Discovery displays Not applicable when processor information does not apply to the discovered instance. | Not applicable |
Configuration
The Configuration category provides the configuration parameters collected from the discovered MySQL instance. These parameters help review the settings that control the behavior and operation of the MySQL database.
Field | Description | Example |
|---|---|---|
Config parameters | The configuration parameters collected from the MySQL instance. Select the field to view the names, configured values, and related details of the collected parameters. | [object Object] |
PostgreSQL
The PostgreSQL discovered-device details provide the properties collected from a discovered PostgreSQL instance during a deep scan. The collected information helps identify the PostgreSQL installation, review the databases and users available on the instance, examine storage and security settings, and monitor replication, runtime, and configuration details.
The following categories organize the collected properties:
The properties displayed under each category can vary based on the PostgreSQL version, configuration, access permissions, and information returned by the discovered instance.
Identity
The Identity category provides the primary identification and connection details of the discovered PostgreSQL instance. The collected properties identify the database technology, vendor, product, version, edition, build, and instance name.
The category also provides the endpoint, port, and network protocol used to connect to the PostgreSQL service. These details help distinguish the discovered instance from other database instances in the environment.
Field | Description | Example |
|---|---|---|
Technology | The database technology identified during discovery. | PostgreSQL |
Vendor | The organization or development group that maintains and distributes the discovered database technology. | PostgreSQL Global Development Group |
Product | The name of the discovered database product. | PostgreSQL |
Version | The version of the PostgreSQL software running on the discovered instance. | 17.11 |
Edition | The edition or distribution of the discovered PostgreSQL product, when available. If discovery cannot retrieve the edition, the field displays a corresponding message. | Edition not returned |
Build | The build number or build identifier of the PostgreSQL software, when available. If discovery cannot retrieve the build number, the field displays a corresponding message. | Build number not returned |
Instance | The name assigned to the discovered PostgreSQL instance. The instance name helps distinguish the database instance from other instances in the environment. | PostgreSQL |
Endpoint | The network address used to connect to the PostgreSQL service. The endpoint includes the IP address or hostname and the service port. | 1xx.1xx.xx.xx:5432 |
Port | The network port on which the PostgreSQL service listens for incoming database connections. | 5432 |
Protocol | The network transport protocol used to communicate with the PostgreSQL service. | TCP |
Inventory
The Inventory category provides information about the databases and user accounts available on the discovered PostgreSQL instance. These details help identify the databases hosted by the instance and review the users and roles configured for database access.
Field | Description | Example |
|---|---|---|
Databases / containers | The number of databases or containers identified within the discovered PostgreSQL instance. Select the field to view the collected database or container details. | 1 item |
Users / Roles | The number of users and roles identified on the discovered PostgreSQL instance. Select the field to view the collected user and role details. | 1 item |
Storage
The Storage category provides information about the directories and storage associated with the discovered PostgreSQL instance. The category identifies the directories used to store database data and log files. The category also provides the total database size and the most recent backup information, when available.
Field | Description | Example |
|---|---|---|
Data directory | The directory that contains the PostgreSQL database files. | C:/Program Files/PostgreSQL/17/data |
Log directory | The directory that contains PostgreSQL log files. The value can be a directory relative to the PostgreSQL data directory. | log |
Total size | The combined size of the databases identified on the discovered PostgreSQL instance. If discovery cannot calculate the size, the field displays a corresponding message. | Total size not calculated |
Backup timestamps | The date and time of the most recent backup identified for the databases. If no backup timestamp is available, the field displays a corresponding message. | No last_backup on databases |
Security & Auth
The Security & Auth category provides information about the authentication and language settings of the discovered PostgreSQL instance. The character set determines how PostgreSQL encodes and stores character data, while the collation defines the locale-specific rules used to compare and sort character data.
Field | Description | Example |
|---|---|---|
Auth mode | The authentication mode used by the PostgreSQL instance. If discovery cannot retrieve the authentication mode, the field displays a corresponding message. | Auth mode not returned |
Character set | The character encoding configured for the PostgreSQL instance. The character encoding determines how PostgreSQL represents and stores character data. | UTF8 |
Collation | The collation configured for the PostgreSQL instance. The collation defines the language and locale rules used to compare and sort character data. | English_United States.1252 |
HA / Replication
The HA / Replication category provides information about the replication and high-availability configuration of the discovered PostgreSQL instance. These details help identify the role of the instance and determine whether the instance has a replication peer, belongs to a cluster or availability group, or uses a PostgreSQL-specific replication configuration.
Field | Description | Example |
|---|---|---|
Replication role | The role of the PostgreSQL instance in the replication configuration. A standalone role indicates that the instance is not currently identified as part of a replication configuration. | standalone |
Replication peer | The peer PostgreSQL instance associated with the discovered instance for replication. If discovery cannot identify the peer, the field displays a corresponding message. | Replication peer not returned |
Cluster | The database cluster associated with the discovered PostgreSQL instance. If discovery cannot identify the cluster name, the field displays a corresponding message. | Cluster name not returned |
Always On / AG | The Always On availability group associated with the database instance. This field does not generally apply to PostgreSQL because Always On availability groups are specific to SQL Server. | Always On / AG not applicable or not returned |
Vendor HA detail | PostgreSQL-specific high-availability and replication details, such as replication slots, replication peers, or replica-set members. If discovery finds no details, the field displays a corresponding message. | No replication slots / peers / replica-set members |
Jobs & Runtime
The Jobs & Runtime category provides information about the current activity and operational state of the discovered PostgreSQL instance. The category includes the number of active connections, the maximum number of permitted connections, the instance uptime, and the available CPU count. It also indicates whether SQL Server Agent-related information applies to the PostgreSQL instance.
Field Descriptions
Field | Description | Example |
|---|---|---|
SQL Agent status | The operating status of SQL Server Agent. SQL Server Agent is specific to SQL Server and does not apply to PostgreSQL. If the status is not applicable or discovery cannot retrieve it, the field displays a corresponding message. | SQL Agent not applicable or not returned |
Agent jobs | The SQL Server Agent jobs identified on the database instance. SQL Server Agent jobs do not apply to PostgreSQL. | SQL Agent jobs not returned |
Active connections | The number of connections that were active on the PostgreSQL instance at the time of discovery. | 1 |
Max connections | The maximum number of simultaneous connections permitted for the PostgreSQL instance. | 100 |
Uptime | The length of time the PostgreSQL instance has been running. The displayed value uses the unit returned during discovery. | 340893 |
CPU count | The number of processors available to the PostgreSQL instance. If discovery cannot retrieve the processor count, the field displays a corresponding message. | Instance CPU count not returned |
Configuration
The Configuration category provides the configuration parameters and PostgreSQL-specific extensions collected from the discovered PostgreSQL instance. These details help review the settings that control the operation of the instance and identify the extensions installed to provide database capabilities.
Field | Description | Example |
|---|---|---|
Config parameters | The configuration parameters collected from the PostgreSQL instance. Select the field to view the parameter names, configured values, and related details. | [object Object] |
Vendor extensions | The PostgreSQL-specific extensions identified on the discovered instance. Select the field to view the collected extension names and related details. | [object Object] |