BDNA Data Platform 5.4 July 2017 (Oracle)
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 number 0  √  null Unique sofware metering ID
HOST_ID number 0  √  null
DISC_HOSTS.HOST_ID FK6_MATCH_SOFTWARE_METERING R
Host ID for metering data
TASK_ID number 18  √  null
DISC_HOSTS.TASK_ID FK6_MATCH_SOFTWARE_METERING R
MATCH_TASK_DET.TASK_ID FK4_MATCH_SOFTWARE_METERING R
Task ID for this row
INVENTORY_ID number 18  √  null
MATCH_INVENTORY.INVENTORY_ID FK5_MATCH_SOFTWARE_METERING R
DISC_HOSTS.INVENTORY_ID FK6_MATCH_SOFTWARE_METERING R
Inventory ID for this row
CAT_SW_UUID number 18  √  null Unique SW identifier
HOSTNAME nvarchar2 1024  √  null Host name for metering data
PUBLISHER nvarchar2 2000  √  null Publihser for metering data (e.g., Adobe Systems, Microsoft)
PRODUCT_NAME nvarchar2 2000  √  null Product name for metering data (e.g., Dreamweaver, Access)
PRODUCT_FAMILY nvarchar2 255  √  null Product family for metering data (e.g., Creative, Office)
VERSION nvarchar2 64  √  null Product version for metering data
EDITION nvarchar2 2000  √  null Product edition for metering data
NUMBER_OF_MINUTES float 126  √  null Number of minutes
USAGE_MONTH nvarchar2 3  √  null Usage month (e.g., Oct, Nov)
USAGE_MONTH_N float 126  √  null Usage month number (e.g., 10, 11)
USAGE_YEAR float 126  √  null Usage year (e.g., 2008, 2010)
CAT_MANUFACTURER_ID number 18  √  null Publisher ID from catalog
CAT_SW_PRODUCT_ID number 18  √  null Product ID from catalog
CAT_SW_VERSION_GROUP_ID number 18  √  null
CAT_SW_VERSION_ID number 18  √  null Version ID from catalog
CAT_VERSION_GROUP varchar2 64  √  null Version group ID from catalog
CAT_SW_EDITION_ID number 18  √  null Edition ID from catalog
CAT_SW_RELEASE_ID number 18  √  null Release ID from catalog
DISCOVERED_INSTALLDATE date 7  √  null Discovered installed date
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
LASTUSEDDATE date 7  √  null Software last Used date
USAGECOUNT number 38  √  null Software usage count
TSUSAGECOUNT number 38  √  null Terminal usage count

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_MATCH_SOFTWARE_METERING These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA