Database

Prev Next

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]