Normalize: IT Assets

Field

Description

INV Date

Inventory Date

INV Group

Inventory Group

INV ID

Inventory ID

INV Name

Inventory Name

INV Task ID

Inventory Task ID

INV Task

Task Name

INV Data Source

Task Data Source

INV Status

Task Status

INV Is Latest?

Is this the latest Inventory within its Inventory Group?

Field

Description

SYS Domain

System Computer Domain

SYS Is Virtual Machine?

Is the Operating System a virtual machine (guest)?

SYS Is Virtual Host?

Is the Operating System a virtual host (hypervisor)?

SYS Is Deduped?

Is this System de-duped accross all Data Sources within its Inventory?

SYS Is Active?

Does the discovery tool report this System to be active?

Field

Description

SYS CPU Range (Mhz)

System CPU Speed Range in Megahertz

SYS CPUs Range

System Number of CPUs Range

SYS Cores Range

System Number of Cores Range

SYS RAM Range (MB)

System RAM Range in Megabytes

SYS HDD Range (GB)

System HDD Range in Gigabytes

SYS OS Uptime Range

System OS Uptime Range

Field

Description

OS Req OS Type

OS Type

OS Req OS Name

OS Name

OS Req OS Bit Mode

OS Bit Mode

OS Req Speed (Mhz)

OS System Requirements Speed (Mhz)

OS Req RAM (MB)

OS System Requirements RAM (MB)

OS Req Limit RAM (MB)

OS System Requirements Limit RAM (MB)

OS Req HDD (GB)

OS System Requirements HDD (GB)

SYS Is CPU Compatible?

Is the System CPU Compatible?

SYS Is RAM Compatible?

Is the System RAM Compatible?

SYS Is HDD Compatible?

Is the System HDD Compatible?

SYS OS Readiness

System OS Readiness

Field

Description

OS Family

Operating System Family

OS Manufacturer

Operating System Manufacturer

OS Name

Operating System Name

OS Major Version

Operating System Major Version

OS Minor Version

Operating System Minor Version

OS Service Pack

Operating System Service Pack

OS Edition

Operating System Edition

Field

Description

OS Is Supported? (calc.)

BDNA guideline to customers, as to the support status for a product

OS Supported Reason (calc.)

Reason determining the product support status. I.e. published date, calculated date, version sequence

OS EOL Year (calc.)

Calculated operating system version end-of-life date. Calculated year is based on Technopedia operating system published dates

OS EOL Quarter (calc.)

Calculated operating system version end-of-life date. Calculated quarter-in-year is based on Technopedia operating system published dates

OS EOL Month (calc.)

Calculated operating system version end-of-life date. Calculated month-in-year is based on Technopedia operating system published dates

OS EOL Date (calc.)

Calculated operating system version end-of-life date. Calculated date is based on Technopedia operating system published dates

OS Desupported? (calc.)

A flag that indicates whether the version has been discontinued/desupported

OS Version Order (calc.)

Number that indicates the sequential order by which this particular version was released during the history of the product

OS Max Versions (calc.)

The highest version order of all the versions that were released during the history of the operating system

OS Versions (calc.)

Number of versions between the particular version and the highest version of the operating system

Field

Description

CPU Manufacturer

CPU Manufacturer

CPU Manufacturer ID

CPU manufacturer identification number

CPU Model

CPU model (includes model number, speed/clock rate, and code name, if applicable)

CPU Model ID

CPU model identification number

CPU Cores

Number of cores per CPU chip

CPU Clock Rate

Clock speed or frequency at which a CPU is running (in MHz)

CPU ISA Bit Mode

Instruction Set Architecture (ISA) indicates whether the CPU architecture allows direct support for 32-bit or 64-bit data types and addresses

CPU Is Threaded?

Indicates whether the CPU supports multithreading

CPU Number of threads

Number of threads supported

Field

Description

CPU Licensing ID

CPU licensing identification number

CPU Maximum Sockets

Maximum number of CPU sockets available in the machine

CPU IBM PVU per core

IBM Processor Value Unit (PVU), a measure used to differentiate licensing of software on distributed processor technologies (defined by Processor Vendor Brand Type and Model Number)

Field

Description

HW Category

Hardware Category (Taxonomy)

HW Subcategory

Hardware Subcategory (Taxonomy)

HW Vendor Category

Product category per vendor

HW Manufacturer

Hardware Manufacturer

HW Manufacturer ID

Hardware manufacturer identification number

HW Product

Hardware product name

HW Product ID

Hardware product identification number

HW Model

Device model name/number

HW Model ID

Hardware model identification number

HW Supported OS

List of supported operating systems that can be run on the device

HW Max CPU sockets

Maximum number of CPU sockets available in the machine

Field

Description

HW Is Supported? (calc.)

BDNA guideline to customers, as to the support status for a product

HW Supported Reason (calc.)

Reason determining the product support status. I.e. published date, calculated date

HW EOL Year (calc.)

Calculated hardware end-of-life year. Calculated date is based on Technopedia hardware product published dates

HW EOL Quarter (calc.)

Calculated hardware end-of-life quarter-in-year. Calculated date is based on Technopedia hardware product published dates

HW EOL Month (calc.)

Calculated hardware end-of-life month-in-year. Calculated date is based on Technopedia hardware product published dates

HW EOL Date (calc.)

Calculated hardware end-of-life date. Calculated date is based on Technopedia hardware product published dates

Field

Description

HW Currency Code

Currency code as defined in ISO 4217, which is a standard published by the International Organization for Standardization, which delineates currency designators, country codes (alpha and numeric), and references to minor units

HW Minimum price

Minimum (lowest price) amongst all the prices that are available for this particular hardware model

HW Average price

Average price of all the prices that are available for this particular hardware model

HW Maximum price

Maximum (highest price) amongst all the prices that are available for this particular hardware model

Field

Description

HW Is Energy Star?

Indicates whether the device has earned the Energy Star certification or not

HW EPEAT Rating

Indicates which EPEAT certification the device has earned (i.e., Gold, Silver, or Bronze)

HW Power Type

Hardware Power Type (AC/DC)

HW AVG Power (W)

Hardware AVG power in Watts

HW Power Rating

Summary of the device various power ratings: Voltage, Frequency, Current

Field

Description

SW Category

Software category (first level of taxonomy)

SW Subcategory

Software subcategory (second level of taxonomy)

SW Vendor Category

Product category per vendor

SW Manufacturer

Software manufacturer name

SW Manufacturer ID

Software manufacturer identification number

SW Family

Brand/family the software product belongs to, if applicable

SW Name

Name of the software product

SW Name ID

Software name identification number

SW Component

Component of the software product, if applicable

SW Market Version

Software market version (version group)

SW Market Version ID

Software market version identification number

SW Version

Software version number/name associated with the release

SW Version ID

Software version identification number

SW Service Pack

Software patch, update, or service pack level, if applicable

SW Edition

Software product edition name

SW Edition ID

Software edition identification number

SW Release ID

Software release identification number

SW Is Licensable?

Indicates whether the software release is licensable or not

SW Is Suite?

Indicates whether the software product is a suite

SW Suite

Software suite

SW Is Suite Component?

Indicates whether the software product is a component of a suite

SW Suite Component

Software suite component

SW Cloud or On-Premise?

Identifies whether the product is 'Cloud Only', 'On-Premise-Only', or 'Cloud and On-Premise'

SW On-premise equivalent

Equivalent on-premise product for cloud product

SW Cloud equivalent

Equivalent cloud product for on-premise product

Field

Description

SW Former Product

Immediate former/previous iteration of the product within its lineage

SW Later Product

Imediate later/subsequent iteration of the product within its lineage

SW Oldest Product

Oldest iteration of the product within its lineage

SW Latest Product

Latest/newest iteration of the product within its lineage

Field

Description

SW Release Platform

Software release platform name

SW Platform Type

Indicates whether the software release supported platform is a server, a desktop, both a server/desktop, or a mainframe

Field

Description

SW Is Supported? (calc.)

BDNA guideline to customers, as to the support status for a product

SW Supported Reason (calc.)

Reason determining the product support status. I.e. published date, calculated date, version sequence

SW EOL Year (calc.)

Calculated software version end-of-life date. Calculated year is based on Technopedia software product published dates

SW EOL Quarter (calc.)

Calculated software version end-of-life date. Calculated quarter-in-year is based on Technopedia software product published dates

SW EOL Month (calc.)

Calculated software version end-of-life date. Calculated month-in-year is based on Technopedia software product published dates

SW EOL Date (calc.)

Calculated software version end-of-life date. Calculated date is based on Technopedia software product published dates

SW Desupported? (calc.)

A flag that indicates whether the version has been discontinued/desupported

SW Version Order (calc.)

Number that indicates the sequential order by which this particular version was released during the history of the product

SW Max Versions (calc.)

The highest version order of all the versions that were released during the history of the product

SW Versions (calc.)

Number of versions between the particular version and the highest version of the product

Field

Description

SW Support Policy

Name of the support policy, captured as published by the vendor

SW Support Stage

Name of the support stage/level, captured as published by the vendor

SW Support Stage Order

Order of the support stage/level

SW Support Stage Definition

Support stage definition

Field

Description

SW Currency Code

Currency code as defined in ISO 4217, which is a standard published by the International Organization for Standardization, which delineates currency designators, country codes (alpha and numeric), and references to minor units

SW Minimum price

Minimum (lowest price) amongst all the prices that are available for this particular software release

SW Average price

Average price of all the prices that are available for this particular software release

SW Maximum price

Maximum (highest price) amongst all the prices that are available for this particular software release

Field

Description

SW Win Readiness Type

Software Readiness for this Windows Version

SW Win Readiness Version

Software Readiness for this Windows Version

SW Win Readiness 32-Bit

Software Windows Readiness 32-Bit

SW Win Status 32-Bit

Software Windows Status 32-Bit

SW Win Compatible Version 32-Bit

Software Windows Compatible Version 32-Bit

SW Win Readiness 64-Bit

Software Windows Readiness 64-Bit

SW Win Status 64-Bit

Software Windows Status 64-Bit

SW Win Compatible Version 64-Bit

Software Windows Compatible Version 64-Bit

Field

Description

App Comp Manufacturer

Manufacturer for compatible VMware or Citrix

App Comp Name

Product for compatible VMware or Citrix

App Comp Version

Version for compatible VMware or Citrix

App Comp Edition

Edition for compatible VMware or Citrix

App Comp 32-bit Compatible?

Indicates whether it is 32-bit compatible or not

App Comp 64-bit Compatible?

Indicates whether it is 64-bit compatible or not

App Comp Status

Indicates whether it is compatible or not (1 = compatible)

App Comp Official

Indicates whether the compatibility is official (e.g., from Vmware official website)

App Comp Certification

Level of certification for the compatibility

App Comp Community

Percentage of community members that vote for 'Compatible' status

App Comp Difficulty

Difficulty of work required to make an application to be compatible

Field

Description

OSS Type

A license type identifies the high level nature of a license category: Open Source or Proprietary.

OSS Category

A license category, provides a major grouping for licenses, generally describing the relationship between the licensor and licensee.

OSS License

Short name of the licenses that apply to the component.

OSS Is Primary License?

Indicates whether a named license assigned to a component is the primary named license for that component.

OSS Keywords

General software categories, multi-value as a list.

OSS Source

Source of data

Field

Description

PRI Is Private?

Indicates whether the data being analyzed is private or not

PRI Type

Indicates the type of private data, options are: Proprietary item or Modified item

PRI Object

Name of the object that has private data. Hardware or Software

PRI Table

Name of the table that has private data.

PRI Attribute

Name of the attribute that has been edited.

Field

Description

SYS Count

Distinct Count of Systems

SYS Avg CPU (MHz)

Average CPU speed among assets being analyzed (Megahertz)

SYS Avg Number of CPUs

Average number of CPUs among assets being analyzed

SYS Avg Number of Cores

Average Number of Cores among assets being analyzed

SYS Avg RAM (MB)

Average RAM among assets being analyzed (Megabytes)

SYS Avg Total HDD (GB)

Average Total HDD among assets being analyzed (Gigabytes)

SYS Avg Available HDD (GB)

Average Available HDD among assets being analyzed (Gigabytes)

OS Distinct Release Count

Count of Distinct Operationg Systems

CPU IBM PVU per core

IBM Processor Value Unit (PVU) per core

HW Distinct Product Count

Count of Distinct Hardware Products

HW Distinct Model Count

Count of Distinct Hardware Models

HW Minimum price

Minimum (lowest price) amongst all the prices that are available for this particular hardware model

HW Average price

Average price of all the prices that are available for this particular hardware model

HW Maximum price

Maximum (highest price) amongst all the prices that are available for this particular hardware model

HW AVG Power (W)

Hardware AVG power in Watts

HW AC Power Avg

Average amount of power (energy per-unit of time) consumed by the device during typical use when it is connected to AC power (in watt or volt-amp)

HW AC Power Max

Peak/maximum amount of power (energy per-unit of time) consumed by the device when it is connected to AC power (in watt or volt-amp)

HW AC Heat Diss Avg (BTU/hr)

Average amount of heat per-unit of time generated by the device during typical use when it is connected to AC power (in BTU/hr)

HW AC Heat Diss Max (BTU/hr)

Peak/maximum amount of heat per-unit of time generated by the device when it is connected to AC power (in BTU/hr)

HW AC Input Low Voltage Min

Manufacturer 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)

HW AC Input Low Voltage Max

Manufacturer 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)

HW AC Input Low Current Min

Manufacturer 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)

HW AC Input Low Current Max

Manufacturer 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)

HW AC Input High Voltage Min

Manufacturer suggested AC electrical input requirements: Minimum voltage when the voltage switch is turned on the high range setting

HW AC Input High Voltage Max

Manufacturer suggested AC electrical input requirements: Maximum voltage when the voltage switch is turned on the high range setting

HW AC Input High Current Min

Manufacturer suggested AC electrical input requirements: Minimum current when the voltage switch is turned on the high range setting

HW AC Input High Current Max

Manufacturer suggested AC electrical input requirements: Maximum current when the voltage switch is turned on the high range setting

HW AC Frequency Min

Manufacturer suggested AC input requirements: Minimum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)

HW AC Frequency Max

Manufacturer suggested AC input requirements: Maximum frequency (whether the voltage switch is turned on low/high or when the device has no voltage switch)

HW DC Power Avg

Average amount of power (energy per-unit of time) consumed by the device during typical use when it is connected to DC power (in watt or volt-amp)

HW DC Power Max

Peak/maximum amount of power (energy per-unit of time) consumed by the device when it is connected to DC power (in watt or volt-amp)

HW DC Heat Diss Avg (BTU/hr)

Average amount of heat per-unit of time generated by the device during typical use when it is connected to AC power (in BTU/hr)

HW DC Heat Diss Max (BTU/hr)

Peak/maximum amount of heat per-unit of time generated by the device when it is connected to AC power (in BTU/hr)

HW DC Low Voltage

Manufacturer 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)

HW DC Low Current

Manufacturer 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)

HW DC High Voltage

Manufacturer suggested DC input requirements: Voltage when the voltage switch is turned on the high setting

HW DC High Current

Manufacturer suggested DC input requirements: Current when the voltage switch is turned on the high setting

HW Min Operating Temp (F)

Manufacturer suggested minimum temperature of the device during operation (in °F)

HW Max Operating Temp (F)

Manufacturer suggested peak/maximum temperature of the device during operation (in °F)

HW Min Non-Operating Temp (F)

Manufacturer suggested minimum temperature of the device when it is non-operational or in storage (in °F)

HW Max Non-Operating Temp (F)

Manufacturer suggested peak/maximum temperature of the device when it is non-operational or in storage (in °F)

HW Min Operating Humidity (%)

Manufacturer suggested minimum humidity of the device during operation (in percent)

HW Max Operating Humidity (%)

Manufacturer suggested peak/maximum humidity of the device during operation (in percent)

HW Min Non-Operating Humidity (%)

Manufacturer suggested minimum humidity of the device when it is non-operational or in storage (in percent)

HW Max Non-Operating Humidity (%)

Manufacturer suggested peak/maximum humidity of the device when it is non-operational or in storage (in percent)

SW Distinct Product Count

Count of Distinct Software Products

SW Distinct Version Count

Count of Distinct Software Versions

SW Distinct Edition Count

Count of Distinct Software Editions

SW Distinct Release Count

Count of Distinct Software Releases

SW Install Count

Count of Software Installations

SW Use Count

Count of Used Software Installations

SW Minimum price

Caution:SW Minimum price has been deprecated and is no longer supported. This description is provided here for reference purposes only.

Minimum (lowest price) amongst all the prices that are available for this particular software release

SW Average price

Caution:SW Average price has been deprecated and is no longer supported. This description is provided here for reference purposes only.

Average price of all the prices that are available for this particular software release

SW Maximum price

Caution:SW Maximum price has been deprecated and is no longer supported. This description is provided here for reference purposes only.

Maximum (highest price) amongst all the prices that are available for this particular software release