BDNA_PUBLISH.dbo contains 617 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
bdna_logger_tb	db_name	nvarchar	200	√		null	Database name user for the task
bdna_logger_tb	event_timestamp	datetime	16,3	√		(getdate())	Timestamp for the task event
bdna_logger_tb	message	nvarchar	8000	√		null	Message for the task event
bdna_logger_tb	os_user	nvarchar	200	√		null	Username for the task
CAT_CPU_PRODUCT	CORES	float	8	√		null	Number of cores per- CPU chip
CAT_CPU_PRODUCT	ID	float	8				CAT_CPU_PRODUCT table's unique identifier
CAT_CPU_PRODUCT	LABEL	varchar	255	√		null	CPU model (which includes model number, speed/clock rate, and code name if applicable)
CAT_CPU_PRODUCT	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_CPU_PRODUCT	MANUFACTURER_ID	float	8	√		null	CPU manufacturer
CAT_CPU_PRODUCT	THREADED	varchar	16	√		null	A flag to indicate whether the CPU supports multithreading or not
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_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_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
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_HARDWARE_LIFECYCLE	MODEL_ID	float	8				Hardware model's unique identifier
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_HARDWARE_LIFECYCLE	OBSOLETE_STR	varchar	30	√		null
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)
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_HARDWARE_MODEL	DATE_INTRODUCED	varchar	30	√		null	The date the hardware was introduced/announced, captured the way it was published by the vendor
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)
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_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
CAT_HARDWARE_MODEL	HW_PRODUCT_ID	float	8	√		null	Hardware product's unique identifier
CAT_HARDWARE_MODEL	ID	float	8				CAT_HARDWARE_MODEL table's unique identifier
CAT_HARDWARE_MODEL	LABEL	varchar	2000	√		null	The device's model name/number
CAT_HARDWARE_MODEL	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
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.
CAT_HARDWARE_MODEL	MANUFACTURER_ID	float	8	√		null	Manufacturer's unique identifier
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_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_HARDWARE_MODEL	POWER_RATING	varchar	256	√		null	Summary of the device's various power ratings: Voltage, Frequency, Current
CAT_HARDWARE_MODEL	SUPPORTED_OS	varchar	2000	√		null	The list of supported operating systems that can be run on the device
CAT_HARDWARE_MODEL	TAXONOMY_ID	float	8	√		null	BDNA Taxonomy's unique identifier
CAT_HARDWARE_PRODUCT	ID	float	8				CAT_HARDWARE_PRODUCT table's unique identifier
CAT_HARDWARE_PRODUCT	LABEL	varchar	255	√		null	Hardware product name
CAT_HARDWARE_PRODUCT	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_HARDWARE_PRODUCT	MANUFACTURER_ID	float	8	√		null	Manufacturer's unique identifier
CAT_HARDWARE_PRODUCT	TAXONOMY_ID	float	8	√		null	BDNA Taxonomy's unique identifier
CAT_HW_MODEL_PROFILE	HW_MODEL_ID	float	8	√		null	Hardware model's unique identifier
CAT_HW_MODEL_PROFILE	HW_PRODUCT_ID	float	8	√		null	Hardware product's unique identifier
CAT_HW_MODEL_PROFILE	ID	float	8				CAT_HW_MODEL_PROFILE table's unique identifier
CAT_HW_MODEL_PROFILE	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_HW_MODEL_PROFILE	MANUFACTURER_ID	float	8	√		null	Manufacturer's unique identifier
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_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)
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_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)
CAT_HW_MODEL_PROFILE	PROFILE	varchar	60	√		null	Profile (or form factor) of the device
CAT_HW_MODEL_PROFILE	TAXONOMY_ID	float	8	√		null	BDNA Taxonomy's unique identifier
CAT_MANUFACTURER	CITY	varchar	256	√		null	The city where the manufacturer is based in (usually where the headquarter is located)
CAT_MANUFACTURER	COUNTRY	varchar	256	√		null	The country where the manufacturer is based in (usually where the headquarter is located)
CAT_MANUFACTURER	DATE_ACQUIRED	varchar	60	√		null	The date the manufacturer being acquired (if applicable)
CAT_MANUFACTURER	DESCRIPTION	varchar	1024	√		null	Short description of the manufacturer
CAT_MANUFACTURER	EMAIL	varchar	256	√		null	Manufacturer's email address
CAT_MANUFACTURER	FAX	varchar	64	√		null	Manufacturer's fax number
CAT_MANUFACTURER	ID	float	8				CAT_MANUFACTURER table's unique identifier
CAT_MANUFACTURER	LABEL	varchar	2000	√		null	Manufacturer name (as obtained from the official website), minus the legal entity
CAT_MANUFACTURER	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_MANUFACTURER	LEGAL	varchar	64	√		null	Legal entity of the company (e.g. Corporation, Limited, etc.)
CAT_MANUFACTURER	OWNER_ID	float	8	√		null	Manufacturer owner's unique identifier
CAT_MANUFACTURER	PHONE	varchar	64	√		null	Manufacturer's telephone number
CAT_MANUFACTURER	REVENUE	float	8	√		null	The latest annual revenue (in millions of USD)
CAT_MANUFACTURER	SYMBOL	varchar	16	√		null	The company's stock/ticker symbol (if it's publicly traded)
CAT_MANUFACTURER	TIER	float	8	√		null	Categorization of manufacturers based on priority/importance
CAT_MANUFACTURER	WEBSITE	varchar	4000	√		null	Manufacturer's official website
CAT_SOFTWARE	ALIAS	varchar	255	√		null	Former/older name the software product was also known as
CAT_SOFTWARE	COMPONENT	varchar	64	√		null	The component of the software product (if applicable)
CAT_SOFTWARE	FAMILY	varchar	255	√		null	Brand/family in which the software product belongs to (if applicable)
CAT_SOFTWARE	ID	float	8				CAT_SOFTWARE table's unique identifier
CAT_SOFTWARE	LABEL	varchar	2000	√		null	The name of the software product
CAT_SOFTWARE	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SOFTWARE	MANUFACTURER_ID	float	8	√		null	Manufacturer's unique identifier
CAT_SOFTWARE	PLICSABLE	float	8	√		null	A flag to indicate whether the software product is licensable or not
CAT_SOFTWARE	SUITE	float	8	√		null	A flag to indicate whether the software product is a suite or not
CAT_SOFTWARE	TAXONOMY_ID	float	8	√		null	BDNA Taxonomy's unique identifier
CAT_SOFTWARE_EDITION	ID	float	8				CAT_SOFTWARE_EDITION table's unique identifier
CAT_SOFTWARE_EDITION	LABEL	varchar	2000	√		null	Software product's edition name
CAT_SOFTWARE_EDITION	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SOFTWARE_EDITION	PRODUCT_ID	float	8	√		null	Software product's unique identifier
CAT_SOFTWARE_EDITION	TAXONOMY_ID	float	8	√		null	BDNA Taxonomy's unique identifier
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_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_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_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
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
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
CAT_SOFTWARE_LIFECYCLE	RELEASE_ID	float	8				Software release's unique identifier
CAT_SOFTWARE_RELEASE	EDITION_ID	float	8	√		null	Software edition's unique identifier
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
CAT_SOFTWARE_RELEASE	ID	float	8				CAT_SOFTWARE_RELEASE table's unique identifier
CAT_SOFTWARE_RELEASE	LABEL	varchar	2000	√		null	Software product's unique identifier
CAT_SOFTWARE_RELEASE	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SOFTWARE_RELEASE	LICENSABLE	varchar	16	√		null	A flag to indicate whether the software release is licensable or not
CAT_SOFTWARE_RELEASE	MANUFACTURER_ID	float	8	√		null	Manufacturer's unique identifier
CAT_SOFTWARE_RELEASE	PATCHLEVEL	varchar	255	√		null	The name of patch level for the software release
CAT_SOFTWARE_RELEASE	PRODUCT_ID	float	8	√		null	Software product's unique identifier
CAT_SOFTWARE_RELEASE	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
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
CAT_SOFTWARE_VERSION	ID	float	8				CAT_SOFTWARE_VERSION table's unique identifier
CAT_SOFTWARE_VERSION	LABEL	varchar	64	√		null	Software patch's name/number
CAT_SOFTWARE_VERSION	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SOFTWARE_VERSION	PATCHLEVEL	varchar	64	√		null	Software Subversion (BDNA Internal column)
CAT_SOFTWARE_VERSION	PRODUCT_ID	float	8	√		null	Software product's unique identifier
CAT_SOFTWARE_VERSION	SUBVERSION	varchar	60	√		null	Software patch's level (Critical or Optional)
CAT_SOFTWARE_VERSION	VERSION_GROUP_ID	float	8	√		null	Software version group's unique identifier
CAT_SUPPORT_POLICY	ID	float	8				CAT_SUPPORT_POLICY table's unque identifier
CAT_SUPPORT_POLICY	LABEL	varchar	60	√		null	The name of the support policy, captured the way it was published by the vendor
CAT_SUPPORT_POLICY	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SUPPORT_POLICY	MANUFACTURER_ID	float	8	√		null	Manufacturer's unique identifier
CAT_SUPPORT_STAGE	ID	float	8				CAT_SUPPORT_STAGE table unique's identifier
CAT_SUPPORT_STAGE	LABEL	varchar	60	√		null	The name of the support stage/level, captured the way it was published by the vendor
CAT_SUPPORT_STAGE	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SUPPORT_STAGE	STAGEORDER	float	8	√		null	The order the support stage/level
CAT_SUPPORT_STAGE	SUPPORT_POLICY_ID	float	8	√		null	Support policy's unique identifier
CAT_SW_REL_PLATFORM	ID	float	8				CAT_SW_REL_PLATFORM table's unique identifier
CAT_SW_REL_PLATFORM	LABEL	varchar	2000	√		null	Software release's platform name
CAT_SW_REL_PLATFORM	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SW_REL_PLATFORM	PLATFORM_LABEL	varchar	255	√		null	The name of platform supported by the software release
CAT_SW_REL_PLATFORM	RELEASE_ID	float	8	√		null	Software release's unique identifier
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_SW_REL_SUPP_STAGE	ID	float	8				CAT_SW_REL_SUPP_STAGE table's unique identifier
CAT_SW_REL_SUPP_STAGE	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
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
CAT_SW_REL_SUPP_STAGE	RELEASE_ID	float	8	√		null	Software release's unique identifier
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_SW_REL_SUPP_STAGE	STAGEORDER	float	8	√		null	The order the support stage/level
CAT_SW_REL_SUPP_STAGE	SUPPORT_STAGE_ID	float	8	√		null	Software support stage's unique identifier
CAT_SW_VERSION_GROUP	ID	float	8				CAT_SW_VERSION_GROUP table's unique identifier
CAT_SW_VERSION_GROUP	LABEL	varchar	64	√		null	The name of version group (or market version) of the software product
CAT_SW_VERSION_GROUP	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date when last modification on the row was made
CAT_SW_VERSION_GROUP	PRODUCT_ID	float	8	√		null	Software product's unique identifier
CAT_TAXONOMY	DESCRIPTION	varchar	256	√		null	Short description of the category
CAT_TAXONOMY	ID	float	8				Category 2 ID
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_TAXONOMY	PARENT_ID	float	8	√		null	Category 1 ID
CAT_TECHNOPEDIA_VERSIONS	ID	numeric	40				CAT_TECHNOPEDIA_VERSIONS table's unique identifier
CAT_TECHNOPEDIA_VERSIONS	LAST_MODIFIED_DATE	datetime	16,3	√		null	The date the Technopedia Version's entry was last modified
CAT_TECHNOPEDIA_VERSIONS	LEGAL	nvarchar	8000	√		null	Legal verbage (copyright information)
CAT_TECHNOPEDIA_VERSIONS	NAME	numeric	40	√		null	CAT_TECHNOPEDIA_VERSIONS table's unique identifier
CAT_TECHNOPEDIA_VERSIONS	RELDATE	datetime	16,3	√		null	Technopedia's release date
CAT_TECHNOPEDIA_VERSIONS	RELORDER	numeric	40	√		null	Technopedia releases' order, where 1 equals Release 2.0, and so on
CAT_TECHNOPEDIA_VERSIONS	VERSION	nvarchar	128	√		null	Technopedia's version number
DISC_ALL_OS	ACTIVE	nvarchar	2048	√		null	Is this system active?
DISC_ALL_OS	CPU_SPEED	float	8	√		null	CPU Speed
DISC_ALL_OS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_ALL_OS	EDITION	nvarchar	512	√		null	Operating System Edition eg: Professional,Standard (32-bit x86)
DISC_ALL_OS	HARDWARE	nvarchar	512	√		null	Hardware information eg: Dell Inc. Latitude D620, Compaq ProLiant DL580 G2
DISC_ALL_OS	HOST_ID	float	8	√		null	Unique host Id
DISC_ALL_OS	HOSTNAME	nvarchar	2048	√		null	Host Name
DISC_ALL_OS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_ALL_OS	LASTLOGON	nvarchar	512	√		null	Last logon information eg: januta01,mowdam01a
DISC_ALL_OS	LEVEL2	char	1	√		null	Level2
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_ALL_OS	MANUFACTURER	nvarchar	512	√		null	Operating System Manufacturer name
DISC_ALL_OS	NUMCPUS	float	8	√		null	Number of CPUS
DISC_ALL_OS	OPERATINGSYSTEM_ID	float	8				Unique 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)
DISC_ALL_OS	OS_FAMILY	nvarchar	512	√		null	Operating System Family eg: Windows, Linux
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
DISC_ALL_OS	PATCHLEVEL	nvarchar	512	√		null	Patch Level eg: Service Pack 2
DISC_ALL_OS	SCANDATE	datetime	16,3	√		null	Last Scan Date
DISC_ALL_OS	SERIALNUMBER	nvarchar	512	√		null	Serial number
DISC_ALL_OS	TASK_ID	float	8				Task Id for this row
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
DISC_ALL_OS	UPTIME	float	8	√		null	Total uptime
DISC_ALL_OS	VERSION	nvarchar	512	√		null	Operating System version eg: 5.1.2600, 5.2.3790
DISC_CDROMS	CDROM_ID	float	8				Unique CDROM Id
DISC_CDROMS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_CDROMS	DRIVE	nvarchar	512	√		null	CDROM drive eg: E:, D:
DISC_CDROMS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_CDROMS	MANUFACTURER	nvarchar	512	√		null	CDROM Manufacturer
DISC_CDROMS	MODEL	nvarchar	2048	√		null	CDROM Model
DISC_CDROMS	NAME	nvarchar	512	√		null	CDROM Name
DISC_CDROMS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id
DISC_CDROMS	SERIALNUMBER	nvarchar	512	√		null	CDROM Serial Number
DISC_CDROMS	TASK_ID	float	8				Task Id for this row
DISC_COMPUTERSYSTEM	COMPUTERSYSTEM_ID	float	8				Unique Computer System Id
DISC_COMPUTERSYSTEM	DATASRC	varchar	100	√		null	Data Source for this row eg: SCCM, ADDM
DISC_COMPUTERSYSTEM	DOMAIN	varchar	1024	√		null	Domain for this Compueter System
DISC_COMPUTERSYSTEM	HOSTNAME	varchar	1024	√		null	Host name for this system
DISC_COMPUTERSYSTEM	INVENTORY_ID	float	8				Inventory Id for this row
DISC_COMPUTERSYSTEM	MANUFACTURER	varchar	1024	√		null	Manufacturer eg:Dell Inc., Compaq
DISC_COMPUTERSYSTEM	MODEL	varchar	1024	√		null	Manufuacturer eg: Latitude D620,ProLiant BL465c G5
DISC_COMPUTERSYSTEM	TASK_ID	float	8				Task Id for this row
DISC_CONSOLE_USAGE_MAXGROUP	HOST_ID	varchar	100				Console Host id
DISC_CONSOLE_USAGE_MAXGROUP	INVENTORY_ID	float	8				Inventory Id for this row
DISC_CONSOLE_USAGE_MAXGROUP	OPERATINGSYSTEM_ID	float	8				Console Operating System Id
DISC_CONSOLE_USAGE_MAXGROUP	SECURITY_LOG_START_DATE	varchar	1024	√		null	Security log start date
DISC_CONSOLE_USAGE_MAXGROUP	TASK_ID	float	8				Task Id for this row
DISC_CONSOLE_USAGE_MAXGROUP	TOP_CONSOLE_USER	varchar	500				Top users userid for this Console
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_CONSOLE_USER	DOMAIN	varchar	1024	√		null	Domain the console belongs to
DISC_CONSOLE_USER	HOST_ID	varchar	100				Host Id for this console
DISC_CONSOLE_USER	ID	float	8				Unique Console user Id
DISC_CONSOLE_USER	INVENTORY_ID	float	8				Inventory Id for this row
DISC_CONSOLE_USER	LASTCONSOLEUSE_TIME	datetime	16,3	√		null	Timestamp when console was used last time
DISC_CONSOLE_USER	NUM_CONSOLE_LOGONS	float	8				Number of logins for this console
DISC_CONSOLE_USER	OPERATINGSYSTEM_ID	float	8				Operating System Id for this console
DISC_CONSOLE_USER	SYSTEM_CONSOLE_USER	varchar	500				system console user
DISC_CONSOLE_USER	TASK_ID	float	8				Task Id for this row
DISC_CONSOLE_USER	TIMESTAMP	datetime	16,3	√		null	Timestamp
DISC_CONSOLE_USER	TOTAL_USER_CONSOLE_MINS	float	8				Total time in minutes for the user on this console
DISC_CPUS	BITS	float	8	√		null	CPU bits
DISC_CPUS	CAT_CPU_ID	float	8	√		null	CPU Id from the catalog
DISC_CPUS	CORES	float	8	√		null	Number of CPU cores
DISC_CPUS	CPU_ID	float	8				Unique CPU Id
DISC_CPUS	CPU_LABEL	nvarchar	512	√		null	CPU Label eg:CPU0,CPU2,CPU3
DISC_CPUS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_CPUS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_CPUS	ISA	nvarchar	8000	√		null	CPU ISA (instruction set architecture)
DISC_CPUS	MANUFACTURER	nvarchar	512	√		null	Manufacturer for this CPU eg:GenuineIntel,AuthenticAMD
DISC_CPUS	MAXSPEED	float	8	√		null	Maximum CPU speed
DISC_CPUS	MODEL	nvarchar	512	√		null	CPU Model eg: Genuine Intel(R) CPU T2500 @ 2.00GHz
DISC_CPUS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id for this console
DISC_CPUS	SOCKETDESIGNATION	nvarchar	512	√		null	Socket designation eg:Microprocessor,Socket M2,Proc 3
DISC_CPUS	SPEED	float	8	√		null	CPU speed
DISC_CPUS	TASK_ID	float	8				Task Id for this row
DISC_CPUS	THREADS	float	8	√		null	Number of CPU threads
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
DISC_CS_CAT_MAP	CAT_HW_PROFILE_ID	float	8	√		null	Hardware profile Id from the catalog
DISC_CS_CAT_MAP	CAT_MANUFACTURER_ID	float	8	√		null	Manufacturer Id from the catalog
DISC_CS_CAT_MAP	CAT_TAXONOMY_ID	float	8	√		null	Taxonomy Id from the catalog
DISC_CS_CAT_MAP	COMPUTERSYSTEM_ID	float	8				Computer System Id for this computer
DISC_CS_CAT_MAP	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_CS_CAT_MAP	INVENTORY_ID	float	8				Inventory Id for this row
DISC_CS_CAT_MAP	TASK_ID	float	8				Task Id for this row
DISC_CS_CAT_MAP	VIRTUAL	float	8	√		null	Is this hardware virtual?
DISC_DISK_PARTITIONS	BOOTPARTITION	float	8	√		null	Boot partition eg: 1, 0
DISC_DISK_PARTITIONS	CAPACITY	float	8	√		null	Disk capacity
DISC_DISK_PARTITIONS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_DISK_PARTITIONS	DESCRIPTION	nvarchar	2048	√		null	Disk partition description eg: Installable File System, Installable File System
DISC_DISK_PARTITIONS	DEVICEID	nvarchar	2048	√		null	Divice Id eg:Disk #0, Partition #0, Disk #13, Partition #0 etc
DISC_DISK_PARTITIONS	DISKPARTITION_ID	float	8				Disk partition Id
DISC_DISK_PARTITIONS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_DISK_PARTITIONS	NAME	nvarchar	512	√		null	Disk partition Name eg: Disk #0, Partition #0
DISC_DISK_PARTITIONS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id for this disk
DISC_DISK_PARTITIONS	PRIMARYPARTITION	float	8	√		null	Primary partition ? eg 1 = yes, 0 = no
DISC_DISK_PARTITIONS	TASK_ID	float	8				Task Id for this row
DISC_GUID	GUID	nvarchar	2048	√		null	GUID for the host
DISC_GUID	HOST_ID	float	8				Host Id
DISC_GUID	INVENTORY_ID	float	8				Inventory Id for this row
DISC_GUID	TASK_ID	float	8				Task Id for this row
DISC_HDDS	CAPACITY	nvarchar	512	√		null	Disk capacity
DISC_HDDS	CONNECTIONLOCATION	nvarchar	512	√		null	Disk connection location
DISC_HDDS	CONNECTIONTYPE	nvarchar	512	√		null	Connection type eg: SCSI, IDE
DISC_HDDS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_HDDS	DEVICENAME	nvarchar	512	√		null	Device Name eg: Disk drive \\.\PHYSICALDRIVE8
DISC_HDDS	HDD_ID	float	8				Hard disk Id
DISC_HDDS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_HDDS	MANUFACTURER	nvarchar	512	√		null	Disk Manufcaturer
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_HDDS	NUMPARTITIONS	float	8	√		null	Number of partitions on the disk
DISC_HDDS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id for this disk
DISC_HDDS	PHYSICALVOLUME_STATE	nvarchar	512	√		null	Disk physical volume
DISC_HDDS	PNPDEVICEID	nvarchar	2048	√		null	PNP device Id
DISC_HDDS	SERIALNUMBER	nvarchar	512	√		null	Disk serial number
DISC_HDDS	TASK_ID	float	8				Task Id for this row
DISC_HDDS	VOLUME_GROUP	nvarchar	512	√		null	Disk volume group
DISC_HOSTS	ACTIVE	varchar	1024	√		null	Is host active? 1= yes, 0 = no
DISC_HOSTS	DATASRC	varchar	25	√		null	Data Source for this row eg: SCCM, ADDM
DISC_HOSTS	DOMAIN	varchar	1024	√		null	Domain of the host
DISC_HOSTS	HOST_ID	float	8				Host Id
DISC_HOSTS	HOSTNAME	varchar	1024	√		null	Host name
DISC_HOSTS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_HOSTS	OBSOLETE	varchar	1024	√		null	Is host obsolete? 1= yes, 0= no
DISC_HOSTS	TASK_ID	float	8				Task Id for this row
DISC_LOGICAL_DISKS	AVAILABLECAPACITY	float	8	√		null	Logical disk available 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
DISC_LOGICAL_DISKS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_LOGICAL_DISKS	DESCRIPTION	nvarchar	2048	√		null	Logical disk description eg: CD-ROM Disc, Local Fixed Disk etc
DISC_LOGICAL_DISKS	FILESYSTEM	nvarchar	2048	√		null	Logical disk File system eg: NTFS
DISC_LOGICAL_DISKS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_LOGICAL_DISKS	ISLOCAL	nvarchar	200	√		null	Is Logical disk local? eg: local
DISC_LOGICAL_DISKS	LOGICALDISK_ID	float	8				Logical disck Id
DISC_LOGICAL_DISKS	LOGICALDISK_LABEL	nvarchar	2048	√		null	Logical disk label eg: D:, A:
DISC_LOGICAL_DISKS	MOUNTPOINT	nvarchar	200	√		null	Logical disk mount point eg: D:, C: etc
DISC_LOGICAL_DISKS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id for the logical disk
DISC_LOGICAL_DISKS	PERCENTUTILIZED	float	8	√		null	Logical disk percentage utilized
DISC_LOGICAL_DISKS	TASK_ID	float	8				Task Id for this row
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
DISC_OS_CAT_MAP	CAT_MANUFACTURER_ID	float	8	√		null	Manufactuer id from Catalog
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
DISC_OS_CAT_MAP	CAT_TAXONOMY_ID	float	8	√		null	software taxonomy Id from Catalog
DISC_OS_CAT_MAP	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_OS_CAT_MAP	INVENTORY_ID	float	8				Inventory Id for this row
DISC_OS_CAT_MAP	OPERATINGSYSTEM_ID	float	8				Operating System Id for the opearting sytem
DISC_OS_CAT_MAP	TASK_ID	float	8				Task Id for this row
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
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_VIDEO_CONTROLLERS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_VIDEO_CONTROLLERS	DESCRIPTION	nvarchar	2048	√		null	Video controller description
DISC_VIDEO_CONTROLLERS	DEVICEID	nvarchar	2048	√		null	Video controller device Id
DISC_VIDEO_CONTROLLERS	DRIVERDATE	datetime	16,3	√		null	Video controller driver date
DISC_VIDEO_CONTROLLERS	DRIVERVERSION	nvarchar	512	√		null	Video controller driver version
DISC_VIDEO_CONTROLLERS	INSTALLEDDISPLAYDRIVERS	nvarchar	2048	√		null	Video controller installed display dirvers eg:nv4_disp.dll,igdumdx32.dll,igd10umd32.dll etc
DISC_VIDEO_CONTROLLERS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_VIDEO_CONTROLLERS	NAME	nvarchar	1024	√		null	Video controller name
DISC_VIDEO_CONTROLLERS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id for this video controller
DISC_VIDEO_CONTROLLERS	TASK_ID	float	8				Task Id for this row
DISC_VIDEO_CONTROLLERS	VIDEOCONTROLLER_ID	float	8				Video controller Id
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_WINDOWS_MONITORS	AVAILABILITY	nvarchar	512	√		null	Monitor availability
DISC_WINDOWS_MONITORS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_WINDOWS_MONITORS	EDID_VERSION	nvarchar	512	√		null	Monitor EDID(Extended Display Identification Data) version
DISC_WINDOWS_MONITORS	GAMMA_VALUE	nvarchar	512	√		null	Monitor Gamma value
DISC_WINDOWS_MONITORS	HARDWARE_NUMBER	nvarchar	512	√		null	Monitor hardware number
DISC_WINDOWS_MONITORS	INPUT_SIGNAL	nvarchar	512	√		null	Monitor input signal
DISC_WINDOWS_MONITORS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_WINDOWS_MONITORS	MANUF_DATE	nvarchar	512	√		null	Monitor manufacture date
DISC_WINDOWS_MONITORS	MANUFACTURER	nvarchar	512	√		null	Monitor manufacturer
DISC_WINDOWS_MONITORS	MODEL_NAME	nvarchar	512	√		null	Monitor name
DISC_WINDOWS_MONITORS	MONITOR_ID	float	8				Unique monitor Id
DISC_WINDOWS_MONITORS	MONITOR_TYPE	nvarchar	512	√		null	Monitor type eg: Default Monitor, Generic PnP Monitor
DISC_WINDOWS_MONITORS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id for this monitor
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
DISC_WINDOWS_MONITORS	POWERSAVING_MGMT	nvarchar	512	√		null	Monitor power saving management
DISC_WINDOWS_MONITORS	PRODUCT_ID	nvarchar	512	√		null	Monitor product Id
DISC_WINDOWS_MONITORS	SCREEN_HEIGHT	float	8	√		null	Monitor screen height
DISC_WINDOWS_MONITORS	SCREEN_WIDTH	float	8	√		null	Monitor screen width
DISC_WINDOWS_MONITORS	TASK_ID	float	8				Task Id for this row
DISC_WINDOWS_NICS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_WINDOWS_NICS	DEFAULT_ROUTE	nvarchar	512	√		null	Windows NICS default route eg: 192.168.1.1 etc
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
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_WINDOWS_NICS	INVENTORY_ID	float	8				Inventory Id for this row
DISC_WINDOWS_NICS	IP_ADDRESS	nvarchar	512	√		null	Windows NICS IP address
DISC_WINDOWS_NICS	MACADDRESS	nvarchar	512	√		null	Windows NIC MAC address
DISC_WINDOWS_NICS	NETWORK_MASK	nvarchar	512	√		null	Windows NICS netword mask eg: 255.255.255.0
DISC_WINDOWS_NICS	NIC_ID	float	8				Windows NICS Id
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
DISC_WINDOWS_NICS	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id
DISC_WINDOWS_NICS	PNP_DEVICEID	nvarchar	512	√		null	Windows NICS PNP device Id
DISC_WINDOWS_NICS	TASK_ID	float	8				Task Id for this row
DISC_WINDOWS_NICS	WINS_PRIMARY	nvarchar	512	√		null	Windows NICS windows primary
DISC_WINDOWS_NICS	WINS_SECONDARY	nvarchar	512	√		null	Windows NICS windows secondary
DISC_WINDOWS_SERVICES	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
DISC_WINDOWS_SERVICES	DISPLAY_NAME	nvarchar	2048	√		null	Windows service display name eg: Application Layer Gateway Service, ClipBook
DISC_WINDOWS_SERVICES	EXE_PATH	nvarchar	8000	√		null	Windows service exe path eg: C:\WINDOWS\System32\alg.exe
DISC_WINDOWS_SERVICES	INVENTORY_ID	float	8				Inventory Id for this row
DISC_WINDOWS_SERVICES	IS_DESKTOP_INTERACT	nvarchar	512	√		null	Allow service to interact with desktop?
DISC_WINDOWS_SERVICES	OPERATINGSYSTEM_ID	float	8	√		null	Operating System Id
DISC_WINDOWS_SERVICES	SERVICE_ID	float	8				Unique service Id
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_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
DISC_WINDOWS_SERVICES	TASK_ID	float	8				Task Id for this row
MATCH_ALL_ADDREMOVE	CATEGORY	varchar	10	√		null	Category eg: Mapped,Irrelevant,UnKnown
MATCH_ALL_ADDREMOVE	DISPLAY_NAME	varchar	1024	√		null	Display name for addremove eg: Mobile Broadband Drivers,PGP Desktop
MATCH_ALL_ADDREMOVE	GUID	varchar	1024	√		null	GUID id from this addremove eg: {18C71DD4-0147-4318-8689-AE836278FBFE}
MATCH_ALL_ADDREMOVE	INVENTORY_ID	float	8				Inventory Id for this row
MATCH_ALL_ADDREMOVE	PUBLISHER	varchar	1024	√		null	Publisher for addremove eg: Core Services ,Trend Micro
MATCH_ALL_ADDREMOVE	REASONS	varchar	1024	√		null	Reasons for addremove
MATCH_ALL_ADDREMOVE	TASK_ID	float	8				Task Id for this row
MATCH_ALL_ADDREMOVE	UNKNOWN_INSTANCES	numeric	20	√		null
MATCH_ALL_ADDREMOVE	VERSION	varchar	1024	√		null	Addremove version eg: 1.5.3, 5.10.4803.0
MATCH_ALL_EXE	CATEGORY	varchar	10	√		null	Category eg: Mapped,Irrelevant,UnKnown
MATCH_ALL_EXE	COMPANY_NAME	varchar	1024	√		null	company name eg: Cisco Systems, Inc.
MATCH_ALL_EXE	FILE_DESCRIPTION	varchar	2000	√		null	File description eg: AvExtractSvr Module
MATCH_ALL_EXE	FILE_ID	numeric	20				File Id
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
MATCH_ALL_EXE	INVENTORY_ID	float	8				Inventory Id for this row
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_ALL_EXE	PRODUCT_VERSION	varchar	512	√		null	Product version eg: 4.0(5)
MATCH_ALL_EXE	REASONS	varchar	1024	√		null	Reasons
MATCH_ALL_EXE	TASK_ID	float	8				Task Id for this row
MATCH_ALL_EXE	UNKNOWN_INSTANCES	numeric	20	√		null
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_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_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_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_MODEL_ID	float	8				catalog manufacturer model id for this hardware product
MATCH_HOST_HW_PROD_MODEL	CAT_HARDWARE_PRODUCT	nvarchar	510	√		null	catalog Hostname for this hardware product
MATCH_HOST_HW_PROD_MODEL	CAT_HW_PRODUCT_ID	float	8	√		null	catalog product Id for this hardware product
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_HW_PROD_MODEL	CAT_MANUFACTURER	nvarchar	4000	√		null	catalog manufacturer name for this hardware product eg: Hewlett-Packard Company
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_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_HW_PROD_MODEL	CAT_SUPPORTED_OS	nvarchar	4000	√		null	catalog supported OS for this hardware product eg: Linux, NetWare, OpenServer, Solaris, UnixWare, Windows, VMware
MATCH_HOST_HW_PROD_MODEL	CAT_TAXONOMY_CATEGORY1	nvarchar	512	√		null	Taxonomy category 1 from the catalog eg: Computers
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_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_HOST_ID	float	8				Host Id for this hardware product
MATCH_HOST_HW_PROD_MODEL	DISCOVERED_HOSTNAME	nvarchar	2048	√		null	Hostname for this hardware product
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_HW_PROD_MODEL	DISCOVERED_SERIALNUMBER	nvarchar	512	√		null	serialnumber for this hardware product
MATCH_HOST_HW_PROD_MODEL	INVENTORY_ID	float	8				Inventory Id for this row
MATCH_HOST_HW_PROD_MODEL	TASK_ID	float	8				Task Id for this row
MATCH_HOST_SW_PROD	cat_component	varchar	64	√		null	product component from the catalog for this Software product eg: Client, Server
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	cat_ga_date	varchar	60	√		null	GA date from catalog for this Software product
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_SW_PROD	cat_patchlevel	varchar	64	√		null	Patch level from the catalog for this Software product eg: SP2
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	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	cat_release_id	float	8	√		null	release Id from catalog for this Software product
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_SW_PROD	cat_taxonomy_category2	varchar	256	√		null	taxonomy category 2 from the catalog for this Software product eg: Productivity, Multimedia
MATCH_HOST_SW_PROD	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_HOST_SW_PROD	cat_version_id	float	8	√		null	version Id from catalog for this Software product
MATCH_HOST_SW_PROD	datasrc	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
MATCH_HOST_SW_PROD	disc_sw_prod_id	float	8				Unique Software product id
MATCH_HOST_SW_PROD	DISCOVERED_INSTALLDATE	datetime	16,3	√		null	Discovered installed date Software product
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	DISCOVERED_PUBLISHER	varchar	1024	√		null	Discovered publihser for this Software product eg: Adobe Systems, Inc., Ipswitch
MATCH_HOST_SW_PROD	DISCOVERED_VERSION	varchar	1024	√		null	Discovered version for this Software product eg:9.0.45.0
MATCH_HOST_SW_PROD	GROUP_ID	float	8	√		null	group Id from catalog for this Software product
MATCH_HOST_SW_PROD	HOST_ID	float	8	√		null	Host Id for this Software product
MATCH_HOST_SW_PROD	HOSTNAME	varchar	255	√		null	Host name for this Software product
MATCH_HOST_SW_PROD	INVENTORY_ID	float	8	√		null	Inventory Id for this row
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	SUITE_ID	float	8	√		null	suite Id from catalog for this Software product
MATCH_HOST_SW_PROD	TASK_ID	float	8	√		null	Task Id for this row
MATCH_HOST_SW_PROD_DET	cat_edition_id	float	8	√		null	edition 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_HOST_SW_PROD_DET	cat_publisher_id	float	8	√		null	publisher 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_HOST_SW_PROD_DET	cat_taxonomy_id	float	8	√		null	taxonomy 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_HOST_SW_PROD_DET	datasrc	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
MATCH_HOST_SW_PROD_DET	DISCOVERED_INSTALLDATE	datetime	16,3	√		null	Discovered installed date Software product
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_DET	DISCOVERED_PUBLISHER	varchar	1024	√		null	Discovered publihser for this Software product eg: Adobe Systems, Inc., Ipswitch
MATCH_HOST_SW_PROD_DET	DISCOVERED_VERSION	varchar	1024	√		null	Discovered version for this Software product eg:9.0.45.0
MATCH_HOST_SW_PROD_DET	GROUP_ID	float	8	√		null	group Id from catalog for this Software product
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
MATCH_HOST_SW_PROD_DET	HOST_ID	float	8	√		null	Host Id for this Software product
MATCH_HOST_SW_PROD_DET	HOSTNAME	varchar	255	√		null	Host name for this Software product
MATCH_HOST_SW_PROD_DET	ID	float	8				Unique Software product id
MATCH_HOST_SW_PROD_DET	INVENTORY_ID	float	8	√		null	Inventory Id for this row
MATCH_HOST_SW_PROD_DET	IS_MAPPED	char	1	√		null	Sofware product mapped? eg: Y, N
MATCH_HOST_SW_PROD_DET	IS_SUITE	char	1	√		null	Catalog information: if this software product part of suite? eg: N, Y
MATCH_HOST_SW_PROD_DET	ORIGINATE_FROM	float	8	√		null	Sofware product originate from eg: 1= Add/Remove 2= Exe 4 =OS
MATCH_HOST_SW_PROD_DET	SOURCE_BITMAP	float	8	√		null	Sofware product source bit map
MATCH_HOST_SW_PROD_DET	SUITE_ID	float	8	√		null	suite Id from catalog for this Software product
MATCH_HOST_SW_PROD_DET	TASK_ID	float	8	√		null	Task Id for this row
MATCH_INVENTORY	COMPANY_ID	float	8	√		null	Inventory company Id
MATCH_INVENTORY	COMPANY_NAME	varchar	256	√		null	Inventory company name
MATCH_INVENTORY	INVENTORY_END_DATE	datetime	16,3	√		null	Inventory end date
MATCH_INVENTORY	INVENTORY_ID	float	8				Inventory Id
MATCH_INVENTORY	INVENTORY_NAME	varchar	256	√		null	Inventory name
MATCH_INVENTORY	INVENTORY_START_DATE	datetime	16,3	√		null	Inventory start date
MATCH_SOFTWARE_METERING	CAT_EDITION_ID	float	8	√		null	edition Id from catalog
MATCH_SOFTWARE_METERING	CAT_PRODUCT_ID	float	8	√		null	product Id from catalog
MATCH_SOFTWARE_METERING	CAT_PUBLISHER_ID	float	8	√		null	publisher Id from catalog
MATCH_SOFTWARE_METERING	CAT_RELEASE_ID	float	8	√		null	release Id from catalog
MATCH_SOFTWARE_METERING	CAT_VERSION_GROUP	nvarchar	128	√		null	version group Id from catalog
MATCH_SOFTWARE_METERING	CAT_VERSION_ID	float	8	√		null	version Id from catalog
MATCH_SOFTWARE_METERING	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
MATCH_SOFTWARE_METERING	DISCOVERED_INSTALLDATE	datetime	16,3	√		null	discovered installed date
MATCH_SOFTWARE_METERING	EDITION	nvarchar	4000	√		null	Product edition for metering data
MATCH_SOFTWARE_METERING	HOST_ID	float	8	√		null	Host Id for metering data
MATCH_SOFTWARE_METERING	HOSTNAME	nvarchar	2048	√		null	Host name for metering data
MATCH_SOFTWARE_METERING	ID	float	8				Unique sofware metering Id
MATCH_SOFTWARE_METERING	INVENTORY_ID	float	8				Inventory Id for this row
MATCH_SOFTWARE_METERING	NUMBER_OF_MINUTES	float	8	√		null	Number of minutes
MATCH_SOFTWARE_METERING	PRODUCT_FAMILY	nvarchar	510	√		null	Product family for metering data eg: Creative, Office
MATCH_SOFTWARE_METERING	PRODUCT_NAME	nvarchar	4000	√		null	Product name for metering data eg: Dreamweaver, Access
MATCH_SOFTWARE_METERING	PUBLISHER	nvarchar	4000	√		null	Publihser for metering data eg: Adobe Systems, Microsoft
MATCH_SOFTWARE_METERING	TASK_ID	float	8				Task Id for this row
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
MATCH_SOFTWARE_METERING	VERSION	nvarchar	128	√		null	Product version for metering data
MATCH_STATS	DATASRC	nvarchar	50	√		null	Data Source for this row eg: SCCM, ADDM
MATCH_STATS	INVENTORY_ID	float	8				Inventory Id for this statistics
MATCH_STATS	IRRELEVANT	float	8	√		null	Total irrelavant addremove/exe
MATCH_STATS	KNOWN	float	8	√		null	Total known addremove/exe
MATCH_STATS	KNOWN_PERC	float	8	√		null	Total known percentage of addremove/exe
MATCH_STATS	MAPPED	float	8	√		null	Total mapped addremove/exe
MATCH_STATS	TASK_ID	float	8				Task Id for this statistics
MATCH_STATS	TOTAL	float	8	√		null	Total number of addremove/exe
MATCH_STATS	TYPE	varchar	10				Statistics type eg: Add/Remove, EXE
MATCH_STATS	UNKNOWN	float	8	√		null	Total unknown of addremove/exe
MATCH_STATS	UNKNOWN_PERC	float	8	√		null	Total unknown percentage of addremove/exe
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
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
MATCH_TASK_DET	INVENTORY_ID	float	8	√		null	Inventory Id for this task
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
MATCH_TASK_DET	PROCESS_STATUS	varchar	20	√		null	process status for this task
MATCH_TASK_DET	TASK_ID	float	8				Task Id for this task
MATCH_TASK_DET	TASK_NAME	varchar	256	√		null	Task name for this task