IT Visibility Insights

Description

This page specifies the data models used when downloading export data for ITV in the insights cluster. Data is created in parquet format and stored in S3 buckets as described in the overall architecture design.

Data Models

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

Hardware Inventory

Name Type Description
Hardware ID  UUID  The unique identifier for a computer instance.
Domain Strings The computer domain name.
Machine Name Strings The machine name.
Serial numbers Strings The computer serial numbers.
Last Logged in User Strings The last logged in user.
Created Date  Strings The date the instance was first created in TDS.
Updated Date  Strings  The date the instance was last updated in TDS.
Technopedia GUID  UUID The normalized catalog ID.
Technopedia GUID Type  Strings 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".
Recognized Status  Strings  Provides information of what Technopedia model "level" normalization, has been able to identify the item.
Evidence Manufacturer  Strings The manufacturer of the hardware family.
Evidence Name  Strings  The computer model number.
HDD Count  Int  The number of hardware disk drive (HDD) in the computer.
HDD Total Space (KB)  Int64  The computer HDD total space.
Number of Processors  Int  The number of processors in the computer.
Total Memory (KB)  Int64  The total memory allocated to the computer.
Display Adapter Count  Int  The number of display adapters used in the computer.
Org ID  Strings  The unique identifier for the organization.

Hardware Technopedia

Name Type Description
Technopedia GUID UUID The link with the computer via Technopedia ID.
Technopedia GUID Type Strings 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".
Manufacturer ID Strings The unique identifier for manufacturer.
Manufacturer Strings 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).
Product ID Strings The unique identifier for the hardware product.
Product Strings The name of the hardware product.
Model ID Strings The unique identifier for the hardware model.
Model Strings The model name/number of the hardware product.
Category Group Strings The name of the category in the corresponding Technopedia taxonomy.
Category ID Strings The unique identifier for the category.
Category Strings The name of the category where the item is included.
Subcategory ID Strings The unique identifier for the subcategory.
Subcategory Strings The name of the subcategory.

Hardware Technopedia Lifecycle

Name Type Description
Technopedia GUID UUID The link with the computer via Technopedia ID.
Technopedia GUID Type Strings 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".
Introduction Date Strings The date the hardware was introduced/announced, in standardized format.
Introduction Exception Strings The reason why the introduction date is not available or a caveat on the date value that is currently provided.
General Availability Date Strings The date that the product is generally available through official vendor distributions, in standardized date format.
General Availability Exception Strings 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
Last Availability Date Strings The last date by which the hardware is available for purchase from the vendor, in standardized date format.
Last Availability Exception Strings The reason why the last availability date is not available or a caveat on the date value that is currently being provided.
Obsolete Date Strings 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.
Obsolete Date Exception Strings The reason why the obsolete date is not available or a caveat on the date value that is currently being provided.

Hardware Contextualized

Name Type Description
Hardware ID UUID The unique identifier for the hardware.
Location Strings The location of the hardware.
Cost Center Strings The cost center the hardware belongs to, as defined by the customer.
Business Unit Strings The business unit the hardware belongs to, as defined by the customer.

Hardware Model Connectivity

Name Type Description
Hardware Model Connectivity ID UUID The unique identifier for hardware model connectivity.
Technopedia GUID UUID The link with the hardware model via Technopedia ID.
Org ID Strings The unique identifier for the organization.
Created Date Strings The date when an entry was first created.
Name Strings Connectivity information.
Standard Strings The 'Standard' attribute with the description 'E.g.: IEEE 802.3 etc.'.
Standard Version Strings The 'Standard' Version's unique identifier.
Connectivity Type Strings The type of connectivity.

Hardware Model Power

Name Type Description
Hardware Model Power ID UUID The unique identifier for hardware model power.
Technopedia GUID UUID The link with the hardware model via Technopedia ID.
Org ID Strings The unique identifier for the organization.
Created Date Strings The date when an entry was first created.
AC Current High Min Float Manufacturer's suggested AC electrical input requirements: The minimum current when the voltage switch is turned on to the high range setting.
AC Current High Max Float Manufacturer's suggested AC electrical input requirements: The maximum current when the voltage switch is turned on the high range setting.
AC Current Low Min Float 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).
AC Current Low Max Float 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).
AC Frequency Min Float 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).
AC Frequency Max Float 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).
AC Heat Dissipation Average Strings 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).
AC Heat Dissipation Max Strings 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).
AC Phase Int The phase of the AC.
AC Power Average Strings 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).
AC Power Average Unit Strings The unit for AC_POWER_AVG column(watt or volt-amp).
AC Power Max Strings 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).
AC Power Max Unit Strings The unit for the AC_POWER_MAX column (watt or volt-amp).
AC Voltage High Min Float Manufacturer's suggested AC electrical input requirements: The minimum voltage when the voltage switch is turned to on the high range setting.
AC Voltage High Max Float Manufacturer's suggested AC electrical input requirements: The maximum voltage when the voltage switch is turned on to the high range setting.
AC Voltage Low Min Float 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).
AC Voltage Low Max Float 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).
Battery Life Int Hours of possible battery life.
Battery Type Strings Battery type.
DC Current Low Float 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).
DC Current High Float The manufacturer's suggested DC input requirements, i.e. the current when the voltage switch is turned on the high setting.
DC Heat Dissipation Average Strings 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).
DC Heat Dissipation Max Strings 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).
DC Power Average Strings The average amount of power (energy per-unit of time) consumed by the device during typical use when it is hooked up.
DC Power Max Strings 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).
DC Voltage Low Float 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).
DC Voltage High Float The manufacturer's suggested DC input requirement, i.e. the voltage when the voltage switch is turned on the high setting.
Emergency Power Strings Listing of the emergency power.
Epeat Strings This is a flag to indicate which EPEAT certification the device has earned: Gold, Silver, or Bronze.
Has Dedicated Circuit Strings Listing of the dedicated circuit.
Is Energy Star Strings This is a flag to indicate whether the device has earned the Energy Star certification or not.
Non Operating Humidity Min Float The manufacturer's suggested minimum humidity (percentage) of the device when it is non-operational or in storage.
Non Operating Humidity Max Float The manufacturer's suggested peak or maximum humidity (percentage) of the device when it is non-operational or in storage.
Non Operating Temperature Min Float The manufacturer's suggested minimum temperature of the device when it is non-operational or in storage (in Fahrenheit).
Non Operating Temperature Max Float The manufacturer's suggested peak or maximum temperature of the device when it is non-operational or in storage (in Fahrenheit).
Operating Humidity Min Float The manufacturer's suggested minimum humidity (percentage) of the device during operation.
Operating Humidity Max Float The manufacturer's suggested peak or maximum humidity (percentage) of the device during operation.
Operating Temperature Min Float The manufacturer's suggested minimum temperature of the device during operation (in Fahrenheit).
Operating Temperature Max Float The manufacturer's suggested peak or maximum temperature of the device during operation (in Fahrenheit).
Plug Type Strings Plug type (NEMA).
Power Rating Strings The summary of the device's various power ratings: Voltage, Frequency, and Current.

Hardware Model Profile

Name Type Description
Hardware Model Profile ID UUID The unique identifier for hardware model profile.
Technopedia GUID UUID The link with the hardware model via Technopedia ID.
Org ID Strings The unique identifier for the organization.
Created Date Strings The date when an entry was first created.
Bore Size Float Bore Size in inches.
Depth Min Float The minimum depth of the device (in inches).
Depth Max Float The maximum depth of the device (in inches).
Diameter Float Diameter in inches.
Height Min Float The minimum height of the device (in inches).
Height Max Float The maximum height of the device (in inches).
Mounting Strings The mounting of the device.
Name Strings The profile (or form factor) of the device.
Room Size Min Float The minimum Room Size (sq. ft.).
Volume Float The volume (CC).
Weight Min Float The minimum weight of the device (in lbs.).
Weight Max Float The maximum weight of the device (in lbs.).
Width Min Float The minimum width of the device (in inches).
Width Max Float The maximum width of the device (in inches).

Software Inventory

Name Type Description
Software ID Strings The unique identifier for the software.
Hardware ID Strings The unique identifier for the hardware.
Created Date Strings The date when an entry was first created.
Updated Date Strings The date when the last modification to the entry was made.
Technopedia GUID UUID The link with the computer via Technopedia ID.
Org ID Strings The unique identifier for the organization.

Software Open Source

Name Type Description
Technopedia GUID UUID The link with the computer via Technopedia ID.
Software Release Technopedia GUID UUID The link with the computer via Software Release Technopedia ID.
Org ID Strings The unique identifier for the organization.
Component ID Strings The unique identifier for the component.
Created Date Strings The date when an entry was first created.
Description Strings The component description.
Display Name Strings The display name is a colloquial name of a component. In some cases it is identical to the name or title.
Components Category Strings The components category.
Components Language Strings The components language.
Components Norm Category Strings The components norm category.
Components Norm Language Strings The components norm language.
Components Platform Strings The components platform.
Name Strings The public name for the component.
Owner Strings The company, open source project or individual author.
Project ID Strings The Project ID can be used to deterministically search for the project on the host forge. It may be different from name/title attributes.
Registered Date Strings The date the component was registered or published on the forge.
Source Strings The source where the requirements information is obtained from.
Title Strings The title can be used to uniquely identify a component.
Url Strings The url of the component.
Version Strings The version of the component.

Software Open Source Component License

Name Type Description
Technopedia GUID UUID The link with the computer via Technopedia ID.
Org ID Strings The unique identifier for the organization.
Family Name Strings The licenses family name.
Is Copy left Strings Whether the license is copyleft or not.
Is Primary Boolean The priority of the license as defined by SCA.
License Name Strings The full name of the license, as provided by the original authors.
License Type Strings The license type.
License Url Strings The license url.
Short Name Strings The most commonly used name for the license, often abbreviated.
Spdx Identifier Strings The spdx license identifier.
Spdx Name Strings The spdx license name.

Software Open Source Version License

Name Type Description
Technopedia GUID UUID The link with the computer via Technopedia ID.
Org ID Strings The unique identifier for the organization.
Family Name Strings The licenses family name.
Is Copy left Strings Whether the license is copyleft or not.
Is Primary Boolean The priority of the license as defined by SCA.
License Name Strings The full name of the license, as provided by the original authors.
License Type Strings The license type.
License Url Strings The license url.
Short Name Strings The most commonly used name for the license, often abbreviated.
Spdx Identifier Strings The spdx license identifier.
Spdx Name Strings The spdx license name.

Software Open Source Version Url

Name Type Description
Technopedia GUID UUID The link with the computer via Technopedia ID.
Org ID Strings The unique identifier for the organization.
Version Url Strings The version url.

Software Technopedia

Name Type Description
Technopedia GUID UUID The normalized catalog ID.
Technopedia GUID Type Strings 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".
Manufacturer ID Strings The unique identifier for the manufacturer.
Manufacturer Strings The name of the manufacturer of the software product.
Manufacturer Tier Int The categorization of manufacturers based on priority/importance.
Product Family ID Strings The unique identifier for the software family.
Product Family Strings The brand, product line, or family the software belongs to in the manufacturer's portfolio of software offerings, if applicable.
Product ID Strings The unique identifier for the software product.
Product Strings The normalized name of the product.
Product Name Strings The complete name of the product as mentioned by the vendor in the software license as well as other official documentations and/or website.
Component ID Strings The unique identifier for the component.
Component Strings The component of the software product, if applicable.
Market Version ID Strings The unique identifier for the software version group.
Market Version Strings The name of the version group (or market version) of the software. A version group contains one or more versions, one of which is the major version.
Version ID Strings The unique identifier for the software version.
Version Strings The software version name or number.
Service Pack Strings The value represents the version of the service pack that is used.
Version Stage Strings This indicates the stage within the lifecycle of a product version from its initial inception to the final/end form and beyond.
Patch ID Strings The unique identifier for patch.
Patch Name Strings The software patch name or number, if applicable.
Edition ID Strings The unique identifier for software edition.
Edition Strings The software product edition name, if applicable.
Release ID Strings The unique identifier of the software release.
Release Strings The full release name of the product.
Category Group ID Strings The unique identifier for the category group.
Category Group Strings The optional attribute you can use to further simplify or reorganize the current, 2-level BDNA taxonomy into an additional, higher level. It groups the taxonomy parent ID into several discrete buckets.
Category ID Strings The unique identifier for the taxonomy parent name.
Category Strings The taxonomy parent name.
Subcategory ID Strings The unique identifier for the subcategory.
Subcategory Strings The second level category in Technopedia taxonomy.

Software Technopedia Lifecycle

Name Type Description
Technopedia GUID UUID The normalized catalog ID.
Technopedia GUID Type Strings 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".
General Availability Date Strings The date that the product is generally available through official vendor distributions, standardized to follow BDNA’s date format.
General Availability Exception Strings The reason why the general availability date is not available.
End of Life Date Strings 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.
End of Life Exception Strings The reason why the end-of-life date is not available.
End of Life Support Level Strings The name of support level that marks the end-of-life as published by the vendor.
Obsolete Date Strings 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.
Obsolete Date Exception Strings The reason why the obsolete date is not available.
Obsolete Support Level Strings The name of the support level when the software is obsolete, as published by the vendor.

Business Services

Name Type Description
Hardware ID UUID The hardware business service belongs to.
Business Service ID UUID The unique ID of the business service inside Flexera One.
Business Service Strings The departmental business service name as provided by RISC/customer.