BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_SOFTWARE_METERING - Metering 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 sofware metering ID
HOST_ID numeric 20  √  null Host ID for metering data
TASK_ID numeric 20 Task ID for this row
INVENTORY_ID numeric 20 Inventory ID for this row
CAT_SW_UUID numeric 20  √  null Unique SW identifier(COALESCE of CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_SW_VERSION_ID)
HOSTNAME nvarchar 2048  √  null Host name for metering data
PUBLISHER nvarchar 4000  √  null Publihser for metering data (e.g., Adobe Systems, Microsoft)
PRODUCT_NAME nvarchar 4000  √  null Product name for metering data (e.g., Dreamweaver, Access)
PRODUCT_FAMILY nvarchar 510  √  null Product family for metering data (e.g., Creative, Office)
VERSION nvarchar 128  √  null Product version for metering data
EDITION nvarchar 4000  √  null Product edition for metering data
NUMBER_OF_MINUTES float 8  √  null Number of minutes
USAGE_MONTH char 3  √  null Usage month (e.g., Oct, Nov)
USAGE_MONTH_N float 8  √  null Usage month number (e.g., 10, 11)
USAGE_YEAR float 8  √  null Usage year (e.g., 2008, 2010)
CAT_MANUFACTURER_ID numeric 20  √  null Publisher ID from catalog
CAT_SW_PRODUCT_ID numeric 20  √  null Product ID from catalog
CAT_SW_VERSION_GROUP_ID numeric 20  √  null Catalog Version Group Id
CAT_SW_VERSION_ID numeric 20  √  null Version ID from catalog
CAT_VERSION_GROUP nvarchar 128  √  null Version group ID from catalog
CAT_SW_EDITION_ID numeric 20  √  null Edition ID from catalog
CAT_SW_RELEASE_ID numeric 20  √  null Release ID from catalog
DISCOVERED_INSTALLDATE datetime 16,3  √  null Discovered installed date
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
LASTUSEDDATE datetime 16,3  √  null Software last Used date
USAGECOUNT int 4  √  null Software usage count
TSUSAGECOUNT int 4  √  null Terminal usage count

Analyzed at Thu Jul 20 12:14 PDT 2017

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:

Confidential and Proprietary to BDNA