BDNA Data Platform 5.4 July 2017 (SQL Server) MATCH_HOST_SW_USAGE - Software Usage information table
|
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: