BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 Unique Id
INVENTORY_ID numeric 20 Inventory Id
TASK_ID numeric 20 Task Id
CAT_SW_UUID numeric 20  √  null COALESCE of CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_ID,CAT_SW_PRODUCT_ID
HOST_ID numeric 20  √  null Host Id
HOSTNAME varchar 1024  √  null Host Name
MANUFACTURER varchar 100  √  null Manufacturer
SOFTWARE varchar 255  √  null Software
FAMILY varchar 255  √  null Family
COMPONENT varchar 64  √  null Component
PATCHLEVEL varchar 64  √  null Patchlevel
VERSION varchar 64  √  null Version
VERSION_GROUP varchar 64  √  null Version Group
EDITION varchar 255  √  null Edition
FOLDERPATH varchar 500  √  null App's Folder path
LAUNCHCOUNT numeric 20  √  null App Launch Count
LASTUSERDOMAIN varchar 255  √  null Domian of Last User
LASTUSERLOGON varchar 255  √  null User Login of Last User
LASTUSERNAME varchar 255  √  null User Name of Last User
LASTUSEDDATE datetime 16,3  √  null Last Used Date
CAT_MANUFACTURER_ID numeric 20  √  null Catalog Manufacturer Id
CAT_SW_PRODUCT_ID numeric 20  √  null Catalog Product Id
CAT_SW_VERSION_GROUP_ID numeric 20  √  null Catalog Version Group Id
CAT_SW_VERSION_ID numeric 20  √  null Catalog Version Id
CAT_SW_EDITION_ID numeric 20  √  null Catalog Edition Id
CAT_SW_RELEASE_ID numeric 20  √  null Catalog Release Id
CAT_TAXONOMY2012_ID numeric 20  √  null Catalog Taxonomy Id
DATASRC varchar 25  √  null Data Source

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW MATCH_SW_RECENTLY_USED_APPS AS SELECT ID,INVENTORY_ID,TASK_ID,CAT_SW_UUID,HOST_ID,HOSTNAME,MANUFACTURER,SOFTWARE,FAMILY,COMPONENT,PATCHLEVEL,VERSION, VERSION_GROUP,EDITION,FOLDERPATH,LAUNCHCOUNT,LASTUSERDOMAIN,LASTUSERLOGON,LASTUSERNAME,LASTUSEDDATE,CAT_MANUFACTURER_ID, CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,DATASRC FROM MATCH_SW_RECENTLY_USED_APPS_237467998 UNION ALL SELECT ID,INVENTORY_ID,TASK_ID,CAT_SW_UUID,HOST_ID,HOSTNAME,MANUFACTURER,SOFTWARE,FAMILY,COMPONENT,PATCHLEVEL,VERSION, VERSION_GROUP,EDITION,FOLDERPATH,LAUNCHCOUNT,LASTUSERDOMAIN,LASTUSERLOGON,LASTUSERNAME,LASTUSEDDATE,CAT_MANUFACTURER_ID, CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,DATASRC FROM MATCH_SW_RECENTLY_USED_APPS_237470163 UNION ALL SELECT ID,INVENTORY_ID,TASK_ID,CAT_SW_UUID,HOST_ID,HOSTNAME,MANUFACTURER,SOFTWARE,FAMILY,COMPONENT,PATCHLEVEL,VERSION, VERSION_GROUP,EDITION,FOLDERPATH,LAUNCHCOUNT,LASTUSERDOMAIN,LASTUSERLOGON,LASTUSERNAME,LASTUSEDDATE,CAT_MANUFACTURER_ID, CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,DATASRC FROM MATCH_SW_RECENTLY_USED_APPS_9999
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA