SchemaSpy Analysis of BDNA_PUBLISH.dbo - ColumnsBDNA_Normalize_pbulish_ERD SQL Server Generated by
SchemaSpy
Generated by SchemaSpy on Thu Oct 04 14:29 PDT 2012
Legend:
Primary key columns
Columns with indexes
 

BDNA_PUBLISH.dbo contains 617 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
CAT_HARDWARE_MODEL AC_AVG_UNIT varchar 8  √  null The unit for AC_POWER_AVG column (watt or volt-amp)
CAT_HARDWARE_MODEL AC_FREQ_MAX float 8  √  null Manufacturer's suggested AC input requirements: maximum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)
CAT_HARDWARE_MODEL AC_FREQ_MIN float 8  √  null Manufacturer's suggested AC input requirements: minimum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)
CAT_HARDWARE_MODEL AC_HEAT_DISS_AVG varchar 60  √  null The average amount of heat per-unit of time generated by the device during typical use when it is hooked up to AC power (in BTU/hr)
CAT_HARDWARE_MODEL AC_HEAT_DISS_MAX varchar 60  √  null The peak/maximum amount of heat per-unit of time generated by the device when it is hooked up to AC power (in BTU/hr)
CAT_HARDWARE_MODEL AC_INPUT_HIGH_CURRENT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum current when the voltage switch is turned on the high range setting
CAT_HARDWARE_MODEL AC_INPUT_HIGH_CURRENT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum current when the voltage switch is turned on the high range setting
CAT_HARDWARE_MODEL AC_INPUT_HIGH_VOLT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum voltage when the voltage switch is turned on the high range setting
CAT_HARDWARE_MODEL AC_INPUT_HIGH_VOLT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum voltage when the voltage switch is turned on the high range setting
CAT_HARDWARE_MODEL AC_INPUT_LOW_CURRENT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum current when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
CAT_HARDWARE_MODEL AC_INPUT_LOW_CURRENT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum current when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
CAT_HARDWARE_MODEL AC_INPUT_LOW_VOLT_MAX float 8  √  null Manufacturer's suggested AC electrical input requirements: maximum voltage when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
CAT_HARDWARE_MODEL AC_INPUT_LOW_VOLT_MIN float 8  √  null Manufacturer's suggested AC electrical input requirements: minimum voltage when the voltage switch is turned on the low range setting, or when the device has no voltage switch (single voltage range)
CAT_HARDWARE_MODEL AC_MAX_UNIT varchar 8  √  null The unit for AC_POWER_MAX column (watt or volt-amp)
CAT_HARDWARE_MODEL AC_POWER_AVG varchar 60  √  null The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up to AC power (in watt or volt-amp)
CAT_HARDWARE_MODEL AC_POWER_MAX varchar 60  √  null The peak/maximum amount of power (energy per-unit of time) consumed by the device when it is hooked up to AC power (in watt or volt-amp)
DISC_ALL_OS ACTIVE nvarchar 2048  √  null Is this system active?
DISC_HOSTS ACTIVE varchar 1024  √  null Is host active? 1= yes, 0 = no
DISC_VIDEO_CONTROLLERS ADAPTERCOMPATIBILITY nvarchar 512  √  null Adapter compatibility eg:Microsoft,NVIDIA,ATI Technologies Inc.
DISC_VIDEO_CONTROLLERS ADAPTERDACTYPE nvarchar 512  √  null Adapter DAC Type eg:Integrated RAMDAC,Internal DAC(400MHz)
DISC_VIDEO_CONTROLLERS ADAPTERRAM float 8  √  null Adapter RAM
CAT_SOFTWARE ALIAS varchar 255  √  null Former/older name the software product was also known as
DISC_WINDOWS_MONITORS AVAILABILITY nvarchar 512  √  null Monitor availability
DISC_LOGICAL_DISKS AVAILABLECAPACITY float 8  √  null Logical disk available capacity
DISC_CPUS BITS float 8  √  null CPU bits
DISC_DISK_PARTITIONS BOOTPARTITION float 8  √  null Boot partition eg: 1, 0
DISC_DISK_PARTITIONS CAPACITY float 8  √  null Disk capacity
DISC_HDDS CAPACITY nvarchar 512  √  null Disk capacity
DISC_LOGICAL_DISKS CAPACITY float 8  √  null Logical disk capacity
DISC_LOGICAL_DISKS CAPACITYBUCKET nvarchar 512  √  null Logical disk cpacity bucket
DISC_LOGICAL_DISKS CAPACITYUSED float 8  √  null Logical disk capacity used
MATCH_HOST_HW_PROD_MODEL CAT_AC_AVG_UNIT nvarchar 16  √  null AC average unit from the catalog eg: watt
MATCH_HOST_HW_PROD_MODEL CAT_AC_FREQ_MAX float 8  √  null AC maximum frequency from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_FREQ_MIN float 8  √  null AC minumum frequency from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_HEAT_DISS_AVG nvarchar 120  √  null AC average heat dissipation from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_HEAT_DISS_MAX nvarchar 120  √  null AC max heat dissipation from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_HIGH_CURRENT_MAX float 8  √  null AC maximum high current from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_HIGH_CURRENT_MIN float 8  √  null AC minimum high current from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_HIGH_VOLT_MAX float 8  √  null AC maximum high volatage from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_HIGH_VOLT_MIN float 8  √  null AC minimum high volatage from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_LOW_CURRENT_MAX float 8  √  null AC maximum low current from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_LOW_CURRENT_MIN float 8  √  null AC minimum low current from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_LOW_VOLT_MAX float 8  √  null AC maximum low volatage from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_INPUT_LOW_VOLT_MIN float 8  √  null AC minimum low volatage from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_MAX_UNIT nvarchar 16  √  null AC power max unit from the catalog eg: watt
MATCH_HOST_HW_PROD_MODEL CAT_AC_POWER_AVG nvarchar 120  √  null AC power average from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_AC_POWER_MAX nvarchar 120  √  null AC power max from the catalog
MATCH_HOST_SW_PROD cat_component varchar 64  √  null product component from the catalog for this Software product eg: Client, Server
DISC_CPUS CAT_CPU_ID float 8  √  null CPU Id from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DATE_AVAILABLE nvarchar 60  √  null date available from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DATE_INTRODUCED nvarchar 60  √  null date introduced from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_HEAT_DISS_AVG nvarchar 120  √  null DC average heat dissipation from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_HEAT_DISS_MAX nvarchar 120  √  null DC max heat dissipation from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_HIGH_CURRENT float 8  √  null DC high current from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_HIGH_VOLT float 8  √  null DC high voltage from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_LOW_CURRENT float 8  √  null DC low current from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_LOW_VOLT float 8  √  null DC low voltage from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_POWER_AVG nvarchar 120  √  null DC power average from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_DC_POWER_MAX nvarchar 120  √  null DC power max from the catalog
MATCH_HOST_SW_PROD cat_edition varchar 2000  √  null edition from the catalog for this Software product eg: Design Standard, Professional
MATCH_HOST_SW_PROD cat_edition_id float 8  √  null edition Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET cat_edition_id float 8  √  null edition Id from catalog for this Software product
MATCH_SOFTWARE_METERING CAT_EDITION_ID float 8  √  null edition Id from catalog
MATCH_HOST_HW_PROD_MODEL CAT_END_OF_LIFE_DATE nvarchar 60  √  null end of life date from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_END_OF_SALES_DATE nvarchar 60  √  null end of sales date from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_ENERGY_STAR nvarchar 6  √  null energy star from the catalog eg: yes, no
MATCH_HOST_HW_PROD_MODEL CAT_EPEAT nvarchar 40  √  null EPEAT star from the catalog eg: Gold, Silver
MATCH_HOST_SW_PROD cat_ga_date varchar 60  √  null GA date from catalog for this Software product
MATCH_HOST_HW_PROD_MODEL CAT_HARDWARE_MODEL nvarchar 4000  √  null catalog manufacturer model for this hardware product eg: 397307-xx1
MATCH_HOST_HW_PROD_MODEL CAT_HARDWARE_PRODUCT nvarchar 510  √  null catalog Hostname for this hardware product
DISC_CS_CAT_MAP CAT_HW_MODEL_ID float 8  √  null Hardware model Id from the catalog
DISC_CS_CAT_MAP CAT_HW_PRODUCT_ID float 8  √  null Hardware Product Id from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_HW_PRODUCT_ID float 8  √  null catalog product Id for this hardware product
DISC_CS_CAT_MAP CAT_HW_PROFILE_ID float 8  √  null Hardware profile Id from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_LAST_SHIP_DATE nvarchar 60  √  null last ship date date from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_LAST_SUPPORT_DATE nvarchar 60  √  null last support date date from the catalog
MATCH_HOST_SW_PROD cat_licensable varchar 16  √  null Catalog information: if this software product licensable? eg: yes, no
MATCH_HOST_SW_PROD cat_licensable_detail varchar 50  √  null Catalog information: if this software product licensable? eg: yes, no,Generally Licensable, Some Releases are Licensable
MATCH_HOST_HW_PROD_MODEL CAT_MANUFACTURER nvarchar 4000  √  null catalog manufacturer name for this hardware product eg: Hewlett-Packard Company
DISC_CS_CAT_MAP CAT_MANUFACTURER_ID float 8  √  null Manufacturer Id from the catalog
DISC_OS_CAT_MAP CAT_MANUFACTURER_ID float 8  √  null Manufactuer id from Catalog
MATCH_HOST_HW_PROD_MODEL CAT_MANUFACTURER_ID float 8  √  null catalog manufacturer Id for this hardware product
MATCH_HOST_HW_PROD_MODEL CAT_MAX_NON_OPERATING_HUMIDITY float 8  √  null Maximum non operating humidity from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MAX_NON_OPERATING_TEMP float 8  √  null Maximum non operating temparature from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MAX_OPERATING_HUMIDITY float 8  √  null Maximum operating humidity from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MAX_OPERATING_TEMP float 8  √  null Maximum operating temparature from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MIN_NON_OPERATING_HUMIDITY float 8  √  null Minimum non operating humidity from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MIN_NON_OPERATING_TEMP float 8  √  null Minimum non operating temparature from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MIN_OPERATING_HUMIDITY float 8  √  null Minimum operating humidity from the catalog
MATCH_HOST_HW_PROD_MODEL CAT_MIN_OPERATING_TEMP float 8  √  null Minimum operating temparature from the catalog
MATCH_HOST_SW_PROD cat_patchlevel varchar 64  √  null Patch level from the catalog for this Software product eg: SP2
MATCH_HOST_HW_PROD_MODEL CAT_POWER_RATING nvarchar 512  √  null Power rating from the catalog eg: 100-132/200-240 VAC, 50-60 Hz, 10-6.1 A
MATCH_HOST_SW_PROD cat_product_family varchar 255  √  null product family from the catalog for this Software product eg: Office, Acrobat
MATCH_HOST_SW_PROD cat_product_id float 8  √  null product Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET cat_product_id float 8  √  null product Id from catalog for this Software product
MATCH_SOFTWARE_METERING CAT_PRODUCT_ID float 8  √  null product Id from catalog
MATCH_HOST_SW_PROD cat_product_name varchar 255  √  null product name from the catalog for this Software product eg: Flash Player, Photoshop Camera Raw
MATCH_HOST_SW_PROD cat_publisher varchar 255  √  null Publisher from the catalog for this Software product eg: Adobe Systems, Helios Software Solutions
MATCH_HOST_SW_PROD cat_publisher_id float 8  √  null publisher Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET cat_publisher_id float 8  √  null publisher Id from catalog for this Software product
MATCH_SOFTWARE_METERING CAT_PUBLISHER_ID float 8  √  null publisher Id from catalog
MATCH_HOST_SW_PROD cat_release_id float 8  √  null release Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET cat_release_id float 8  √  null release Id from catalog for this Software product
MATCH_SOFTWARE_METERING CAT_RELEASE_ID float 8  √  null release Id from catalog
MATCH_HOST_HW_PROD_MODEL CAT_SUPPORTED_OS nvarchar 4000  √  null catalog supported OS for this hardware product eg: Linux, NetWare, OpenServer, Solaris, UnixWare, Windows, VMware
DISC_OS_CAT_MAP CAT_SW_EDITION_ID float 8  √  null software edition Id from Catalog
DISC_OS_CAT_MAP CAT_SW_PRODUCT_ID float 8  √  null Software product Id from Catalog
DISC_OS_CAT_MAP CAT_SW_RELEASE_ID float 8  √  null software release Id from Catalog
DISC_OS_CAT_MAP CAT_SW_VERSION_ID float 8  √  null software version Id from Catalog
MATCH_HOST_HW_PROD_MODEL CAT_TAXONOMY_CATEGORY1 nvarchar 512  √  null Taxonomy category 1 from the catalog eg: Computers
MATCH_HOST_SW_PROD cat_taxonomy_category1 varchar 256  √  null taxonomy category 1 from the catalog for this Software product eg: Applications, Utilities
MATCH_HOST_HW_PROD_MODEL CAT_TAXONOMY_CATEGORY2 nvarchar 512  √  null Taxonomy category 2 from the catalog eg: Computers eg: Servers ,Desktops, Notebooks
MATCH_HOST_SW_PROD cat_taxonomy_category2 varchar 256  √  null taxonomy category 2 from the catalog for this Software product eg: Productivity, Multimedia
DISC_CS_CAT_MAP CAT_TAXONOMY_ID float 8  √  null Taxonomy Id from the catalog
DISC_OS_CAT_MAP CAT_TAXONOMY_ID float 8  √  null software taxonomy Id from Catalog
MATCH_HOST_SW_PROD cat_taxonomy_id float 8  √  null taxonomy Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET cat_taxonomy_id float 8  √  null taxonomy Id from catalog for this Software product
MATCH_HOST_SW_PROD cat_version varchar 64  √  null version from the catalog for this Software product eg: 2007, 2.0
MATCH_HOST_SW_PROD cat_version_group varchar 64  √  null version group from the catalog for this Software product eg: CS3, 2007
MATCH_SOFTWARE_METERING CAT_VERSION_GROUP nvarchar 128  √  null version group Id from catalog
MATCH_HOST_SW_PROD cat_version_id float 8  √  null version Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET cat_version_id float 8  √  null version Id from catalog for this Software product
MATCH_SOFTWARE_METERING CAT_VERSION_ID float 8  √  null version Id from catalog
MATCH_ALL_ADDREMOVE CATEGORY varchar 10  √  null Category eg: Mapped,Irrelevant,UnKnown
MATCH_ALL_EXE CATEGORY varchar 10  √  null Category eg: Mapped,Irrelevant,UnKnown
CAT_MANUFACTURER CITY varchar 256  √  null The city where the manufacturer is based in (usually where the headquarter is located)
MATCH_INVENTORY COMPANY_ID float 8  √  null Inventory company Id
MATCH_ALL_EXE COMPANY_NAME varchar 1024  √  null company name eg: Cisco Systems, Inc.
MATCH_INVENTORY COMPANY_NAME varchar 256  √  null Inventory company name
CAT_SOFTWARE COMPONENT varchar 64  √  null The component of the software product (if applicable)
DISC_HDDS CONNECTIONLOCATION nvarchar 512  √  null Disk connection location
DISC_HDDS CONNECTIONTYPE nvarchar 512  √  null Connection type eg: SCSI, IDE
CAT_CPU_PRODUCT CORES float 8  √  null Number of cores per- CPU chip
DISC_CPUS CORES float 8  √  null Number of CPU cores
CAT_MANUFACTURER COUNTRY varchar 256  √  null The country where the manufacturer is based in (usually where the headquarter is located)
DISC_CPUS CPU_LABEL nvarchar 512  √  null CPU Label eg:CPU0,CPU2,CPU3
DISC_ALL_OS CPU_SPEED float 8  √  null CPU Speed
DISC_VIDEO_CONTROLLERS CURRENTREFRESHRATE float 8  √  null Video controller current refresh rate
DISC_VIDEO_CONTROLLERS CURRENTVERTICALRESOLUTION float 8  √  null Video controller current vertical resolution
DISC_ALL_OS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_CDROMS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_COMPUTERSYSTEM DATASRC varchar 100  √  null Data Source for this row eg: SCCM, ADDM
DISC_CPUS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_CS_CAT_MAP DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_DISK_PARTITIONS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_HDDS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_HOSTS DATASRC varchar 25  √  null Data Source for this row eg: SCCM, ADDM
DISC_LOGICAL_DISKS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_OS_CAT_MAP DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_VIDEO_CONTROLLERS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_WINDOWS_MONITORS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_WINDOWS_NICS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
DISC_WINDOWS_SERVICES DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
MATCH_HOST_SW_PROD datasrc nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
MATCH_HOST_SW_PROD_DET datasrc nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
MATCH_SOFTWARE_METERING DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
MATCH_STATS DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
CAT_MANUFACTURER DATE_ACQUIRED varchar 60  √  null The date the manufacturer being acquired (if applicable)
CAT_HARDWARE_MODEL DATE_AVAILABLE varchar 30  √  null The date the hardware was available for sale, captured the way it was published by the vendor
CAT_SW_REL_SUPP_STAGE DATE_ENDDATE datetime 16,3  √  null The date that marks the end of the support stage/level, normalized to follow BDNA's date format
CAT_HARDWARE_MODEL DATE_INTRODUCED varchar 30  √  null The date the hardware was introduced/announced, captured the way it was published by the vendor
bdna_logger_tb db_name nvarchar 200  √  null Database name user for the task
CAT_HARDWARE_MODEL DC_HEAT_DISS_AVG varchar 60  √  null The average amount of heat per-unit of time generated by the device during typical use when it is hooked up to DC power (in BTU/hr)
CAT_HARDWARE_MODEL DC_HEAT_DISS_MAX varchar 60  √  null The peak/maximum amount of heat per-unit of time generated by the device when it is hooked up to DC power (in BTU/hr)
CAT_HARDWARE_MODEL DC_HIGH_CURRENT float 8  √  null Manufacturer's suggested DC input requirements: current when the voltage switch is turned on the high setting
CAT_HARDWARE_MODEL DC_HIGH_VOLT float 8  √  null Manufacturer's suggested DC input requirements: voltage when the voltage switch is turned on the high setting
CAT_HARDWARE_MODEL DC_LOW_CURRENT float 8  √  null Manufacturer's suggested DC input requirements: current when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage)
CAT_HARDWARE_MODEL DC_LOW_VOLT float 8  √  null Manufacturer's suggested DC input requirements: voltage when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage)
CAT_HARDWARE_MODEL DC_POWER_AVG varchar 60  √  null The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up to DC power (in watt or volt-amp)
CAT_HARDWARE_MODEL DC_POWER_MAX varchar 60  √  null The peak/maximum amount of power (energy per-unit of time) consumed by the device when it is hooked up to DC power (in watt or volt-amp)
DISC_WINDOWS_NICS DEFAULT_ROUTE nvarchar 512  √  null Windows NICS default route eg: 192.168.1.1 etc
CAT_MANUFACTURER DESCRIPTION varchar 1024  √  null Short description of the manufacturer
CAT_TAXONOMY DESCRIPTION varchar 256  √  null Short description of the category
DISC_DISK_PARTITIONS DESCRIPTION nvarchar 2048  √  null Disk partition description eg: Installable File System, Installable File System
DISC_LOGICAL_DISKS DESCRIPTION nvarchar 2048  √  null Logical disk description eg: CD-ROM Disc, Local Fixed Disk etc
DISC_VIDEO_CONTROLLERS DESCRIPTION nvarchar 2048  √  null Video controller description
DISC_DISK_PARTITIONS DEVICEID nvarchar 2048  √  null Divice Id eg:Disk #0, Partition #0, Disk #13, Partition #0 etc
DISC_VIDEO_CONTROLLERS DEVICEID nvarchar 2048  √  null Video controller device Id
DISC_HDDS DEVICENAME nvarchar 512  √  null Device Name eg: Disk drive \\.\PHYSICALDRIVE8
DISC_WINDOWS_NICS DHCP_ENABLED nvarchar 512  √  null Windows NICS DHCP enabled eg 1= yes, 0= no
DISC_WINDOWS_NICS DHCP_LEASE_EXPR nvarchar 512  √  null Windows NICS Lease exparation
DISC_WINDOWS_NICS DHCP_SERVER nvarchar 512  √  null Windows NICS DHCP server eg: 192.168.1.1,255.255.255.255
MATCH_HOST_HW_PROD_MODEL DISCOVERED_DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
MATCH_HOST_HW_PROD_MODEL DISCOVERED_DOMAIN nvarchar 2048  √  null Domain name
MATCH_HOST_HW_PROD_MODEL DISCOVERED_HOSTNAME nvarchar 2048  √  null Hostname for this hardware product
MATCH_HOST_SW_PROD DISCOVERED_INSTALLDATE datetime 16,3  √  null Discovered installed date Software product
MATCH_HOST_SW_PROD_DET DISCOVERED_INSTALLDATE datetime 16,3  √  null Discovered installed date Software product
MATCH_SOFTWARE_METERING DISCOVERED_INSTALLDATE datetime 16,3  √  null discovered installed date
MATCH_HOST_HW_PROD_MODEL DISCOVERED_MANUFACTURER nvarchar 2048  √  null Product manufacturer eg: Compaq
MATCH_HOST_HW_PROD_MODEL DISCOVERED_MODEL nvarchar 2048  √  null Model for this hardware product eg: Latitude D610
MATCH_HOST_SW_PROD DISCOVERED_NAME varchar 1024  √  null Discovered name for this Software product eg: Adobe Flash Player 9 Plugin,TextPad 4.7
MATCH_HOST_SW_PROD_DET DISCOVERED_NAME varchar 1024  √  null Discovered name for this Software product eg: Adobe Flash Player 9 Plugin,TextPad 4.7
MATCH_HOST_SW_PROD DISCOVERED_PUBLISHER varchar 1024  √  null Discovered publihser for this Software product eg: Adobe Systems, Inc., Ipswitch
MATCH_HOST_SW_PROD_DET DISCOVERED_PUBLISHER varchar 1024  √  null Discovered publihser for this Software product eg: Adobe Systems, Inc., Ipswitch
MATCH_HOST_HW_PROD_MODEL DISCOVERED_SERIALNUMBER nvarchar 512  √  null serialnumber for this hardware product
MATCH_HOST_SW_PROD DISCOVERED_VERSION varchar 1024  √  null Discovered version for this Software product eg:9.0.45.0
MATCH_HOST_SW_PROD_DET DISCOVERED_VERSION varchar 1024  √  null Discovered version for this Software product eg:9.0.45.0
DISC_WINDOWS_SERVICES DISPLAY_NAME nvarchar 2048  √  null Windows service display name eg: Application Layer Gateway Service, ClipBook
MATCH_ALL_ADDREMOVE DISPLAY_NAME varchar 1024  √  null Display name for addremove eg: Mobile Broadband Drivers,PGP Desktop
DISC_WINDOWS_NICS DNS nvarchar 512  √  null Windows NICS DNS
DISC_WINDOWS_NICS DNS_OTHER nvarchar 512  √  null Windows NICS DNS other
DISC_WINDOWS_NICS DNS_PRIMARY nvarchar 512  √  null Windows NICS DNS primary
DISC_WINDOWS_NICS DNS_SEARCH nvarchar 512  √  null Windows NICS DNS search
DISC_WINDOWS_NICS DNS_SECONDARY nvarchar 512  √  null Windows NICS DNS secondary
DISC_WINDOWS_NICS DNS_TERTIARY nvarchar 512  √  null Windows NICS DNS tertiaty
DISC_COMPUTERSYSTEM DOMAIN varchar 1024  √  null Domain for this Compueter System
DISC_CONSOLE_USER DOMAIN varchar 1024  √  null Domain the console belongs to
DISC_HOSTS DOMAIN varchar 1024  √  null Domain of the host
DISC_CDROMS DRIVE nvarchar 512  √  null CDROM drive eg: E:, D:
DISC_VIDEO_CONTROLLERS DRIVERDATE datetime 16,3  √  null Video controller driver date
DISC_VIDEO_CONTROLLERS DRIVERVERSION nvarchar 512  √  null Video controller driver version
DISC_WINDOWS_MONITORS EDID_VERSION nvarchar 512  √  null Monitor EDID(Extended Display Identification Data) version
DISC_ALL_OS EDITION nvarchar 512  √  null Operating System Edition eg: Professional,Standard (32-bit x86)
MATCH_SOFTWARE_METERING EDITION nvarchar 4000  √  null Product edition for metering data
CAT_SOFTWARE_RELEASE EDITION_ID float 8  √  null Software edition's unique identifier
CAT_MANUFACTURER EMAIL varchar 256  √  null Manufacturer's email address
CAT_SOFTWARE_LIFECYCLE END_OF_LIFE datetime 16,3  √  null The last date when full support for product is provided by the vendor, standardized to follow BDNA's date format. Partial support is still available
CAT_HARDWARE_MODEL END_OF_LIFE_DATE varchar 30  √  null The date where a device is announced to ?iscontinued?or ?egacy?by the manufacturer
CAT_SOFTWARE_LIFECYCLE END_OF_LIFE_STR varchar 60  √  null The last date when full support for product is provided by the vendor, captured the way it was published by the vendor. Partial support is still available
CAT_SOFTWARE_LIFECYCLE END_OF_LIFE_SUPPORT_LEVEL varchar 60  √  null The name of support level that marks the End of Life, captured the way it was published by the vendor
CAT_HARDWARE_MODEL END_OF_SALES_DATE varchar 30  √  null The last date to order the product through manufacturer point-of-sale mechanisms.
CAT_HARDWARE_MODEL ENERGY_STAR varchar 3  √  null A flag to indicate whether the device has earned the Energy Star certification or not
CAT_HARDWARE_MODEL EPEAT varchar 20  √  null A flag to indicate which EPEAT certification the device has earned: Gold, Silver, or Bronze
MATCH_TASK_DET ERROR_CODE varchar 256  √  null error code for this task
MATCH_TASK_DET ERROR_DESCRIPTION varchar 4000  √  null error description for this task
bdna_logger_tb event_timestamp datetime 16,3  √  (getdate()) Timestamp for the task event
DISC_WINDOWS_SERVICES EXE_PATH nvarchar 8000  √  null Windows service exe path eg: C:\WINDOWS\System32\alg.exe
CAT_SOFTWARE FAMILY varchar 255  √  null Brand/family in which the software product belongs to (if applicable)
CAT_MANUFACTURER FAX varchar 64  √  null Manufacturer's fax number
MATCH_ALL_EXE FILE_DESCRIPTION varchar 2000  √  null File description eg: AvExtractSvr Module
MATCH_ALL_EXE FILE_NAME varchar 1024  √  null File name eg: AvDSGlobalCatalog.exe
MATCH_ALL_EXE FILE_SIZE varchar 64  √  null File size
MATCH_ALL_EXE FILE_VERSION varchar 512  √  null File version eg: 4, 0, 5, 80
DISC_LOGICAL_DISKS FILESYSTEM nvarchar 2048  √  null Logical disk File system eg: NTFS
CAT_SOFTWARE_RELEASE GA_DATE varchar 60  √  null The date when the product is generally available through official vendor distributions, captured the way it was published by the vendor
CAT_SOFTWARE_RELEASE GA_DATE_C varchar 60  √  null
DISC_WINDOWS_MONITORS GAMMA_VALUE nvarchar 512  √  null Monitor Gamma value
CAT_HARDWARE_LIFECYCLE GENERAL_AVAILABILITY datetime 16,3  √  null The date the hardware was available for sale, standardized to follow BDNA's date format
CAT_SOFTWARE_LIFECYCLE GENERAL_AVAILABILITY datetime 16,3  √  null The date when the product is generally available through official vendor distributions, standardized to follow BDNA's date format
CAT_HARDWARE_LIFECYCLE GENERAL_AVAILABILITY_STR varchar 30  √  null The date the hardware was available for sale, captured the way it was published by the vendor
CAT_SOFTWARE_LIFECYCLE GENERAL_AVAILABILITY_STR varchar 60  √  null The date when the product is generally available through official vendor distributions, captured the way it was published by the vendor
MATCH_HOST_SW_PROD GROUP_ID float 8  √  null group Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET GROUP_ID float 8  √  null group Id from catalog for this Software product
DISC_GUID GUID nvarchar 2048  √  null GUID for the host
MATCH_ALL_ADDREMOVE GUID varchar 1024  √  null GUID id from this addremove eg: {18C71DD4-0147-4318-8689-AE836278FBFE}
DISC_ALL_OS HARDWARE nvarchar 512  √  null Hardware information eg: Dell Inc. Latitude D620, Compaq ProLiant DL580 G2
DISC_WINDOWS_MONITORS HARDWARE_NUMBER nvarchar 512  √  null Monitor hardware number
MATCH_HOST_SW_PROD_DET HIDDEN float 8  √  null Sofware product hidden? 1=yes 0= no. resons for hidden in hidden_reason column
MATCH_HOST_SW_PROD_DET HIDDEN_REASON varchar 1000  √  null Sofware product hidden reason eg: add/remove AND exe file resulting the same product,match result shows duplicated products on a same host etc
DISC_ALL_OS HOST_ID float 8  √  null Unique host Id
MATCH_HOST_SW_PROD HOST_ID float 8  √  null Host Id for this Software product
MATCH_HOST_SW_PROD_DET HOST_ID float 8  √  null Host Id for this Software product
MATCH_SOFTWARE_METERING HOST_ID float 8  √  null Host Id for metering data
DISC_ALL_OS HOSTNAME nvarchar 2048  √  null Host Name
DISC_COMPUTERSYSTEM HOSTNAME varchar 1024  √  null Host name for this system
DISC_HOSTS HOSTNAME varchar 1024  √  null Host name
MATCH_HOST_SW_PROD HOSTNAME varchar 255  √  null Host name for this Software product
MATCH_HOST_SW_PROD_DET HOSTNAME varchar 255  √  null Host name for this Software product
MATCH_SOFTWARE_METERING HOSTNAME nvarchar 2048  √  null Host name for metering data
CAT_HW_MODEL_PROFILE HW_MODEL_ID float 8  √  null Hardware model's unique identifier
CAT_HARDWARE_MODEL HW_PRODUCT_ID float 8  √  null Hardware product's unique identifier
CAT_HW_MODEL_PROFILE HW_PRODUCT_ID float 8  √  null Hardware product's unique identifier
MATCH_TASK_DET IMPORT_BEGIN_ON datetime 16,3  √  null import begin timestamp for this task
MATCH_TASK_DET IMPORT_END_ON datetime 16,3  √  null import end timestamp for this task
DISC_WINDOWS_MONITORS INPUT_SIGNAL nvarchar 512  √  null Monitor input signal
DISC_VIDEO_CONTROLLERS INSTALLEDDISPLAYDRIVERS nvarchar 2048  √  null Video controller installed display dirvers eg:nv4_disp.dll,igdumdx32.dll,igd10umd32.dll etc
CAT_HARDWARE_LIFECYCLE INTRODUCTION datetime 16,3  √  null The date the hardware was introduced/announced, standardized to follow BDNA's date format
CAT_HARDWARE_LIFECYCLE INTRODUCTION_STR varchar 30  √  null The date the hardware was introduced/announced, captured the way it was published by the vendor
MATCH_INVENTORY INVENTORY_END_DATE datetime 16,3  √  null Inventory end date
MATCH_HOST_SW_PROD INVENTORY_ID float 8  √  null Inventory Id for this row
MATCH_HOST_SW_PROD_DET INVENTORY_ID float 8  √  null Inventory Id for this row
MATCH_TASK_DET INVENTORY_ID float 8  √  null Inventory Id for this task
MATCH_INVENTORY INVENTORY_NAME varchar 256  √  null Inventory name
MATCH_INVENTORY INVENTORY_START_DATE datetime 16,3  √  null Inventory start date
DISC_WINDOWS_NICS IP_ADDRESS nvarchar 512  √  null Windows NICS IP address
MATCH_STATS IRRELEVANT float 8  √  null Total irrelavant addremove/exe
DISC_WINDOWS_SERVICES IS_DESKTOP_INTERACT nvarchar 512  √  null Allow service to interact with desktop?
MATCH_HOST_SW_PROD_DET IS_MAPPED char 1  √  null Sofware product mapped? eg: Y, N
MATCH_HOST_SW_PROD IS_SUITE char 1  √  null Catalog information: if this software product part of suite? eg: N, Y
MATCH_HOST_SW_PROD_DET IS_SUITE char 1  √  null Catalog information: if this software product part of suite? eg: N, Y
DISC_CPUS ISA nvarchar 8000  √  null CPU ISA (instruction set architecture)
DISC_LOGICAL_DISKS ISLOCAL nvarchar 200  √  null Is Logical disk local? eg: local
MATCH_STATS KNOWN float 8  √  null Total known addremove/exe
MATCH_STATS KNOWN_PERC float 8  √  null Total known percentage of addremove/exe
CAT_CPU_PRODUCT LABEL varchar 255  √  null CPU model (which includes model number, speed/clock rate, and code name if applicable)
CAT_HARDWARE_MODEL LABEL varchar 2000  √  null The device's model name/number
CAT_HARDWARE_PRODUCT LABEL varchar 255  √  null Hardware product name
CAT_MANUFACTURER LABEL varchar 2000  √  null Manufacturer name (as obtained from the official website), minus the legal entity
CAT_SOFTWARE LABEL varchar 2000  √  null The name of the software product
CAT_SOFTWARE_EDITION LABEL varchar 2000  √  null Software product's edition name
CAT_SOFTWARE_RELEASE LABEL varchar 2000  √  null Software product's unique identifier
CAT_SOFTWARE_VERSION LABEL varchar 64  √  null Software patch's name/number
CAT_SUPPORT_POLICY LABEL varchar 60  √  null The name of the support policy, captured the way it was published by the vendor
CAT_SUPPORT_STAGE LABEL varchar 60  √  null The name of the support stage/level, captured the way it was published by the vendor
CAT_SW_REL_PLATFORM LABEL varchar 2000  √  null Software release's platform name
CAT_SW_VERSION_GROUP LABEL varchar 64  √  null The name of version group (or market version) of the software product
CAT_TAXONOMY LABEL varchar 256  √  null Category 2 name
CAT_TAXONOMY LABEL_IN_FRENCH varchar 256  √  null
CAT_TAXONOMY LABEL_IN_GERMAN varchar 256  √  null
CAT_HARDWARE_LIFECYCLE LAST_AVAILABILITY datetime 16,3  √  null The last date the hardware is available for purchase from the vendor, standardized to follow BDNA's date format
CAT_HARDWARE_LIFECYCLE LAST_AVAILABILITY_STR varchar 30  √  null The last date the hardware is available for purchase from the vendor, captured the way it was published by the vendor
CAT_CPU_PRODUCT LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_HARDWARE_MODEL LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_HARDWARE_PRODUCT LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_HW_MODEL_PROFILE LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_MANUFACTURER LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SOFTWARE LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SOFTWARE_EDITION LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SOFTWARE_RELEASE LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SOFTWARE_VERSION LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SUPPORT_POLICY LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SUPPORT_STAGE LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SW_REL_PLATFORM LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SW_REL_SUPP_STAGE LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_SW_VERSION_GROUP LAST_MODIFIED_DATE datetime 16,3  √  null The date when last modification on the row was made
CAT_TECHNOPEDIA_VERSIONS LAST_MODIFIED_DATE datetime 16,3  √  null The date the Technopedia Version's entry was last modified
CAT_HARDWARE_MODEL LAST_SHIP_DATE varchar 30  √  null The last-possible ship date that can be requested of the manufacturer and/or its contract manufacturers
CAT_HARDWARE_MODEL LAST_SUPPORT_DATE varchar 30  √  null The last date the support will be provided by the manufacturer (even after the device has been discontinued). After this date, all support services for the product are unavailable, and the product becomes obsolete.
DISC_CONSOLE_USER LASTCONSOLEUSE_TIME datetime 16,3  √  null Timestamp when console was used last time
DISC_ALL_OS LASTLOGON nvarchar 512  √  null Last logon information eg: januta01,mowdam01a
CAT_MANUFACTURER LEGAL varchar 64  √  null Legal entity of the company (e.g. Corporation, Limited, etc.)
CAT_TECHNOPEDIA_VERSIONS LEGAL nvarchar 8000  √  null Legal verbage (copyright information)
DISC_ALL_OS LEVEL2 char 1  √  null Level2
CAT_SOFTWARE_RELEASE LICENSABLE varchar 16  √  null A flag to indicate whether the software release is licensable or not
DISC_ALL_OS LOCALFILESYSTEMSPACEAVAILABLE float 8  √  null Available Local file system space
DISC_ALL_OS LOCALFILESYSTEMSPACEPCT float 8  √  null Percentage Local file system space
DISC_ALL_OS LOCALFILESYSTEMSPACETOTAL float 8  √  null Total Local file system space
DISC_ALL_OS LOCALFILESYSTEMSPACEUSED float 8  √  null Used Local file system space
DISC_LOGICAL_DISKS LOGICALDISK_LABEL nvarchar 2048  √  null Logical disk label eg: D:, A:
DISC_WINDOWS_NICS MACADDRESS nvarchar 512  √  null Windows NIC MAC address
DISC_WINDOWS_MONITORS MANUF_DATE nvarchar 512  √  null Monitor manufacture date
DISC_ALL_OS MANUFACTURER nvarchar 512  √  null Operating System Manufacturer name
DISC_CDROMS MANUFACTURER nvarchar 512  √  null CDROM Manufacturer
DISC_COMPUTERSYSTEM MANUFACTURER varchar 1024  √  null Manufacturer eg:Dell Inc., Compaq
DISC_CPUS MANUFACTURER nvarchar 512  √  null Manufacturer for this CPU eg:GenuineIntel,AuthenticAMD
DISC_HDDS MANUFACTURER nvarchar 512  √  null Disk Manufcaturer
DISC_WINDOWS_MONITORS MANUFACTURER nvarchar 512  √  null Monitor manufacturer
CAT_CPU_PRODUCT MANUFACTURER_ID float 8  √  null CPU manufacturer
CAT_HARDWARE_MODEL MANUFACTURER_ID float 8  √  null Manufacturer's unique identifier
CAT_HARDWARE_PRODUCT MANUFACTURER_ID float 8  √  null Manufacturer's unique identifier
CAT_HW_MODEL_PROFILE MANUFACTURER_ID float 8  √  null Manufacturer's unique identifier
CAT_SOFTWARE MANUFACTURER_ID float 8  √  null Manufacturer's unique identifier
CAT_SOFTWARE_RELEASE MANUFACTURER_ID float 8  √  null Manufacturer's unique identifier
CAT_SUPPORT_POLICY MANUFACTURER_ID float 8  √  null Manufacturer's unique identifier
MATCH_STATS MAPPED float 8  √  null Total mapped addremove/exe
MATCH_TASK_DET MAPPING_BEGIN_ON datetime 16,3  √  null mapping begin timestamp for this task
MATCH_TASK_DET MAPPING_END_ON datetime 16,3  √  null mapping end timestamp for this task
CAT_HW_MODEL_PROFILE MAX_DEPTH float 8  √  null Maximum depth of the device (in inches)
CAT_HW_MODEL_PROFILE MAX_HEIGHT float 8  √  null Maximum height of the device (in inches)
CAT_HARDWARE_MODEL MAX_NON_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested peak/maximum humidity of the device when it is non-operational or in storage (%)
CAT_HARDWARE_MODEL MAX_NON_OPERATING_TEMP float 8  √  null Manufacturer's suggested peak/maximum temperature of the device when it is non-operational or in storage (in ?)
CAT_HARDWARE_MODEL MAX_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested peak/maximum humidity of the device during operation (in %)
CAT_HARDWARE_MODEL MAX_OPERATING_TEMP float 8  √  null Manufacturer's suggested peak/maximum temperature of the device during operation (in ?)
CAT_HW_MODEL_PROFILE MAX_WEIGHT float 8  √  null Maximum weight of the device (in lbs)
CAT_HW_MODEL_PROFILE MAX_WIDTH float 8  √  null Maximum width of the device (in inches)
DISC_CPUS MAXSPEED float 8  √  null Maximum CPU speed
bdna_logger_tb message nvarchar 8000  √  null Message for the task event
CAT_HW_MODEL_PROFILE MIN_DEPTH float 8  √  null Minimum depth of the device (in inches)
CAT_HW_MODEL_PROFILE MIN_HEIGHT float 8  √  null Minimum height of the device (in inches)
CAT_HARDWARE_MODEL MIN_NON_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested minimum humidity of the device when it is non-operational or in storage (in %)
CAT_HARDWARE_MODEL MIN_NON_OPERATING_TEMP float 8  √  null Manufacturer's suggested minimum temperature of the device when it is non-operational or in storage (in ?)
CAT_HARDWARE_MODEL MIN_OPERATING_HUMIDITY float 8  √  null Manufacturer's suggested minimum humidity of the device during operation (in %)
CAT_HARDWARE_MODEL MIN_OPERATING_TEMP float 8  √  null Manufacturer's suggested minimum temperature of the device during operation (in ?)
CAT_HW_MODEL_PROFILE MIN_WEIGHT float 8  √  null Minimum weight of the device (in lbs)
CAT_HW_MODEL_PROFILE MIN_WIDTH float 8  √  null Minimum width of the device (in inches)
DISC_CDROMS MODEL nvarchar 2048  √  null CDROM Model
DISC_COMPUTERSYSTEM MODEL varchar 1024  √  null Manufuacturer eg: Latitude D620,ProLiant BL465c G5
DISC_CPUS MODEL nvarchar 512  √  null CPU Model eg: Genuine Intel(R) CPU T2500 @ 2.00GHz
DISC_HDDS MODEL nvarchar 2048  √  null Model eg: SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0002 000019010173171F, SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0001 2_0_0_0
DISC_WINDOWS_MONITORS MODEL_NAME nvarchar 512  √  null Monitor name
DISC_WINDOWS_MONITORS MONITOR_TYPE nvarchar 512  √  null Monitor type eg: Default Monitor, Generic PnP Monitor
DISC_LOGICAL_DISKS MOUNTPOINT nvarchar 200  √  null Logical disk mount point eg: D:, C: etc
CAT_TECHNOPEDIA_VERSIONS NAME numeric 40  √  null CAT_TECHNOPEDIA_VERSIONS table's unique identifier
DISC_CDROMS NAME nvarchar 512  √  null CDROM Name
DISC_DISK_PARTITIONS NAME nvarchar 512  √  null Disk partition Name eg: Disk #0, Partition #0
DISC_VIDEO_CONTROLLERS NAME nvarchar 1024  √  null Video controller name
DISC_WINDOWS_NICS NETWORK_MASK nvarchar 512  √  null Windows NICS netword mask eg: 255.255.255.0
DISC_WINDOWS_NICS NIC_LABEL nvarchar 512  √  null Windows NICS label eg: Broadcom NetXtreme 57xx Gigabit Controller
DISC_WINDOWS_NICS NIC_MANUF nvarchar 512  √  null Windows NICS manufacturer
DISC_WINDOWS_NICS NIC_NAME nvarchar 512  √  null Windows NICS name
MATCH_SOFTWARE_METERING NUMBER_OF_MINUTES float 8  √  null Number of minutes
DISC_ALL_OS NUMCPUS float 8  √  null Number of CPUS
DISC_HDDS NUMPARTITIONS float 8  √  null Number of partitions on the disk
CAT_HARDWARE_LIFECYCLE OBSOLETE datetime 16,3  √  null The date when any form of support from the vendor ceases to exist, captured the way it was published by the vendor
CAT_SOFTWARE_LIFECYCLE OBSOLETE datetime 16,3  √  null The last date when any support is provided by the vendor, standardized to follow BDNA's date format. The only support available after this date (if applicable) is self-help online support
DISC_HOSTS OBSOLETE varchar 1024  √  null Is host obsolete? 1= yes, 0= no
CAT_HARDWARE_LIFECYCLE OBSOLETE_STR varchar 30  √  null
CAT_SOFTWARE_LIFECYCLE OBSOLETE_STR varchar 60  √  null The last date when any support is provided by the vendor, captured the way it was published by the vendor. The only support available after this date (if applicable) is self-help online support
CAT_SOFTWARE_LIFECYCLE OBSOLETE_SUPPORT_LEVEL varchar 60  √  null The name of support level that marks the Obsolete, captured the way it was published by the vendor
DISC_CDROMS OPERATINGSYSTEM_ID float 8  √  null Operating System Id
DISC_CPUS OPERATINGSYSTEM_ID float 8  √  null Operating System Id for this console
DISC_DISK_PARTITIONS OPERATINGSYSTEM_ID float 8  √  null Operating System Id for this disk
DISC_HDDS OPERATINGSYSTEM_ID float 8  √  null Operating System Id for this disk
DISC_LOGICAL_DISKS OPERATINGSYSTEM_ID float 8  √  null Operating System Id for the logical disk
DISC_VIDEO_CONTROLLERS OPERATINGSYSTEM_ID float 8  √  null Operating System Id for this video controller
DISC_WINDOWS_MONITORS OPERATINGSYSTEM_ID float 8  √  null Operating System Id for this monitor
DISC_WINDOWS_NICS OPERATINGSYSTEM_ID float 8  √  null Operating System Id
DISC_WINDOWS_SERVICES OPERATINGSYSTEM_ID float 8  √  null Operating System Id
DISC_ALL_OS OPERATINGSYSTEM_INSTALLDATE datetime 16,3  √  null
DISC_ALL_OS OPERATINGSYSTEM_LABEL nvarchar 512  √  null Operating System label
DISC_ALL_OS OPERATINGSYSTEM_TYPE_LABEL nvarchar 2048  √  null Operating System Label(eg: Vista, XP etc)
MATCH_HOST_SW_PROD_DET ORIGINATE_FROM float 8  √  null Sofware product originate from eg: 1= Add/Remove 2= Exe 4 =OS
DISC_ALL_OS OS_FAMILY nvarchar 512  √  null Operating System Family eg: Windows, Linux
bdna_logger_tb os_user nvarchar 200  √  null Username for the task
DISC_ALL_OS OSBITMODE float 8  √  null Operating System bit mode eg: 32bit, 64 bit
DISC_ALL_OS OSBUILDNUMBER nvarchar 512  √  null Operating System build number
DISC_ALL_OS OSCOMPUTERDOMAIN nvarchar 512  √  null Computer Domain
DISC_ALL_OS OSCOMPUTERNAME nvarchar 512  √  null Operating System Computer name
CAT_MANUFACTURER OWNER_ID float 8  √  null Manufacturer owner's unique identifier
CAT_TAXONOMY PARENT_ID float 8  √  null Category 1 ID
CAT_SOFTWARE_RELEASE PATCHLEVEL varchar 255  √  null The name of patch level for the software release
CAT_SOFTWARE_VERSION PATCHLEVEL varchar 64  √  null Software Subversion (BDNA Internal column)
DISC_ALL_OS PATCHLEVEL nvarchar 512  √  null Patch Level eg: Service Pack 2
DISC_LOGICAL_DISKS PERCENTUTILIZED float 8  √  null Logical disk percentage utilized
CAT_MANUFACTURER PHONE varchar 64  √  null Manufacturer's telephone number
DISC_HDDS PHYSICALVOLUME_STATE nvarchar 512  √  null Disk physical volume
DISC_WINDOWS_MONITORS PIXELS_PER_XINCH float 8  √  null Monitor PIXELS per inch X co-ordinate
DISC_WINDOWS_MONITORS PIXELS_PER_YINCH float 8  √  null Monitor PIXELS per inch Y co-ordinate
CAT_SW_REL_PLATFORM PLATFORM_LABEL varchar 255  √  null The name of platform supported by the software release
CAT_SOFTWARE PLICSABLE float 8  √  null A flag to indicate whether the software product is licensable or not
DISC_WINDOWS_NICS PNP_DEVICEID nvarchar 512  √  null Windows NICS PNP device Id
DISC_HDDS PNPDEVICEID nvarchar 2048  √  null PNP device Id
CAT_HARDWARE_MODEL POWER_RATING varchar 256  √  null Summary of the device's various power ratings: Voltage, Frequency, Current
DISC_WINDOWS_MONITORS POWERSAVING_MGMT nvarchar 512  √  null Monitor power saving management
DISC_DISK_PARTITIONS PRIMARYPARTITION float 8  √  null Primary partition ? eg 1 = yes, 0 = no
MATCH_TASK_DET PROCESS_STATUS varchar 20  √  null process status for this task
MATCH_SOFTWARE_METERING PRODUCT_FAMILY nvarchar 510  √  null Product family for metering data eg: Creative, Office
CAT_SOFTWARE_EDITION PRODUCT_ID float 8  √  null Software product's unique identifier
CAT_SOFTWARE_RELEASE PRODUCT_ID float 8  √  null Software product's unique identifier
CAT_SOFTWARE_VERSION PRODUCT_ID float 8  √  null Software product's unique identifier
CAT_SW_VERSION_GROUP PRODUCT_ID float 8  √  null Software product's unique identifier
DISC_WINDOWS_MONITORS PRODUCT_ID nvarchar 512  √  null Monitor product Id
MATCH_ALL_EXE PRODUCT_LANGUAGE varchar 256  √  null Product Language
MATCH_ALL_EXE PRODUCT_NAME varchar 1024  √  null Product name eg: AvNotifier Executable, AvPostProcSvr Module
MATCH_SOFTWARE_METERING PRODUCT_NAME nvarchar 4000  √  null Product name for metering data eg: Dreamweaver, Access
MATCH_ALL_EXE PRODUCT_VERSION varchar 512  √  null Product version eg: 4.0(5)
CAT_HW_MODEL_PROFILE PROFILE varchar 60  √  null Profile (or form factor) of the device
CAT_SW_REL_SUPP_STAGE PUBLISHED_ENDDATE varchar 60  √  null The date that marks the end of the support stage/level, captured the way it was published by the vendor
MATCH_ALL_ADDREMOVE PUBLISHER varchar 1024  √  null Publisher for addremove eg: Core Services ,Trend Micro
MATCH_SOFTWARE_METERING PUBLISHER nvarchar 4000  √  null Publihser for metering data eg: Adobe Systems, Microsoft
MATCH_ALL_ADDREMOVE REASONS varchar 1024  √  null Reasons for addremove
MATCH_ALL_EXE REASONS varchar 1024  √  null Reasons
CAT_TECHNOPEDIA_VERSIONS RELDATE datetime 16,3  √  null Technopedia's release date
CAT_SW_REL_PLATFORM RELEASE_ID float 8  √  null Software release's unique identifier
CAT_SW_REL_SUPP_STAGE RELEASE_ID float 8  √  null Software release's unique identifier
CAT_TECHNOPEDIA_VERSIONS RELORDER numeric 40  √  null Technopedia releases' order, where 1 equals Release 2.0, and so on
CAT_MANUFACTURER REVENUE float 8  √  null The latest annual revenue (in millions of USD)
DISC_ALL_OS SCANDATE datetime 16,3  √  null Last Scan Date
DISC_WINDOWS_MONITORS SCREEN_HEIGHT float 8  √  null Monitor screen height
DISC_WINDOWS_MONITORS SCREEN_WIDTH float 8  √  null Monitor screen width
DISC_CONSOLE_USAGE_MAXGROUP SECURITY_LOG_START_DATE varchar 1024  √  null Security log start date
DISC_ALL_OS SERIALNUMBER nvarchar 512  √  null Serial number
DISC_CDROMS SERIALNUMBER nvarchar 512  √  null CDROM Serial Number
DISC_HDDS SERIALNUMBER nvarchar 512  √  null Disk serial number
DISC_WINDOWS_SERVICES SERVICE_NAME nvarchar 512  √  null Windows service name eg:AppMgmt ,CryptSvc
DISC_WINDOWS_SERVICES SERVICE_TYPE nvarchar 512  √  null Windows service type eg: Own Process,Share Process
DISC_CPUS SOCKETDESIGNATION nvarchar 512  √  null Socket designation eg:Microprocessor,Socket M2,Proc 3
MATCH_HOST_SW_PROD_DET SOURCE_BITMAP float 8  √  null Sofware product source bit map
DISC_CPUS SPEED float 8  √  null CPU speed
CAT_SW_REL_SUPP_STAGE STAGE_NAME varchar 60  √  null The name of the support stage/level, captured the way it was published by the vendor
CAT_SUPPORT_STAGE STAGEORDER float 8  √  null The order the support stage/level
CAT_SW_REL_SUPP_STAGE STAGEORDER float 8  √  null The order the support stage/level
DISC_WINDOWS_SERVICES STARTUP_TYPE nvarchar 512  √  null Windows service startup type eg: Automatic, Manual and Disabled
DISC_WINDOWS_SERVICES STATUS nvarchar 512  √  null Windows service staus
CAT_SOFTWARE_VERSION SUBVERSION varchar 60  √  null Software patch's level (Critical or Optional)
CAT_SOFTWARE SUITE float 8  √  null A flag to indicate whether the software product is a suite or not
MATCH_HOST_SW_PROD SUITE_ID float 8  √  null suite Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET SUITE_ID float 8  √  null suite Id from catalog for this Software product
CAT_SUPPORT_STAGE SUPPORT_POLICY_ID float 8  √  null Support policy's unique identifier
CAT_SW_REL_SUPP_STAGE SUPPORT_STAGE_ID float 8  √  null Software support stage's unique identifier
CAT_HARDWARE_MODEL SUPPORTED_OS varchar 2000  √  null The list of supported operating systems that can be run on the device
CAT_MANUFACTURER SYMBOL varchar 16  √  null The company's stock/ticker symbol (if it's publicly traded)
MATCH_HOST_SW_PROD TASK_ID float 8  √  null Task Id for this row
MATCH_HOST_SW_PROD_DET TASK_ID float 8  √  null Task Id for this row
MATCH_TASK_DET TASK_NAME varchar 256  √  null Task name for this task
CAT_HARDWARE_MODEL TAXONOMY_ID float 8  √  null BDNA Taxonomy's unique identifier
CAT_HARDWARE_PRODUCT TAXONOMY_ID float 8  √  null BDNA Taxonomy's unique identifier
CAT_HW_MODEL_PROFILE TAXONOMY_ID float 8  √  null BDNA Taxonomy's unique identifier
CAT_SOFTWARE TAXONOMY_ID float 8  √  null BDNA Taxonomy's unique identifier
CAT_SOFTWARE_EDITION TAXONOMY_ID float 8  √  null BDNA Taxonomy's unique identifier
CAT_CPU_PRODUCT THREADED varchar 16  √  null A flag to indicate whether the CPU supports multithreading or not
DISC_CPUS THREADS float 8  √  null Number of CPU threads
CAT_MANUFACTURER TIER float 8  √  null Categorization of manufacturers based on priority/importance
DISC_CONSOLE_USER TIMESTAMP datetime 16,3  √  null Timestamp
MATCH_STATS TOTAL float 8  √  null Total number of addremove/exe
DISC_CONSOLE_USAGE_MAXGROUP TOTAL_CONSOLE_TIME varchar 1024  √  null Total Console time in seconds
DISC_CONSOLE_USAGE_MAXGROUP TOTAL_CONSOLE_USERS varchar 1024  √  null Total number of Console users
DISC_CONSOLE_USAGE_MAXGROUP TOTAL_SECURITY_LOGTIME varchar 1024  √  null Total Security log time in seconds
DISC_ALL_OS TOTALMEMORY float 8  √  null Total Memory
DISC_ALL_OS TOTALVIRTUALMEMORY float 8  √  null Total Virtual memory
DISC_ALL_OS TOTALVISIBLEMEMORY float 8  √  null Total Visible Virtual memory
DISC_ALL_OS TOTMEMBUCKET nvarchar 512  √  null Total Memory bucket
MATCH_STATS UNKNOWN float 8  √  null Total unknown of addremove/exe
MATCH_ALL_ADDREMOVE UNKNOWN_INSTANCES numeric 20  √  null
MATCH_ALL_EXE UNKNOWN_INSTANCES numeric 20  √  null
MATCH_STATS UNKNOWN_PERC float 8  √  null Total unknown percentage of addremove/exe
DISC_ALL_OS UPTIME float 8  √  null Total uptime
MATCH_SOFTWARE_METERING USAGE_MONTH char 3  √  null usage month eg: Oct, Nov
MATCH_SOFTWARE_METERING USAGE_MONTH_N float 8  √  null usage month number eg: 10, 11
MATCH_SOFTWARE_METERING USAGE_YEAR float 8  √  null usage year eg: 2008, 2010
CAT_TECHNOPEDIA_VERSIONS VERSION nvarchar 128  √  null Technopedia's version number
DISC_ALL_OS VERSION nvarchar 512  √  null Operating System version eg: 5.1.2600, 5.2.3790
MATCH_ALL_ADDREMOVE VERSION varchar 1024  √  null Addremove version eg: 1.5.3, 5.10.4803.0
MATCH_SOFTWARE_METERING VERSION nvarchar 128  √  null Product version for metering data
CAT_SOFTWARE_RELEASE VERSION_GROUP_ID float 8  √  null Software version group's unique identifier
CAT_SOFTWARE_VERSION VERSION_GROUP_ID float 8  √  null Software version group's unique identifier
CAT_SOFTWARE_RELEASE VERSION_ID float 8  √  null Software version's unique identifier
DISC_VIDEO_CONTROLLERS VIDEOMODEDESCRIPTION nvarchar 1024  √  null Video controller video mode description eg:1440 x 900 x 4294967296 colors etc
DISC_VIDEO_CONTROLLERS VIDEOPROCESSOR nvarchar 1024  √  null Video controller video processor egGeForce Go 7300, MOBILITY RADEON X300 (0x5460)
DISC_CS_CAT_MAP VIRTUAL float 8  √  null Is this hardware virtual?
DISC_HDDS VOLUME_GROUP nvarchar 512  √  null Disk volume group
DISC_LOGICAL_DISKS VOLUMENAME nvarchar 2048  √  null Logical disk volumne name eg: default, DIAD etc
DISC_LOGICAL_DISKS VOLUMESERIALNUMBER nvarchar 2048  √  null Logical disk serial number
CAT_MANUFACTURER WEBSITE varchar 4000  √  null Manufacturer's official website
CAT_SOFTWARE_RELEASE WIN732D varchar 32  √  null The date when the software release attained Windows 7 32-bit compatibility
CAT_SOFTWARE_RELEASE WIN732ST float 8  √  null A flag to indicate the compatibilty status of the software release with regards to Windows 7 32-bit. Values: 0-7
CAT_SOFTWARE_RELEASE WIN732UP varchar 255  √  null The upgrade path for the software release to attain Windows 7 32-bit compatibility
CAT_SOFTWARE_RELEASE WIN764D varchar 32  √  null The date when the software release attained Windows 7 64-bit compatibility
CAT_SOFTWARE_RELEASE WIN764ST float 8  √  null A flag to indicate the compatibilty status of the software release with regards to Windows 7 64-bit. Values: 0-7
CAT_SOFTWARE_RELEASE WIN764UP varchar 255  √  null The upgrade path for the software release to attain Windows 7 64-bit compatibility
DISC_WINDOWS_NICS WINS_PRIMARY nvarchar 512  √  null Windows NICS windows primary
DISC_WINDOWS_NICS WINS_SECONDARY nvarchar 512  √  null Windows NICS windows secondary
MATCH_HOST_HW_PROD_MODEL CAT_HARDWARE_MODEL_ID float 8 catalog manufacturer model id for this hardware product
DISC_CDROMS CDROM_ID float 8 Unique CDROM Id
DISC_COMPUTERSYSTEM COMPUTERSYSTEM_ID float 8 Unique Computer System Id
DISC_CS_CAT_MAP COMPUTERSYSTEM_ID float 8 Computer System Id for this computer
DISC_CPUS CPU_ID float 8 Unique CPU Id
MATCH_HOST_SW_PROD disc_sw_prod_id float 8 Unique Software product id
MATCH_HOST_HW_PROD_MODEL DISCOVERED_HOST_ID float 8 Host Id for this hardware product
DISC_DISK_PARTITIONS DISKPARTITION_ID float 8 Disk partition Id
MATCH_ALL_EXE FILE_ID numeric 20 File Id
DISC_HDDS HDD_ID float 8 Hard disk Id
DISC_CONSOLE_USAGE_MAXGROUP HOST_ID varchar 100 Console Host id
DISC_CONSOLE_USER HOST_ID varchar 100 Host Id for this console
DISC_GUID HOST_ID float 8 Host Id
DISC_HOSTS HOST_ID float 8 Host Id
CAT_CPU_PRODUCT ID float 8 CAT_CPU_PRODUCT table's unique identifier
CAT_HARDWARE_MODEL ID float 8 CAT_HARDWARE_MODEL table's unique identifier
CAT_HARDWARE_PRODUCT ID float 8 CAT_HARDWARE_PRODUCT table's unique identifier
CAT_HW_MODEL_PROFILE ID float 8 CAT_HW_MODEL_PROFILE table's unique identifier
CAT_MANUFACTURER ID float 8 CAT_MANUFACTURER table's unique identifier
CAT_SOFTWARE ID float 8 CAT_SOFTWARE table's unique identifier
CAT_SOFTWARE_EDITION ID float 8 CAT_SOFTWARE_EDITION table's unique identifier
CAT_SOFTWARE_RELEASE ID float 8 CAT_SOFTWARE_RELEASE table's unique identifier
CAT_SOFTWARE_VERSION ID float 8 CAT_SOFTWARE_VERSION table's unique identifier
CAT_SUPPORT_POLICY ID float 8 CAT_SUPPORT_POLICY table's unque identifier
CAT_SUPPORT_STAGE ID float 8 CAT_SUPPORT_STAGE table unique's identifier
CAT_SW_REL_PLATFORM ID float 8 CAT_SW_REL_PLATFORM table's unique identifier
CAT_SW_REL_SUPP_STAGE ID float 8 CAT_SW_REL_SUPP_STAGE table's unique identifier
CAT_SW_VERSION_GROUP ID float 8 CAT_SW_VERSION_GROUP table's unique identifier
CAT_TAXONOMY ID float 8 Category 2 ID
CAT_TECHNOPEDIA_VERSIONS ID numeric 40 CAT_TECHNOPEDIA_VERSIONS table's unique identifier
DISC_CONSOLE_USER ID float 8 Unique Console user Id
MATCH_HOST_SW_PROD_DET ID float 8 Unique Software product id
MATCH_SOFTWARE_METERING ID float 8 Unique sofware metering Id
DISC_ALL_OS INVENTORY_ID float 8 Inventory Id for this row
DISC_CDROMS INVENTORY_ID float 8 Inventory Id for this row
DISC_COMPUTERSYSTEM INVENTORY_ID float 8 Inventory Id for this row
DISC_CONSOLE_USAGE_MAXGROUP INVENTORY_ID float 8 Inventory Id for this row
DISC_CONSOLE_USER INVENTORY_ID float 8 Inventory Id for this row
DISC_CPUS INVENTORY_ID float 8 Inventory Id for this row
DISC_CS_CAT_MAP INVENTORY_ID float 8 Inventory Id for this row
DISC_DISK_PARTITIONS INVENTORY_ID float 8 Inventory Id for this row
DISC_GUID INVENTORY_ID float 8 Inventory Id for this row
DISC_HDDS INVENTORY_ID float 8 Inventory Id for this row
DISC_HOSTS INVENTORY_ID float 8 Inventory Id for this row
DISC_LOGICAL_DISKS INVENTORY_ID float 8 Inventory Id for this row
DISC_OS_CAT_MAP INVENTORY_ID float 8 Inventory Id for this row
DISC_VIDEO_CONTROLLERS INVENTORY_ID float 8 Inventory Id for this row
DISC_WINDOWS_MONITORS INVENTORY_ID float 8 Inventory Id for this row
DISC_WINDOWS_NICS INVENTORY_ID float 8 Inventory Id for this row
DISC_WINDOWS_SERVICES INVENTORY_ID float 8 Inventory Id for this row
MATCH_ALL_ADDREMOVE INVENTORY_ID float 8 Inventory Id for this row
MATCH_ALL_EXE INVENTORY_ID float 8 Inventory Id for this row
MATCH_HOST_HW_PROD_MODEL INVENTORY_ID float 8 Inventory Id for this row
MATCH_INVENTORY INVENTORY_ID float 8 Inventory Id
MATCH_SOFTWARE_METERING INVENTORY_ID float 8 Inventory Id for this row
MATCH_STATS INVENTORY_ID float 8 Inventory Id for this statistics
DISC_LOGICAL_DISKS LOGICALDISK_ID float 8 Logical disck Id
CAT_HARDWARE_LIFECYCLE MODEL_ID float 8 Hardware model's unique identifier
DISC_WINDOWS_MONITORS MONITOR_ID float 8 Unique monitor Id
DISC_WINDOWS_NICS NIC_ID float 8 Windows NICS Id
DISC_CONSOLE_USER NUM_CONSOLE_LOGONS float 8 Number of logins for this console
DISC_ALL_OS OPERATINGSYSTEM_ID float 8 Unique Operating System id
DISC_CONSOLE_USAGE_MAXGROUP OPERATINGSYSTEM_ID float 8 Console Operating System Id
DISC_CONSOLE_USER OPERATINGSYSTEM_ID float 8 Operating System Id for this console
DISC_OS_CAT_MAP OPERATINGSYSTEM_ID float 8 Operating System Id for the opearting sytem
CAT_SOFTWARE_LIFECYCLE RELEASE_ID float 8 Software release's unique identifier
DISC_WINDOWS_SERVICES SERVICE_ID float 8 Unique service Id
DISC_CONSOLE_USER SYSTEM_CONSOLE_USER varchar 500 system console user
DISC_ALL_OS TASK_ID float 8 Task Id for this row
DISC_CDROMS TASK_ID float 8 Task Id for this row
DISC_COMPUTERSYSTEM TASK_ID float 8 Task Id for this row
DISC_CONSOLE_USAGE_MAXGROUP TASK_ID float 8 Task Id for this row
DISC_CONSOLE_USER TASK_ID float 8 Task Id for this row
DISC_CPUS TASK_ID float 8 Task Id for this row
DISC_CS_CAT_MAP TASK_ID float 8 Task Id for this row
DISC_DISK_PARTITIONS TASK_ID float 8 Task Id for this row
DISC_GUID TASK_ID float 8 Task Id for this row
DISC_HDDS TASK_ID float 8 Task Id for this row
DISC_HOSTS TASK_ID float 8 Task Id for this row
DISC_LOGICAL_DISKS TASK_ID float 8 Task Id for this row
DISC_OS_CAT_MAP TASK_ID float 8 Task Id for this row
DISC_VIDEO_CONTROLLERS TASK_ID float 8 Task Id for this row
DISC_WINDOWS_MONITORS TASK_ID float 8 Task Id for this row
DISC_WINDOWS_NICS TASK_ID float 8 Task Id for this row
DISC_WINDOWS_SERVICES TASK_ID float 8 Task Id for this row
MATCH_ALL_ADDREMOVE TASK_ID float 8 Task Id for this row
MATCH_ALL_EXE TASK_ID float 8 Task Id for this row
MATCH_HOST_HW_PROD_MODEL TASK_ID float 8 Task Id for this row
MATCH_SOFTWARE_METERING TASK_ID float 8 Task Id for this row
MATCH_STATS TASK_ID float 8 Task Id for this statistics
MATCH_TASK_DET TASK_ID float 8 Task Id for this task
DISC_CONSOLE_USAGE_MAXGROUP TOP_CONSOLE_USER varchar 500 Top users userid for this Console
DISC_CONSOLE_USER TOTAL_USER_CONSOLE_MINS float 8 Total time in minutes for the user on this console
MATCH_STATS TYPE varchar 10 Statistics type eg: Add/Remove, EXE
DISC_VIDEO_CONTROLLERS VIDEOCONTROLLER_ID float 8 Video controller Id