BDNA Data Platform 5.4 July 2017 (Oracle)
MATCH_SW_RECENTLY_USED_APPS - Recently used apps information matched

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID number 0  √  null Unique Id
INVENTORY_ID number 18  √  null Inventory Id
TASK_ID number 18  √  null Task Id
CAT_SW_UUID number 18  √  null COALESCE of CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_ID,CAT_SW_PRODUCT_ID
HOST_ID number 0  √  null Host Id
HOSTNAME nvarchar2 1024  √  null Host Name
MANUFACTURER nvarchar2 255  √  null Manufacturer
SOFTWARE nvarchar2 255  √  null Software
FAMILY nvarchar2 255  √  null Family
COMPONENT nvarchar2 64  √  null Component
PATCHLEVEL nvarchar2 64  √  null Patchlevel
VERSION nvarchar2 64  √  null Version
VERSION_GROUP nvarchar2 64  √  null Version Group
EDITION nvarchar2 255  √  null Edition
FOLDERPATH nvarchar2 500  √  null App's Folder path
LAUNCHCOUNT number 0  √  null App Launch Count
LASTUSERDOMAIN nvarchar2 255  √  null Domian of Last User
LASTUSERLOGON nvarchar2 255  √  null User Login of Last User
LASTUSERNAME nvarchar2 255  √  null User Name of Last User
LASTUSEDDATE date 7  √  null Last Used Date
CAT_MANUFACTURER_ID number 18  √  null Catalog Manufacturer Id
CAT_SW_PRODUCT_ID number 18  √  null Catalog Product Id
CAT_SW_VERSION_GROUP_ID number 18  √  null Catalog Version Group Id
CAT_SW_VERSION_ID number 18  √  null Catalog Version Id
CAT_SW_EDITION_ID number 18  √  null Catalog Edition Id
CAT_SW_RELEASE_ID number 18  √  null Catalog Release Id
CAT_TAXONOMY2012_ID number 18  √  null Catalog Taxonomy Id
DATASRC nvarchar2 25  √  null Data Source

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + ID Primary key Asc/Asc/Asc PK_MATCH_SW_RECENTLY_USED_APPS These unique columns are also nullable
Confidential and Proprietary to BDNA