BDNA Data Platform 5.4 July 2017 (SQL Server) MATCH_SOFTWARE_METERING - Metering information matched
|
View Definition:
CREATE VIEW MATCH_SOFTWARE_METERING AS SELECT ID,HOST_ID,TASK_ID,INVENTORY_ID,CAT_SW_UUID,HOSTNAME,PUBLISHER,PRODUCT_NAME,PRODUCT_FAMILY,VERSION,
EDITION,NUMBER_OF_MINUTES,USAGE_MONTH,USAGE_MONTH_N,USAGE_YEAR,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,
CAT_VERSION_GROUP,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,DISCOVERED_INSTALLDATE,DATASRC,LASTUSEDDATE,
USAGECOUNT,TSUSAGECOUNT FROM MATCH_SOFTWARE_METERING_237467998 UNION ALL SELECT ID,HOST_ID,TASK_ID,INVENTORY_ID,CAT_SW_UUID,HOSTNAME,PUBLISHER,PRODUCT_NAME,PRODUCT_FAMILY,VERSION,
EDITION,NUMBER_OF_MINUTES,USAGE_MONTH,USAGE_MONTH_N,USAGE_YEAR,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,
CAT_VERSION_GROUP,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,DISCOVERED_INSTALLDATE,DATASRC,LASTUSEDDATE,
USAGECOUNT,TSUSAGECOUNT FROM MATCH_SOFTWARE_METERING_237470163 UNION ALL SELECT ID,HOST_ID,TASK_ID,INVENTORY_ID,CAT_SW_UUID,HOSTNAME,PUBLISHER,PRODUCT_NAME,PRODUCT_FAMILY,VERSION,
EDITION,NUMBER_OF_MINUTES,USAGE_MONTH,USAGE_MONTH_N,USAGE_YEAR,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,
CAT_VERSION_GROUP,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,DISCOVERED_INSTALLDATE,DATASRC,LASTUSEDDATE,
USAGECOUNT,TSUSAGECOUNT FROM MATCH_SOFTWARE_METERING_9999
Possibly Referenced Tables/Views: