Technology Intelligence Platform Datasets

Description

This page specifies the data models used when downloading export data for Technology Intelligence Platform from the Query API.

Data Models

Data is normalized into flat-file structures to be easily integrated with third-party systems.

Hardware Inventory

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
HardwareID	id	UUID	The unique identifier for a computer instance.
Domain	domain	String	The computer domain name.
MachineName	name	String	The machine name.
SerialNumber	serial_number	String	The computer serial number.
LastLoggedInUser	last_loggedon_user	String	The last logged in user.
CreatedDate	created_at	String	The date the instance was first created in TDS.
UpdatedDate	updated_at	String	The date the instance was last updated in TDS.
RecognitionStatus	manufacturer_id, product_id, model_id	String	Provides information of what Technopedia model "level" normalization, has been able to identify the item.
TechnopediaGUIDType	manufacturer_id, product_id, model_id	String	The level/type the Technopedia ID is related to. This is primarily directed to the Type field except in the case of "owner" where it is directed to "manufacturer".
TechnopediaGUID	model_id, product_id, manufacturer_id	UUID	The normalized Technopedia catalog ID.
EvidenceManufacturer	evidence_manufacturer_name	String	The manufacturer of the hardware family.
EvidenceName	evidence_model_name	String	The computer model number.
HDDCount	number_of_hdd	Int	The number of hardware disk drive (HDD) in the computer.
HDDTotalSpace	hdd_total_space	Int64	The computer HDD total space.
NumberOfProcessors	number_of_processors	Int	The number of processors in the computer.
TotalMemory	total_memory	Int64	The total memory allocated to the computer.
DisplayAdapterCount	number_of_display_adapters	Int	The number of display adapters used in the computer.
PlatformLabel	platform_label	String	The Platform Label Name.
PlatformType	platform_type	String	The Platform Type.
OsProduct	os_release_id, os_product_id	String	The Operative System product value.
Status	ignored	String	The current Status for Hardware Inventory.
OrgID	org	String	The unique identifier for the organization.
Sequence	_sequence	Int64	The sequence number value. Only present in the delta downloads.
ProcessorName	processor_name	String	The Processor Name information.
NumberOfProcessorCores	number_of_cores	Int	The Number of Processor Cores.
NumberOfProcessorLogicalCores	number_of_logical_cores	Int	The Number of Processor Logical Cores.
ProcessorClockSpeedMhz	max_clock_speed	Int	The Processor Clock Speed in MHZ.
OsName	name	String	The Operative System Name.
InventoryDate	inventory_date	String	The Inventory Date value.
InventoryAgent	inventory_agent	String	The Inventory Agent value.

Hardware Inventory Source

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	String	The opcode type of an event. Only present in the delta downloads.
DataSourceCaption	data_source_caption	String	The connection name of the computer's data source.
DatasourceID	data_source_id	String	The data source ID that uniquely identifies the computer's data source within the organization.
DataSourceType	data_source_type	String	The type of the computer's data source.
HardwareID	device_id	String	Identifier for the device the vulnerability is associated with.
InventoryDate	inventory_date	String	The Inventory Date value.
MachineID	machine_id	String	An ID that uniquely identifies the computer.
EvidenceManufacturer	evidence_manufacturer_name	String	The manufacturer of the hardware family.
EvidenceName	evidence_model_name	String	The computer model number.
OrgID	org	String	The unique identifier for the organization.
Sequence	sequence	Int	The sequence number value. Only present in the delta downloads.

Hardware Model Connectivity

Export Column Name	Lakehouse Column	Type	Description
HardwareModelConnectivityID	id	String	The unique identifier for Hardware Model Connectivity.
HardwareModelID	model_id	String	The HardwareModelID in Technopedia this Hardware Model Connectivity record relates to.
Name	name	String	Connectivity information.
Standard	standard	String	The 'Standard' attribute with the description 'E.g.: IEEE 802.3 etc.'.
StandardVersion	standard_version	String	The 'Standard' Version's unique identifier.
ConnectivityType	type	String	The type of connectivity.
CreatedDate	created_date	String	The date when an entry was first created.
OrgID	org	String	The unique identifier for the organization.

Hardware Model Power

Export Column Name	Lakehouse Column	Type	Description
HardwareModelPowerID	id	String	The unique identifier for Hardware Model power.
HardwareModelID	model_id	double	The HardwareModelID in Technopedia this Hardware Model Power record relates to.
ACCurrentHighMin	ac_current_high_min	double	Manufacturer's suggested AC electrical input requirements: The minimum current when the voltage switch is turned on to the high range setting.
ACCurrentHighMax	ac_current_high_max	double	Manufacturer's suggested AC electrical input requirements: The maximum current when the voltage switch is turned on the high range setting.
ACCurrentLowMin	ac_current_low_min	double	Manufacturer's suggested AC electrical input requirements: The minimum current when the voltage switch is turned on to the low range setting, or when the device has no voltage switch (single voltage range).
ACCurrentLowMax	ac_current_low_max	double	Manufacturer's suggested AC electrical input requirements: The maximum current when the voltage switch is turned on to the low range setting, or when the device has no voltage switch (single voltage range).
ACFrequencyMin	ac_frequency_min	double	The manufacturer's suggested AC input requirements, i.e. the minimum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch).
ACFrequencyMax	ac_frequency_max	double	The manufacturer's suggested AC input requirements, i.e. the maximum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch).
ACHeatDissipationAverage	ac_heat_dissipation_average	String	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).
ACHeatDissipationMax	ac_heat_dissipation_max	String	The peak or maximum amount of heat per-units of time generated by the device during typical usage when it is hooked up to AC power (in BTU/hr).
ACPhase	ac_phase	Int64	The phase of the AC.
AcPowerAverage	ac_power_average	String	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 voltamp).
ACPowerAverageUnit	ac_power_average_unit	String	The unit for AC_POWER_AVG column(watt or volt-amp).
ACPowerMax	ac_power_max	String	The peak or 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).
ACPowerMaxUnit	ac_power_max_unit	String	The unit for the AC_POWER_MAX column (watt or volt-amp).
ACVoltageHighMin	ac_voltage_high_min	double	Manufacturer's suggested AC electrical input requirements: The minimum voltage when the voltage switch is turned to on the high range setting.
ACVoltageHighMax	ac_voltage_high_max	double	Manufacturer's suggested AC electrical input requirements: The maximum voltage when the voltage switch is turned on to the high range setting.
ACVoltageLowMin	ac_voltage_low_min	double	Manufacturer's suggested AC electrical input requirements: The minimum voltage when the voltage switch is turned on to the low range setting, or when the device has no voltage switch (single voltage range).
ACVoltageLowMax	ac_voltage_low_max	double	Manufacturer's suggested AC electrical input requirements: The maximum voltage when the voltage switch is turned on to the low range setting, or when the device has no voltage switch (single voltage range).
BatteryLife	battery_life	Int64	Hours of possible battery life.
BatteryType	battery_type	String	Battery type.
DCCurrentLow	dc_current_low	double	The manufacturer's suggested DC input requirements, i.e. the current when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage).
DCCurrentHigh	dc_current_high	double	The manufacturer's suggested DC input requirements, i.e. the current when the voltage switch is turned on the high setting.
DCHeatDissipationAverage	dc_heat_dissipation_average	String	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).
DCHeatDissipationMax	dc_heat_dissipation_max	String	The peak or maximum amount of heat per-unit of time generated by the device when it is hooked up to DC power (in BTU/hr).
DCPowerAverage	dc_power_average	String	The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up.
DCPowerMax	dc_power_max	String	The peak or 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).
DCVoltageLow	dc_voltage_low	double	The manufacturer's suggested DC input requirements, i.e. the voltage when the voltage switch is turned on the low setting or when the device has no voltage switch (single voltage).
DCVoltageHigh	dc_voltage_high	double	The manufacturer's suggested DC input requirement, i.e. the voltage when the voltage switch is turned on the high setting.
EmergencyPower	emergency_power	String	Listing of the emergency power.
Epeat	epeat	String	This is a flag to indicate which EPEAT certification the device has earned: Gold, Silver, or Bronze.
HasDedicatedCircuit	has_dedicated_circuit	String	Listing of the dedicated circuit.
IsEnergyStar	is_energy_star	String	This is a flag to indicate whether the device has earned the Energy Star certification or not.
NonOperatingHumidityMin	non_operating_humidity_min	double	The manufacturer's suggested minimum humidity (percentage) of the device when it is non-operational or in storage.
NonOperatingHumidityMax	non_operating_humidity_max	double	The manufacturer's suggested peak or maximum humidity (percentage) of the device when it is non-operational or in storage.
NonOperatingTemperatureMin	non_operating_temperature_min	double	The manufacturer's suggested minimum temperature of the device when it is non-operational or in storage (in Fahrenheit).
NonOperatingTemperatureMax	non_operating_temperature_max	double	The manufacturer's suggested peak or maximum temperature of the device when it is non-operational or in storage (in Fahrenheit).
OperatingHumidityMin	operating_humidity_min	double	The manufacturer's suggested minimum humidity (percentage) of the device during operation.
OperatingHumidityMax	operating_humidity_max	double	The manufacturer's suggested peak or maximum humidity (percentage) of the device during operation.
OperatingTemperatureMin	operating_temperature_min	double	The manufacturer's suggested minimum temperature of the device during operation (in Fahrenheit).
OperatingTemperatureMax	operating_temperature_max	double	The manufacturer's suggested peak or maximum temperature of the device during operation (in Fahrenheit).
PlugType	plug_type	String	Plug type (NEMA).
PowerRating	power_rating	String	The summary of the device's various power ratings: Voltage, Frequency, and Current.
CreatedDate	created_date	String	The date when an entry was first created.
OrgID	org	String	The unique identifier for the organization.

Hardware Model Profile

Export Column Name	Lakehouse Column	Type	Description
HardwareModelProfileID	id	String	The unique identifier for Hardware Model Profile.
HardwareModelID	model_id	String	The HardwareModelID in Technopedia this Hardware Model Profile record relates to.
Name	name	String	The profile (or form factor) of the device.
BoreSize	bore_size	double	Bore Size in inches.
Mounting	mounting	String	The mounting of the device.
RoomSizeMin	room_size_min	double	The minimum Room Size (sq. ft.).
Diameter	diameter	double	Diameter in inches.
Volume	volume	double	The volume (CC).
DepthMin	depth_min	double	The minimum depth of the device (in inches).
DepthMax	depth_max	double	The maximum depth of the device (in inches).
HeightMin	height_min	double	The minimum height of the device (in inches).
HeightMax	height_max	double	The maximum height of the device (in inches).
WeightMin	weight_min	double	The minimum weight of the device (in lbs.).
WeightMax	weight_max	double	The maximum weight of the device (in lbs.).
WidthMin	width_min	double	The minimum width of the device (in inches).
WidthMax	width_max	double	The maximum width of the device (in inches).
CreatedDate	created_date	String	The date when an entry was first created.
OrgID	org	String	The unique identifier for the organization.

Hardware Technopedia Lifecycle

Export Column Name	Lakehouse Column	Type	Description
TechnopediaGUID	model_id	String	The unique Technopedia GUID for the hardware model.
TechnopediaGUIDType	'Model'	String	This column will always contain the value 'Model' because Hardware Technopedia Lifecycle details are only available for Hardware Technopedia Models.
IntroductionDate	introduction_date	String	The date the hardware was introduced/announced, in standardized format.
IntroductionException	introduction_exception	String	The reason why the introduction date is not available or a caveat on the date value that is currently provided.
GeneralAvailabilityDate	general_availability_date	String	The date that the product is generally available through official vendor distributions, in standardized date format.
GeneralAvailabilityException	general_availability_exception	String	The reason why the general availability date is not available or a caveat on the date value that is currentlybeing provided. Values are: Date not published by the vendor Support policy not defined by the vendor Exact date unknown (a date range is provided) Contract-based support only (no specific date) Open-source support only (no specific date) Limited, self-help support only (no specific date Date in the past (exact date unknown) To be determined Other
LastAvailabilityDate	last_availability_date	String	The last date by which the hardware is available for purchase from the vendor, in standardized date format.
LastAvailabilityException	last_availability_exception	String	The reason why the last availability date is not available or a caveat on the date value that is currently being provided.
ObsoleteDate	obsolete_date	String	The last date by which any support is provided by the vendor, in standardized date format. The only support available after this date might be self-help online support.
ObsoleteDateException	obsolete_exception	String	The reason why the obsolete date is not available or a caveat on the date value that is currently being provided.
OrgID	org	String	The unique identifier for the organization.

Manufacturer Technopedia

Export Column Name	Lakehouse Column	Type	Description
TechnopediaGUID	id	String	The unique Technopedia GUID for this manufacturer.
Name	name	String	The name of entity which builds, manufactures and/or supports, or provides maintenance of the hardware; or develops, publishes and/or supports the software. Captured as the well-known name of the entity in the market (which may or may not be the same as the legal name).
Description	description	String	A brief description of this manufacturer.
Email	email	String	The manufacturer’s email address.
Fax	fax	String	The manufacturer’s fax number.
Phone	phone	String	The manufacturer’s telephone number.
Website	website	String	The manufacturer’s official website.
Street	street	String	The street address where the manufacturer's headquarter is located.
City	city	String	The city where the manufacturer's headquarter is located.
State	state	String	The state or province where the manufacturer's headquarter is located
Country	country	String	The country where the manufacturer's headquarter is located.
Zip	zip	String	The Zip/postal code where the manufacturer's headquarter is located.
KnownAs	known_as	String	Another name the manufacturer is known by (i.e., an abbreviation, expanded name, informal name, etc.).
LegalEntity	legal	String	The legal entity of a company (i.e., Corporation,Limited, etc.)
Tier	tier	String	The categorization of manufacturers based on priority/importance.
OrgID	org	String	The unique identifier for the organization.

Network Adapters

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	String	The opcode type of an event. Only present in the delta downloads.
HardwareID	device_id	String	The computer HardwareID that relates with Network Adapters.
MacAddress	mac	String	The computer unique Mac Address identifier.
IPAddress	ipv4_address	String	The IPV4 address identifier.
IPV6Address	ipv6_address	String	The IPV6 address identifier.
OrgID	org	String	The unique identifier for the organization.
Sequence	_sequence	Int64	The sequence number value. Only present in the delta downloads.

Software Inventory

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	String	The opcode type of an event. Only present in the delta downloads.
SoftwareID	id	String	The unique identifier in Software.
HardwareID	device_id	String	The unique identifier in Hardware.
CreatedDate	created_at	String	The date when an entry was first created.
UpdatedDate	updated_at, created_at	String	The date when the last modification to the entry was made.
TechnopediaGUID	release_id, product_id, manufacturer_id	String	The unique Technopedia ID for Software Inventory.
InstallType	is_operating_system	String	The install type. This may contain 0 or 1, where 0 represents software installer, 1 represents the operating system.
Status	ignored	String	The current status for Software Inventory.
InstallDate	min_install_date	String	The date when this software was installed.
InstalledID		String	The InstalledID identifier. Deprecated, empty.
MachineName	name	String	The machine name.
SerialNumber	serial_number	String	The computer serial number.
Sources	data_source_types	String	A comma separated data source names, where this software was discovered.
OrgID	org	String	The unique identifier for the organization.
Sequence	_sequence	Int64	The sequence number value. Only present in the delta downloads.

Software Technopedia Lifecycle

Export Column Name	Lakehouse Column	Type	Description
TechnopediaGUID	one_id	String	The unique Technopedia ID for Software Lifecycle.
TechnopediaGUIDType	'Release'	String	This column will always contain the value 'Release' because Software Technopedia Lifecycle details are only available for Software Technopedia Releases.
GeneralAvailabilityDate	general_availability_date	String	The date that the product is generally available through official vendor distributions, standardized to follow BDNA’s date format.
GeneralAvailabilityException	general_availability_exception	String	The reason why the general availability date is not available.
EndofLifeDate	end_of_life_date	String	The last date when full support for a product is provided by the vendor, standardized to follow BDNA’s date format. Partial support may still be available.
EndofLifeException	end_of_life_exception	String	The reason why the end-of-life date is not available.
EndofLifeSupportLevel	end_of_life_support_level	String	The name of support level that marks the end-of-life as published by the vendor.
ObsoleteDate	obsolete_date	String	The last date by which any support is provided by the vendor, standardized to follow BDNA’s date format. The only support available after this date might be self-help online support.
ObsoleteDateException	obsolete_exception	String	The reason why the obsolete date is not available.
ObsoleteSupportLevel	obsolete_support_level	String	The name of the support level when the software is obsolete, as published by the vendor.
EndOfLifeDateCalculated	end_of_life_date_calculated	String	The calculated End Of Life date.
ObsoleteDateCalculated	obsolete_date_calculated	String	The calculated Obsolete date.
GeneralAvailabilityDateCalculated	general_availability_date_calculated	String	The calculated General Availability Date.
EndOfLifeCalculatedCase	end_of_life_calculated_case	String	Which calculation case generates this End of Life Date.
ObsoleteCalculatedCase	obsolete_calculated_case	String	Which calculation case generates this Obsolete Date.
OrgID	org	String	The unique identifier for the organization.

Software Technopedia Lineage

Export Column Name	Lakehouse Column	Type	Description
TechnopediaGUID	release_id, product_id	String	The normalized Technopedia catalog ID.
FormerProductTechnopediaGUID	former_software_product_id	String	The unique identifier for the product ID of the immediately prior or previous iteration of the product.
FormerProduct	application	String	The product for the immediately prior or previous iteration. It will include values of Technopedia Product , Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
FormerReleaseTechnopediaGUID	former_software_release_id	String	The software release ID of the immediately previous iteration of the release.
FormerRelease	application	String	This is the software release of the immediately previous iteration of the release. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
LaterProductTechnopediaGUID	later_software_product_id	String	The unique identifier for the product ID of the immediately subsequent iteration of the product.
LaterProduct	application	String	The product of the immediately subsequent iteration of the product. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
LaterReleaseTechnopediaGUID	later_software_release_id	String	The software release ID of the immediately subsequent iteration of the release.
LaterRelease	application	String	This is the software release of the immediately subsequent iteration of the release. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
LatestProductTechnopediaGUID	latest_software_product_id	String	The unique identifier for the product ID of the most recent iteration of the product.
LatestProduct	application	String	The most recent iteration of the product. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
LatestReleaseTechnopediaGUID	latest_software_release_id	String	The software release ID of the latest/ newest iteration of the release.
LatestRelease	application	String	The software of the latest/ newest iteration of the release. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
OldestProductTechnopediaGUID	oldest_software_product_id	String	The unique identifier for the product ID of the oldest iteration of the product.
OldestProduct	application	String	The oldest iteration of the product. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
OldestReleaseTechnopediaGUID	oldest_software_release_id	String	The software release ID of the oldest iteration of the release.
OldestRelease	application	String	The software of the oldest iteration of the release. It will include values of Technopedia Product, Version Group and Version values along other optional values related to Technopedia Edition, Service Pack, Version Label.
OrgID	org	String	The unique identifier for the organization.

Software Technopedia Release Platform

Export Column Name	Lakehouse Column	Type	Description
TechnopediaGUID	id	String	The normalized Technopedia catalog ID.
SoftwareReleaseTechnopediaGUID	software_release_id	String	The link with the computer via Software Release Technopedia ID.
PlatformLabel	platform_label	String	The Platform Label Name.
PlatformType	platform_type	String	The Platform Type.
OrgID	org	String	The unique identifier for the organization.

Software Technopedia Versions

Export Column Name	Lakehouse Column	Type	Description
ProductID	software_product_id	String	The unique identifier for the software product.
VersionID	id	String	The unique identifier for the software version.
VersionName	name	String	The software version name or number.
VersionOrder	order	String	The number that indicates the sequential order by which this particular version was released.
IsMajor	is_major	String	This indicates if the version is a major version or not.
MajorSoftwareVersionID	major_software_version_id	String	If it is not the Major Version, this identifies the Version ID of a particular row's Major Version.
OrgID	org	String	The unique identifier for the organization.

Hardware Evidence

Export Column Name	Lakehouse Column	Type	Description
EvidenceManufacturer	evidence_manufacturer	String	Manufacturer of the hardware as provided in the evidence.
EvidenceModel	evidence_model_number	String	Model number of the hardware as provided in the evidence.
EvidenceTitle	evidence_title	String	Name of the hardware as provided in the evidence.
RecognitionStatus	recognition_status	String	Recognition status indicating if the hardware is mappable, unknown, or irrelevant.
Count	count	Int	Count of evidence records associated with the hardware.
DatasourceID	data_source_id	String	The data source ID that uniquely identifies the computer's data source within the organization.
EvidenceHash	evidence_hash	String	Hash representing the hardware evidence record.
TechnopediaGUID	technopedia_model_id, technopedia_product_id, technopedia_manufacturer_id	UUID	The unique Technopedia ID for the Hardware.
TechnopediaGUIDType	technopedia_model_id, technopedia_product_id, technopedia_manufacturer_id	String	The level/type the Technopedia ID is related to. This is primarily directed to the Type field except in the case of "owner" where it is directed to "manufacturer".
OrgID	org	String	The unique identifier for the organization.

Hardware Technopedia

Name	Lakehouse Column	Type	Description
TechnopediaGUID	one_id	UUID	The unique Technopedia GUID for the hardware model or product.
TechnopediaGUIDType	one_type	String	The level/type the Technopedia ID is related to. This is primarily directed to the Type field except in the case of "owner" where it is directed to "manufacturer".
ManufacturerID	manufacturer_id	String	The unique identifier for manufacturer.
ManufacturerName	manufacturer_name	String	The hardware manufacturer's name.
ManufacturerTier	manufacturer_tier	Int	Represents the tier or level of the device manufacturer in the industry, indicating their market position.
ProductID	product_id	String	Unique identifier for each hardware product.
ProductName	product_name	String	The name of the hardware product.
ProductIsDesupported	product_is_desupported	Boolean	A boolean flag indicating if the hardware product is desupported.
ProductIsDiscontinued	product_is_discontinued	Boolean	A boolean flag indicating if the hardware product is discontinued.
ModelID	model_id	String	The unique identifier for the hardware model.
ModelName	model_name	String	The name of the hardware model, providing a human-readable label for identification.
ModelSupportedOs	model_supported_os	String	The operating system(s) the device model supports, providing information about compatibility.
ModelIsDesupported	model_is_desupported	Boolean	A boolean flag indicating whether the hardware model is no longer supported by the manufacturer.
ModelIsDiscontinued	model_is_discontinued	Boolean	A boolean flag indicating whether the hardware model is no longer available for purchase.
CategoryGroup	category_group	String	Represents the group of categories within the hardware taxonomy, allowing for further categorization.
CategoryID	category_id	String	The unique identifier for the category.
Category	category	String	Represents the main category of the hardware, providing a general classification.
SubcategoryID	subcategory_id	String	Unique identifier for each device taxonomy record.
Subcategory	subcategory	String	Represents the subcategory of the hardware, allowing for more specific categorization.
LegacyID	legacy_id	String	Data platform Legacy ID for hardware product/model.
OrgID	org	String	The unique identifier for the organization.

Software Inventory Source

Export Column Name	Lakehouse Column	Type	Description
Opcode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
DataSourceCaption	data_source_caption	string	The connection name of the computer's data source.
DataSourceID	data_source_id	string	The data source ID that uniquely identifies the computer's data source within the organization.
DataSourceType	data_source_type	string	The type of the computer's data source.
HardwareID	device_id	string	The unique identifier in Hardware.
InventoryDate	install_date	string	The inventory date of the computer. This will be null for operating system and file evidences.
MachineID	machine_id	string	An ID that uniquely identifies the computer.
EvidenceManufacturer	manufacturer, product_manufacturer	string	The manufacturer of the hardware family. For installer and operating system evidence, it's mapped to manufacturer column in the Lakehouse. For file evidence, it's product_manufacturer column.
EvidenceName	title, name, product_name	string	The computer model number. For installer, operating system and file evidence, this is mapped to the title, name and product_name columns in the Lakehouse, respectively.
EvidenceVersion	version, product_version	string	The evidence version value. For installer and operating system evidence, it's mapped to version column in the Lakehouse. For file evidence, it's product_version column.
SoftwareID	software_id	string	The unique identifier in Software.
OrgID	org	string	The unique identifier for the organization.
Sequence	sequence	int64	The sequence number value. Only present in the delta downloads.
InstallType	Not mapped to a Lakehouse column.	int	The install type. This may contain 0, 1 or 2, where 0 represents software installer evidence, 1 represents the operating system evidence, and 2 represents file evidence.
Path	installation_path, file_path	string	Path of the software installer or file, allowing easy identification and reference. For operating system evidence this will be null. For installer and file evidence, this is mapped to the installation_path and file_path columns in the Lakehouse, respectively.
FileName	file_name	string	Name of the software file, allowing easy identification and reference. This will be null for installer and operating system evidences. For file evidence, it's mapped to file_name column in the Lakehouse.
FileVersion	file_version	string	Version of the software file, allowing tracking of file versions and updates. This will be null for installer and operating system evidences. For file evidence, it's mapped to file_version column in the Lakehouse.
FileSize	file_size	int64	Size of the software file, allowing tracking of file size and capacity. This will be null for installer and operating system evidences. For file evidence, it's mapped to file_size column in the Lakehouse.

Software Evidence

The software_evidence dataset only has installer evidences. It doesn't contain any OS or file evidences.

Export Column Name	Lakehouse Column	Type	Description
EvidenceManufacturer	evidence_manufacturer	String	Manufacturer of the software as provided in the evidence.
EvidenceName	evidence_name	String	Name of the software as provided in the evidence.
EvidenceVersion	evidence_version	String	Version of the software as provided in the evidence.
RecognitionStatus	recognition_status	String	Recognition status indicating if the software is mappable, unknown, or irrelevant.
Count	reported_count	Int	Total count of all evidence records associated with the same evidence_hash.
DatasourceID	data_source_id	String	The data source ID that uniquely identifies the computer's data source within the organization.
EvidenceHash	evidence_hash	String	Hash representing the software evidence record.
IrrelevantReason	irrelevant_reason	String	Reason for the evidence being considered irrelevant, if applicable.
TechnopediaGUID	technopedia_release_id, technopedia_product_id	UUID	The unique Technopedia ID for the Software.
TechnopediaGUIDType	technopedia_release_id, technopedia_product_id	String	The level/type the Technopedia ID is related to.
OrgID	org	String	The unique identifier for the organization.

Software Technopedia

Name	Lakehouse Column	Type	Description
TechnopediaGUID	one_id	UUID	The normalized Technopedia catalog ID.
TechnopediaGUIDType	one_type	String	The level/type the Technopedia ID is related to. This is primarily directed to the Type field except in the case of "owner" where it is directed to "manufacturer".
ManufacturerID	manufacturer_id	String	The unique identifier for the software manufacturer.
ManufacturerName	manufacturer_name	String	The official name of the manufacturer of the software product.
ManufacturerTier	manufacturer_tier	Int	Represents the tier or level of the software manufacturer in the industry.
ProductFamilyID	product_family_id	String	The unique identifier for the software family.
ProductFamily	product_family_name	String	The name of the software product family, if applicable.
ProductID	product_id	String	The unique identifier for the software product.
Product	product_name	String	A concise version of the software product name, useful for quick identification.
ProductName	product_application	String	The full name of the software product, providing a complete and official label.
ProductCloud	product_cloud	String	Describes the deployment method of the software product, such as on-premises, cloud-based, or hybrid.
ProductIsDesupported	product_is_desupported	Boolean	A boolean flag indicating whether the software product is no longer supported by the vendor.
ProductIsDiscontinued	product_is_discontinued	Boolean	A boolean flag indicating whether the software product has been discontinued by the vendor.
ProductLicensable	product_licensable	String	The licensable flag at the product-level, summarizing the licensable flag at the lower release-level, indicating whether the software product is licensable or not (0 = Generally Unlicensable, 1 = Generally Licensable, 2 = Some Releases are Licensable, null = Undefined).
Component	product_component	String	Represents the component or module of the software product, offering more granular information.
VersionGroup	market_version_name	String	The value of the Description Group.
MarketVersionID	market_version_id	String	The unique identifier for market version.
MarketVersionOrder	market_version_order	Int	The number that indicates the sequential order by which this particular market version was released.
MarketVersionIsDesupported	market_version_is_desupported	Boolean	Indicates if the software version is no longer supported.
MarketVersionIsDiscontinued	market_version_is_discontinued	Boolean	Indicates if the software version is no longer available.
VersionID	version_id	String	Unique identifier for the software version.
Version	version_name	String	Name of the software version.
VersionLabel	version_stage	String	Stage of the software development cycle.
VersionOrder	version_order	Int	Order number of the software version.
VersionIsDesupported	version_is_desupported	Boolean	Indicates if the software version is no longer supported.
VersionIsDiscontinued	version_is_discontinued	Boolean	Indicates if the software version is no longer available.
PatchName	version_patch_level	String	The software patch name, if applicable.
PatchLevel	version_patch_level	String	Patch level of the software version.
EditionID	edition_id	String	Unique identifier for the software edition.
Edition	edition_name	String	Name of the software edition, providing a human-readable label for identification.
EditionOrder	edition_order	Int	Represents the order in which the software editions were released, allowing tracking of progression and development.
EditionIsDesupported	edition_is_desupported	Boolean	A boolean flag indicating whether the software edition is no longer supported by the vendor.
EditionIsDiscontinued	edition_is_discontinued	Boolean	A boolean flag indicating whether the software edition has been discontinued and is no longer available for purchase or use.
ReleaseID	release_id	String	Unique identifier for each software release.
Release	release_name	String	The full name of the software release.
ReleaseCloud	release_cloud	String	Represents the deployment status of the software release.
ReleaseIsDesupported	edition_is_desupported	Boolean	A boolean flag indicating whether the software release is desupported.
ReleaseIsDiscontinued	edition_is_discontinued	Boolean	A boolean flag indicating whether the software release is discontinued.
ReleasePlatformID	release_platform_id	String	The unique identifier for Release Platform.
ReleasePlatformLabel	release_platform_label	String	The name of the Release Platform
ReleasePlatformType	release_platform_type	String	The Release Platform Type.
CategoryGroup	category_group	String	Further categorizes the software into groups, such as "Windows" or "MacOS".
CategoryID	category_id	String	The unique identifier for the taxonomy parent name.
Category	category	String	Represents the top-level category of software, such as "Operating Systems" or "Productivity Software".
SubcategoryID	subcategory_id	String	The unique identifier for the software taxonomy record.
Subcategory	subcategory	String	Represents the most specific level of categorization, such as "Microsoft Office" or "Google Workspace".
FamilyIsDesupported	family_is_desupported	String	A flag that indicates that the entry has been de-supported by the vendor. The de-support date is in the past (whether the exact date is known or unknown).
FamilyIsDiscontinued	family_is_discontinued	String	A flag that indicates whether the entry is known or unknown.
IsLicenseable	release_is_licensable	Boolean	A boolean flag indicating whether the software product is licensable, allowing users to purchase licenses for its use.
IsSuite	product_is_suite	Boolean	A boolean flag indicating whether the software product is a suite of related products, offering a more comprehensive solution.
IsMajor	release_is_major	Boolean	Indicates if the software version is a major release.
MajorSoftwareReleaseId	major_software_release_id	String	If it is not the Major Release, this identifies the Release ID of a particular row's Major Release.
IsFamilyInFullName	is_family_in_full_name	Boolean	A boolean flag indicating whether the software product is part of a larger family, allowing for easy identification of related products.
LegacyID	legacy_id	String	Data platform Legacy ID for software product/release.
OrgID	org	String	The unique identifier for the organization.

Vulnerability

Export Column Name	Lakehouse Column	Type	Description
Opcode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
VulnerabilityID	Id	string	The unique identifier for vulnerability. Maps to VulnerabilityID in Vulnerability Advisory and Vulnerability KB Article.
HardwareID	device_id	string	Identifier for the device the vulnerability is associated with.
SoftwareID	software_id	string	Identifier for the installed software the vulnerability is associated with.
TechnopediaProductID	product_id	string	Identifier for the product the vulnerability is associated with.
TechnopediaVersionID	version_id	string	Identifier for the version of the software the vulnerability is associated with.
TechnopediaEditionID	edition_id	string	Identifier for the edition of the software the vulnerability is associated with.
TechnopediaReleaseID	release_id	string	Identifier for the release of the software the vulnerability is associated with.
CveID	cve_id	string	Identifier for the cve the vulnerability is associated with. Maps to CVE ID field in Vulnerability CVE and in Vulnerability CPE.
CveTitle	cve_title	string	Actual CVE number the vulnerability is associated with.
CvePublishDate	cve_publish_date	string	Publish date of CVE
CvssScore	cvss_score	float64	Rating value according to Common Vulnerability Scoring System (CVSS).
AttackVector	attack_vector	string	Translation of the numeric indicator in attack vector where: 1: From remote, 2: From local network, 3: Local system.
Criticality	criticality	int64	Numeric score for the vulnerability criticality ranges from 1 - 5.
CriticalityLabel	criticality_label	string	Translation of the numeric score in criticality, where: 1: Extremely Critical, 2: Highly Critical, 3: Moderately Critical, 4: Less Critical, 5: Not Critical.
ThreatExploitRiskLevel	threat_exploit_risk_level	int64	Numeric score for the threat score ranges from 1 – 7
ThreatExportRiskLabel	threat_exploit_risk_label	string	Represents the risk level of exploited threat.
OrgID	org	string	The unique identifier for the organization.
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.

Vulnerability CPE

Export Column Name	Lakehouse Column	Type	Description
VulnerabilityCpeRecordID	id	string	The unique identifier for the vulnerability cpe.
VulnerabilityID	vulnerability_id	string	Identifier for the Vulnerability the advisory is associated with. Maps to VulnerabilityID in Vulnerability and Vulnerability KB Article.
CpeID	cpe_id	string	The unique identifier for the CPE
CpeUri	cpe_uri	string	Representation of URI for CPE which includes a formal name format, method for checking names against a system, and a description format for binding.
SoftwareID	software_id	string	Identifier for the installed software the vulnerability cpe is associated with.
CpeTitle	cpe_title	string	Representation of URI for CPE which includes a formal name format, method for checking names against a system.
CveID	cve_id	string	Identifier for the CVE the advisory is associated with.
OrgID	org	string	The unique identifier for the organization.

Vulnerability CVE

Export Column Name	Lakehouse Column	Type	Description
CveID	Id	string	The unique identifier for the CVE.
CveTitle	cve_title	string	Actual CVE number for the Vulnerability.
CvssScore	cvss_score	float64	Rating value according to Common Vulnerability Scoring System (CVSS).
CvssVersion	cvss_version	string	Version according to Common Vulnerability Scoring System (CVSS).
CvssVector	cvss_vector	float64	Base Vector value according to Common Vulnerability Scoring System (CVSS).
MalwareNames	malware_names	string	Comma separated list of Malware Names.
CveRules	cve_rules	string	Comma separated list of the threat rules for CVE
ThreatScore	threat_score	string	Threat score generated by in-house logic based on the exploited rules for all CVEs references in the advisory.
OrgID	org	string	The unique identifier for the organization.

Vulnerability Advisory

Export Column Name	Lakehouse Column	Type	Description
VulnerabilityAdvisoryRecordID	id	string	The unique identifier for the vulnerability advisory.
VulnerabilityID	vulnerability_id	string	Identifier for the Vulnerability the advisory is associated with. Maps to VulnerabilityID in Vulnerability and Vulnerability KB Article.
VulnerabilityAdvisoryID	advisory_id	string	The unique identifier for the Secunia Advisory id.
SecuniaAdvisoryID	sa_id	string	Identifier for the secunia advisory associated with.
SoftwareID	software_id	string	Identifier for the installed software the vulnerability advisory is associated with.
ThreatScore	threat_score	int64	Composite score for the Security Advisory, calculated from various criteria and their associated values.
SolutionStatus	solution_status	string	Solution status of the associated vulnerability.
Revision	revision	string	Revising status of the associated Advisory
Title	title	string	Title of the associated Advisory.
CveID	cve_id	string	Identifier for the CVE the advisory is associated with.
AdvisoryUrl	said_url	string	URL for that Specific Secunia Advisory Id.
OrgID	org	string	The unique identifier for the organization.

Vulnerability KB Article

Export Column Name	Lakehouse Column	Type	Description
KbArticleID	id	string	The unique identifier for the kb article.
CreatedOn	created_on	string	Date when an entry was first created in VulnTrack/SVM.
Description	description	string	Description of kbArticle.
Heading	heading	string	Title of kbArticle.
KbArticle	kb_article	int64	The kbArticle Information
KbArticleVulnTrackID	kb_article_vt_id	int64	Identifier for kbArticle in VulnTrack/SVM.
ManufacturerID	manufacturer_id	string	Identifier for Manufacturer
PublishedOn	published_on	string	Date when last modification to the entry was made in VulnTrack/SVM
ReplacementID	replacement_id	string	Identifier of the replacement entry whenever the entry is marked for deletion.
VulnID	vuln_id	int64	Numeric characters from SAID.
VulnerabilityID	vulnerability_id	string	Identifier for the vulnerability associated with kb article. Maps to VulnerabilityID in Vulnerability and Vulnerability Advisory.
OrgID	org	string	The unique identifier for the organization.

ServiceNow Device

The servicenow_device dataset contains the information on the hardware devices identified by servicenow. If you do not have ServiceNow as a datasource then this file will contain 0 rows.

Export Column Name	Lakehouse Column	Type	Description
Opcode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
HardwareID	id	string	Internal identifier for the hardware.
HardwareDataSources	device_datasources	string	Describes the data source associated with the hardware.
SysID	sys_id	string	Identifier for the machine associated with the hardware source.
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.
OrgID	org	string	The unique identifier for the organization.

ServiceNow Software

The servicenow_software dataset contains the information on the software identified by servicenow. If you do not have ServiceNow as a datasource then this file will contain 0 rows.

Export Column Name	Lakehouse Column	Type	Description
Opcode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
SoftwareID	id	string	Internal identifier for the software.
SoftwareDataSources	software_datasources	string	Describes the data source associated with the software install.
SysID	sys_id	string	Identifier for the installation associated with the software source.
DeviceSysID	device_sys_id	string	Identifier for the machine associated with the software source. Maps to ServiceNow Devices dataset SysID
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.
OrgID	org	string	The unique identifier for the organization.

ServiceNow Hardware Inventory

The servicenow_hardware_inventory dataset contains an optimized set of hardware inventory that meets the specific requirements of ServiceNow Integration App.

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
HardwareID	id	string	Internal identifier for the hardware.
HDDTotalSpace	hdd_total_space	double	Computer HDD total in GB. "hardware_inventory" dataset provides this in bytes.
InventoryDate	inventory_date	timestamp	Inventory Date value.
LastLoggedInUser	last_loggedon_user	string	The last logged in user.
MachineName	name	string	The machine name.
NumberOfProcessorCores	number_of_cores	int	Number of Processor Cores.
NumberOfProcessors	number_of_processors	int	The number of processors in the computer.
OSProduct	os_product	string	Identifier for the device operating system product.
OsName	os_name	string	The name of the operating system.
HardwareCategory	category	string	Main category of the device, providing a general classification.
HardwareSubcategory	subcategory	string	Group of categories within the device taxonomy, allowing for further categorization.
ProcessorClockSpeedMhz	max_clock_speed	int	The Processor Clock Speed in MHZ.
ProcessorName	processor_name	string	The Processor Name information.
SerialNumber	serial_number	string	The computer serial number.
TechnopediaGUID	technopedia_guid	string	The normalized Technopedia catalog ID.
TotalMemory	total_memory	double	Total memory allocated to the computer in MB.
Domain	domain	string	Computer domain name.
OSSoftwareCategory	os_category	int	Top-level category of software, such as Operating Systems or Productivity Software.
OSSoftwareSubcategory	os_subcategory	string	Most specific level of categorization, such as Microsoft Office or Google Workspace
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.
OrgID	org	string	The unique identifier for the organization.

ServiceNow Software Inventory

The servicenow_software_inventory dataset contains an optimized set of software inventory that meets the specific requirements of ServiceNow Integration App.

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
SoftwareID	id	string	The unique identifier in Software.
HardwareID	device_id	string	The unique identifier in Hardware.
TechnopediaGUID	technopedia_guid	string	The unique Technopedia ID for Software Inventory.
MachineName	machine_name	string	The machine name.
SerialNumber	serial_number	string	The computer serial number.
HardwareCategory	device_category	string	Main category of the device, providing a general classification.
HardwareSubcategory	device_subcategory	string	Group of categories within the device taxonomy, allowing for further categorization.
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.
OrgID	org	string	The unique identifier for the organization.

Hardware Contextualized

The hardware_contextualized dataset contains information on contextualize data for given hardware device.

Export Column Name	Lakehouse Column	Type	Description
HardwareID	id	string	The unique identifier for Hardware.
Location	location	string	The hardware location.
CostCenter	cost_center	string	The cost center the hardware belongs to, as defined by the customer.
BusinessUnit	business_unit	string	The business unit the hardware belongs to, as defined by the customer.
Status	status	string	The current status of Hardware Contextualized.
OrgID	org	string	The unique identifier for the organization.
Sequence	sequence	int	The sequence number value.

Device Mashup

The device_mashup dataset contains information on mashup data for given hardware.

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
OrgID	org	string	The unique identifier for the organization.
ID	id	string	The unique identifier for mashup data.
OwnerID	owner_id	string	The unique identifier in the owner type.
HardwareID	owner_id	string	The unique identifier in Hardware.
OwnerType	owner_type	string	The owner for the owner ID.
Key	key	int	The name of the custom mashup property.
Value	value	string	The value for the custom property.
MashupSourceID	mashup_source_id	string	The unique ID for the source in contextual data store.
MashupSourceName	mashup_source_name	string	The name for the source in contextual data store.
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.

Software Mashup

The software_mashup dataset contains information on mashup data for given software.

Export Column Name	Lakehouse Column	Type	Description
OpCode	_op_code	string	The opcode type of an event. Only present in the delta downloads.
OrgID	org	string	The unique identifier for the organization.
ID	id	string	The unique identifier for mashup data.
OwnerID	owner_id	string	The unique identifier in the owner type.
SoftwareTechnopediaID	owner_id	string	The unique identifier in Software Technopedia.
OwnerType	owner_type	string	The owner for the owner ID.
Key	key	int	The name of the custom mashup property.
Value	value	string	The value for the custom property.
MashupSourceID	mashup_source_id	string	The unique ID for the source in contextual data store.
MashupSourceName	mashup_source_name	string	The name for the source in contextual data store.
Sequence	sequence	int	The sequence number value. Only present in the delta downloads.

ARL Alignment

The arl_alignment dataset establishes a mapping between Flexera’s Legacy Technopedia IDs in Data Platform, Technopedia IDs in IT Visibility, and ARL IDs. This ensures consistency and accuracy in software asset management.

Export Column Name	Lakehouse Column	Type	Description
OrgID	org	string	The unique identifier for the organization.
IDArl	arl_id	string	The unique identifier for Arl Alignment.
IDLegacy	data_platform_id	string	The Data Platform ID for Arl Alignment.
SoftwareProductIDLegacy	software_product_data_platform_id	string	The Software Product ID from Data Platform.
SoftwareProductID	software_product_id	string	The Software Product ID.
SoftwareReleaseIDLegacy	software_release_data_platform_id	string	The Software Release ID from Data Platform.
SoftwareReleaseID	software_release_id	string	The Software Release ID.

Hardware Business Services

The device_business_services dataset contains information about the various services that are available for each device in the inventory. It includes details such as the service ID, device ID, and the service name. This table can be used to understand the range of services available for each device, and to identify the specific services that are being used by the business.

Export Column Name	Lakehouse Column	Type	Description
HardwareID	device_id	string	The hardware business service belongs to.
BusinessServiceID	service_id	string	The unique ID of the business service inside Flexera One.
BusinessService	name	string	The departmental business service name as provided by RISC/customer.
OrgID	org	string	The unique identifier for the organization. Annotated by Rocket

Business Services Applications

The business_services_applications dataset contains information about various business services and applications. It includes details such as the service name, owner, department, description, and group type. This data can be used to understand the different services available, their purpose and their respective owners.

Export Column Name	Lakehouse Column	Type	Description
ServiceID	service_id	string	The unique ID of the business service inside Flexera One.
Name	name	string	The Business Service Application Name.
Owner	owner	string	The Business Service Application Owner.
Department	department	string	The Business Service Application Department.
Description	description	string	The Business Service Application Description.
GroupType	group_type	string	The Business Service Application Group Type.
Tags	tags	string	The Business Service Application Tag.
URL	url_to_risc_stack	string	The Business Service Application URl.
OrgID	org	string	The unique identifier for the organization. Annotated by Rocket

Business Services Assets

The business_services_assets dataset contains information about the assets associated with various business services. It includes details such as the asset ID, service ID, location, and tags. Additionally, it provides information about any dependent assets.

Export Column Name	Lakehouse Column	Type	Description
AssetID	asset_id	string	The Business Service Asset identifier.
ServiceID	service_id	string	The unique ID of the business service inside Flexera One.
Location	location	string	The Business Service Asset Location.
Tags	tags	string	The Business Service Asset Tag.
DependentAssets	dependent_asset_id	string	The Dependent Assets under Business Service Assets.
OrgID	org	string	The unique identifier for the organization. Annotated by Rocket

Business Services Dependent Applications

The business_services_dependent_applications dataset outlines the dependencies between different business services and their associated applications. It includes details about the services involved, their respective dependent services, and whether they are critical to the overall functioning of the business.

Export Column Name	Lakehouse Column	Type	Description
ServiceID	service_id	string	The unique ID of the business service inside Flexera One.
DependentServiceID	dependent_service_id	string	The Dependent Service identifier.
Critical	critical	string	Critical Value for Business Service Dependent Applications.