The DSM Explorer › Queries Folder › Create a New Query › Add Advanced Argument Dialog › Database Table: Discovered Software

Database Table: Discovered Software

The Discovered Software table, ca_discovered_software, stores the detected software information.

Note: Available categories and options may vary depending on the products and components installed.

This table contains the following columns:

ASSET_SOURCE_UUID

Includes the computer UUID in which the software is detected.

AUTO_REP_VERSION

Includes the automatic increment counter used by the replication engine for comparing the values before and after the update.

COVERED_BY_NF

Indicates whether software installation is covered by a non-finite license. Valid values are as follows: 1 = True and 0 or NULL = False.

CREATION_DATE

Includes the date when the software was detected.

CREATION_USER

Includes the URI of the user who created the detected software entry. In most of the cases, this is equal to ENGINE.

DEF_SOURCE_TYPE_ID

Includes the default source type ID for the source of the record (foreign key to ca_source_type).

DELETE_TIME

Includes the time when the detected software was deleted.

DIS_SOURCE_TYPE_ID

Includes the type ID of the discovery source.

DIS_SW_UUID

Includes the detected software UUID.

EXCLUDE_REGISTRATION

Indicates that the software is under the Common Object Registration API (CORA) maintenance.

INSTALL_PATH

Includes the Installation path of the detected software.

IS_IGNORED_BY_VULN_IMPACT

Indicates that the software must be ignored during the security vulnerability impact/risk assessment of the asset by eVM.

IS_MANAGED_BY_SERVICE

Indicates whether the software was reported by the agent or added by the user. Detected software managed by the inventory agent can be removed or updated by the agent. Similarly, those added by the user can be removed by the user only.

LABEL

Includes the name of the software installation. For example, if SQL Server is found on a computer, this field could contain the instance name of the installation, 'Engfran Ltd Sales'.

LAST_ACCESSED

Includes the last accessed date.

LAST_UPDATE_DATE

Includes the last updated date.

LAST_UPDATE_USER

Includes the user who has last updated the detected software.

LICENSE_BLOCK_ID

Includes the ID of the license block.

LICENSE_ID

Includes the license ID.

LICENSE_INSTANCE

Indicates the incremental order in which software installations are covered by a license.

Note: This column is currently unused.

LICENSE_UUID

Includes the license UUID.

ORIGIN

Identifies the source of the detected software.

PRODUCT_GUID

Includes the vendor installation product identifier.

SERIAL_NUMBER

Includes the attributes of the asset.

SW_DEF_UUID

Includes the software definition UUID.

TRUST_LEVEL

Indicates the trust level of the detected software.

VERSION_NUMBER

Includes the software version detected.