Contains a list of discovered software installations found by UAM. UAPM License Compliance leverages information in the discovered software table to allow users to proactively manage software licenses and ensure compliance.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| dis_sw_uuid | byte(16) | not null | Discovered software ID. Primary key. |
| sw_def_uuid | byte(16) | with null | Foreign key to the ca_software_def table for the software definition which this installed software represents. |
| asset_source_uuid | byte(16) | with null | Foreign key to the ca_asset_source table for the discovered asset on which this software is installed |
| label | nvarchar(255) | with null | Label |
| serial_number | nvarchar(64) | with null | Serial Number |
| product_guid | nvarchar(64) | with null | Product GUID |
| install_path | nvarchar(255) | with null | Install Path |
| last_accessed | integer | with null | Last accessed |
| creation_user | nvarchar(64) | with null | Creation User |
| creation_date | integer | with null | Creation Date |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date. |
| version_number | integer | with null | Version number. |
| auto_rep_version | date | with null | Internal revision number used for replication and maintained by the DBMS. |
| license_uuid | byte(16) | with null | Foreign key to the ca_software_license table for the license that authorizes the use of this installed software. |
| exclude_registration | integer | with null | How to equate the filter, example, "==" value must equal filter, REGEX value must contain filter expression. |
| delete_time | integer | with null | Delete Time |
| is_managed_by_service | integer1 | with null | Is managed by service flag |
| is_ignored_by_vuln_impact | integer1 | with null | Is ignored by vulnerability impact |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| dis_sw_uuid | ca_discovered_software_prop | dis_sw_uuid |