BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_HOST_SW_USAGE - Software Usage information table

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
DISC_SW_PROD_ID numeric 20 Link to the software instance to the software installation using the unique identifier (MATCH_HOST_SW_PROD & MATCH_HOST_SW_PROD_DET)
HOST_ID numeric 20  √  null Host Id
CAT_SW_UUID numeric 20  √  null Unique SW identifier(COALESCE of CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_ID)
IS_USED numeric 20  √  null Is Software being used?
LAST_USED_DATE datetime 16,3  √  null Software Last Used Date
USED_COUNT numeric 20  √  null Number of times Software used
RULE_INSTALLED_DATE numeric 20  √  null Installed date rule - Is on/off?
IS_USED_BY_INSTALLED_DATE numeric 20  √  null Installed date rule - Is Used?
INSTALLED_DATE datetime 16,3  √  null Installed date rule - Installed Date
RULE_RECENTLY_RUN numeric 20  √  null Recently run rule - Is on/off?
IS_USED_BY_RECENTLY_RUN numeric 20  √  null Recently run rule - Is Used?
LAST_RUN_DATE datetime 16,3  √  null Recently run rule - Last Run Date
RUN_COUNT numeric 20  √  null Recently run rule - Run Count
RUN_LAST_USERDOMAIN varchar 255  √  null Recently run rule - Last Run User Domain
RUN_LAST_USERLOGON varchar 255  √  null Recently run rule - Last Run User Logon
RUN_LAST_USERNAME varchar 255  √  null Recently run rule - Last Run User Name
RULE_METERING numeric 20  √  null Metering Rule - Is on/off?
IS_USED_BY_METERING numeric 20  √  null Metering rule - Is Used?
LAST_METERING_DATE datetime 16,3  √  null Metering Rule - Last metering date
METERING_NBR_OF_MONTHS numeric 20  √  null Metering Rule - Number of months used for the metering calculation
RULE_METERING_BY_MINUTES numeric 20  √  null Metering Rule - by Minutes - Is on/off?
METERING_NBR_OF_MINUTES numeric 20  √  null Metering Rule - by Minutes - Number of minutes used for the metering calculation
RULE_METERING_BY_TIMES numeric 20  √  null Metering Rule - by No. of time - Is on/off?
METERING_NBR_OF_TIMES numeric 20  √  null Metering Rule - by No. of time - Number of times used for the metering calculation
IS_SUITE varchar 1  √  null Is this software a Suite?
SUITE_ID numeric 20  √  null Suite Id of this software
GROUP_ID numeric 20  √  null Group Id of this software
TASK_ID numeric 20 Task ID
INVENTORY_ID numeric 20 Inventory ID
DATASRC nvarchar 100  √  null Data Source

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW MATCH_HOST_SW_USAGE AS SELECT DISC_SW_PROD_ID,HOST_ID,CAT_SW_UUID,IS_USED,LAST_USED_DATE,USED_COUNT,RULE_INSTALLED_DATE, IS_USED_BY_INSTALLED_DATE,INSTALLED_DATE,RULE_RECENTLY_RUN,IS_USED_BY_RECENTLY_RUN,LAST_RUN_DATE, RUN_COUNT,RUN_LAST_USERDOMAIN,RUN_LAST_USERLOGON,RUN_LAST_USERNAME,RULE_METERING,IS_USED_BY_METERING, LAST_METERING_DATE,METERING_NBR_OF_MONTHS,RULE_METERING_BY_MINUTES,METERING_NBR_OF_MINUTES,RULE_METERING_BY_TIMES, METERING_NBR_OF_TIMES,IS_SUITE,SUITE_ID,GROUP_ID,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_USAGE_237467998 UNION ALL SELECT DISC_SW_PROD_ID,HOST_ID,CAT_SW_UUID,IS_USED,LAST_USED_DATE,USED_COUNT,RULE_INSTALLED_DATE, IS_USED_BY_INSTALLED_DATE,INSTALLED_DATE,RULE_RECENTLY_RUN,IS_USED_BY_RECENTLY_RUN,LAST_RUN_DATE, RUN_COUNT,RUN_LAST_USERDOMAIN,RUN_LAST_USERLOGON,RUN_LAST_USERNAME,RULE_METERING,IS_USED_BY_METERING, LAST_METERING_DATE,METERING_NBR_OF_MONTHS,RULE_METERING_BY_MINUTES,METERING_NBR_OF_MINUTES,RULE_METERING_BY_TIMES, METERING_NBR_OF_TIMES,IS_SUITE,SUITE_ID,GROUP_ID,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_USAGE_237470163 UNION ALL SELECT DISC_SW_PROD_ID,HOST_ID,CAT_SW_UUID,IS_USED,LAST_USED_DATE,USED_COUNT,RULE_INSTALLED_DATE, IS_USED_BY_INSTALLED_DATE,INSTALLED_DATE,RULE_RECENTLY_RUN,IS_USED_BY_RECENTLY_RUN,LAST_RUN_DATE, RUN_COUNT,RUN_LAST_USERDOMAIN,RUN_LAST_USERLOGON,RUN_LAST_USERNAME,RULE_METERING,IS_USED_BY_METERING, LAST_METERING_DATE,METERING_NBR_OF_MONTHS,RULE_METERING_BY_MINUTES,METERING_NBR_OF_MINUTES,RULE_METERING_BY_TIMES, METERING_NBR_OF_TIMES,IS_SUITE,SUITE_ID,GROUP_ID,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_USAGE_9999
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA