Inventory Object: ConsolidatedComputer

Property	Attributes	Notes
`AffinityEnabled`	Boolean (0 or 1). Default: 0.	Set this to `true` (or `1`) if this VM has affinity for its current host (so that it is unable to move to different host computers).
`BIOSUUID`	A universally unique identifier. May be null.	The BIOS UUID of the computer (physical or virtual), as provided by the operating system.
`CPUAffinity`	Alpha-numeric text (maximum 256 characters). May be null.	Contains a comma-separated list of processor numbers (Host Logical Processors) or ranges for which this virtual machine has affinity. Example: `1,3-5,8`
`CPUUsage`	Unsigned integer (`int`). May be null.	The maximum CPU usage of the virtual machine (MHz).
`CalculatedUser`	Alpha-numeric text (maximum 128 characters). May be null.	The domain/SAMAccountName of the calculated user. Some inventory systems calculate the user who owns a computer. For example, it might be the user who, over the last ten logins, logged in most often.
`ChassisType`	Alpha-numeric text (maximum 128 characters). May be null.	The chassis type of the device.
`ClusterID`	Unsigned integer (`bigint`). Mandatory. Database key.	The unique identifier for the cluster containing this computer. This must match the ClusterID used in the Cluster spreadsheet. If both the ClusterID and the ClusterNodeType do not match the data provided in the Cluster spreadsheet then the computer will not be associated with a cluster. Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
`ClusterNodeType`	Alpha-numeric text (maximum 128 characters). Default: 1. May be null.	The Cluster node type of the computer. Must be a (case insentitive) exact match for one of the values shown. If both the ClusterID and the ClusterNodeType do not match the data provided in the Cluster spreadsheet then the computer will not be associated with a cluster.
`ComplianceComputerType`	Alpha-numeric text (maximum 128 characters). May be null.	If you know that the computer is a virtual machine or VM host, record that data here. If you are unsure, leave this cell empty (NULL): this allows the system to infer the computer type (for example, a computer with VMs linked to it is inferred to be a VM host). If data comes from multiple inventory sources, leaving this value as null also allows the value to be inserted from another source. So, unless there is a very good reason, do not just specify 'Computer', but allow the inference rules to help.
`ComputerID`	Unsigned integer (`bigint`). Mandatory. Database key.	The unique identifier for a computer (either physical or virtual). This identifier can either be an integer or a string. Keep this consistent across multiple imports: it is used to track the computer over time.
`ComputerName`	Alpha-numeric text (maximum 256 characters).	The name of the computer. In Windows, this is the NetBIOS name of the local computer, as returned by `GetComputerName()`. For UNIX, it is the host name of the machine, as returned by `gethostname(2)`.
`CoreAffinity`	Alpha-numeric text (maximum 256 characters). May be null.	Contains a comma-separated list of core numbers (or ranges) for which this virtual machine has affinity. Cores are numbered sequentially up the sequence of processors. Example: `1,5-8,10`
`DomainFlatName`	Alpha-numeric text (maximum 100 characters). Mandatory. Database key.	The flatname of the domain of the computer. Example: 'mycompany'. Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
`DomainQualifiedName`	Alpha-numeric text (maximum 100 characters). Mandatory. Database key.	The fully qualified domain name for the computer. Example: 'prod.mycompany.eu'. Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
`EmailAddress`	Alpha-numeric text (maximum 256 characters). May be null.	The email address associated with the device. Typically used for mobile devices.
`FirmwareSerialNumber`	Alpha-numeric text (maximum 100 characters). May be null.	The Serial number in the system firmware such as BIOS, EEPROM etc.
`HostComputerID`	Alpha-numeric text (maximum 256 characters). Mandatory. Database key.	The ComputerID of the server this virtual machine is hosted on. This may be a string or an integer and must match the ComputerID for another computer in this spreadsheet. Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
`HostID`	Alpha-numeric text (maximum 100 characters). May be null.	The HostID hardware property for the server hosting this machine partition (when inventorying a machine partition such as Solaris Zone, AIX lPar, HP-UX nPar/vPar).
`HostIdentifyingNumber`	Alpha-numeric text (maximum 128 characters). May be null.	Virtual hosts may have an identifier that is unique only across that hardware model. It is less unique than the true hardware serial number, for example.
`HostType`	Alpha-numeric text (maximum 128 characters). May be null.	The type (similar to model number) of the host, used for matching.
`IMEI`	Alpha-numeric text (maximum 256 characters). May be null.	IMEI (International Mobile Equipment Identity) is a 15- or 17-digit code that uniquely identifies mobile phone sets. Leave blank (null) for other device types.
`IPAddress`	Alpha-numeric text (maximum 256 characters). May be null.	The IP address of the computer in IPv4 or IPv6 format.
`InventoryDate`	Date/time field. Default: getdate(). May be null.	The date (and optionally time) the computer last had inventory reported. This field is generally used for differential updates (that is, if the date/time has not changed since the previous import, the data record is not imported/updated).
`LastLoggedOnUser`	Alpha-numeric text (maximum 128 characters). Mandatory. Database key.	The DOMAIN/SAMAccountName of the user last logged onto the computer. Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
`LastLogonDate`	Date/time field. May be null.	The date and time when the user last logged on to the computer.
`MACAddress`	Alpha-numeric text (maximum 256 characters). May be null.	The MAC address of the computer. This may be a comma-separated list if there is more than one active network adapter in the system. Do not include inactive network adapters and network adapters with invalid MAC addresses.
`MachineID`	Alpha-numeric text (maximum 100 characters). May be null.	For AIX, it is the System ID. For HP-UX, it is the Machine/Software ID. It is unset for other platforms.
`Manufacturer`	Alpha-numeric text (maximum 128 characters). May be null.	The manufacturer of the computer.
`MaxClockSpeed`	Unsigned integer (`int`). May be null.	The maximum clock speed of the fastest processor in the computer in kHz. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.
`MemoryUsage`	Unsigned integer (`bigint`). May be null.	The maximum memory usage of the virtual machine (bytes).
`ModelNo`	Alpha-numeric text (maximum 128 characters). May be null.	The model number of the computer.
`NumberOfCores`	Unsigned integer (`int`). May be null.	The total number of cores in the computer. If there is more than one physical processor in the computer, then this would be the sum of the core counts for all the processors. For example, in a computer with two quad-core processors, this value would be 8. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.
`NumberOfDisplay Adapters`	Unsigned integer (`int`). May be null.	The number of graphics cards in the computer.
`NumberOfHardDrives`	Unsigned integer (`int`). May be null.	The number of physical hard drives in the computer. While the intent is physical drives, often this can end up being the number of disk partitions.
`NumberOfLogical Processors`	Unsigned integer (`int`). May be null.	The number of logical processors in the computer. This is the number of 'execution contexts' the operating system has access to. It will commonly be equivalent to the number processors in a single core, non-multi-threaded processor architecture, to the number of cores in a multi-core single threaded processor architecture, and to the number of threads in a multi-threaded processor architecture. For example, in a two processor, quad-core and hyper-threaded computer, this value would be 16. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.
`NumberOfNetworkCards`	Unsigned integer (`int`). May be null.	The number of network cards in the computer.
`NumberOfProcessors`	Unsigned integer (`int`). May be null.	The total number of physical processors (CPU) in the computer. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.
`NumberOfSockets`	Unsigned integer (`int`). May be null.	The number of physical sockets into which a processor may be placed in the computer. It is rare that an inventory source can know this value. If unset, it is typically approximated by the number of processors.
`OperatingSystem`	Alpha-numeric text (maximum 128 characters). May be null.	The operating system of the computer. For virtual machines, it is the configured operating system of the guest. Note that this operating system identification is not used for licensing.
`PartialNumberOf Processors`	Fractional number (`float`). May be null.	Used in processor-based licensing, this is the non-integer number of cores allocated to this partition or virtual machine. When this property is null, the 'NumberOfCores' is used. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.
`PhoneNumber`	Alpha-numeric text (maximum 128 characters). May be null.	The phone number of the device. Used for mobile devices.
`PoolName`	Alpha-numeric text (maximum 100 characters). May be null.	The name of the pool that the virtual machine belongs to.
`PoolType`	Alpha-numeric text (maximum 100 characters). May be null.	The type of the pool that the virtual machine belongs to.
`ProcessorType`	Alpha-numeric text (maximum 256 characters). May be null.	The descriptive string of the processor(s) in the computer. This may be a comma-separated list in the case where there is more than one physical processor in the system. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.
`SerialNo`	Alpha-numeric text (maximum 100 characters). May be null.	The serial number of the computer.
`ServicePack`	Alpha-numeric text (maximum 128 characters). May be null.	The service pack installed for the operating system.
`TotalDiskSpace`	Unsigned integer (`bigint`). May be null.	The total size of all hard drives in the computer in bytes. Note that this can be a very large number on modern systems. The maximum value for a bigint is 9,223,372,036,854,775,807, which can represent about 9.2 exabyte. While in practice it is unlikely that this size of storage capacity is reached for a single system, some systems can end up with large values through virtualized drives. Therefore, it is worth considering capping values when calculating total disk space, particularly when converting values from kilobytes or megabytes to bytes.
`TotalMemory`	Unsigned integer (`bigint`). May be null.	The total RAM in the computer, in bytes.
`VMEnabledState`	Alpha-numeric text (maximum 128 characters). Default: 4. May be null.	The operational state of the virtual machine. If present, the value must be a (case insensitive) exact match to one of the values shown.
`VMLocation`	Alpha-numeric text (maximum 256 characters). May be null.	Location of the virtual machine on the file system.
`VirtualMachineType`	Alpha-numeric text (maximum 100 characters). May be null.	The type of the virtual machine. If present, the value must be a (case insensitive) exact match to one of the values shown.
`VirtualMachineUUID`	Alpha-numeric text (maximum 256 characters). May be null.	The unique identifier of the virtual machine provided by the virtualization infrastructure. (This may have the same value as the 'BIOSUUID', or have byte order reversed, or be altogether different.)

AffinityEnabled

Boolean (0 or 1). Default: 0.

Set this to true (or 1) if this VM has affinity for its current host (so that it is unable to move to different host computers).

BIOSUUID

A universally unique identifier. May be null.

The BIOS UUID of the computer (physical or virtual), as provided by the operating system.

CPUAffinity

Alpha-numeric text (maximum 256 characters). May be null.

Contains a comma-separated list of processor numbers (Host Logical Processors) or ranges for which this virtual machine has affinity. Example: 1,3-5,8

CPUUsage

Unsigned integer (int). May be null.

The maximum CPU usage of the virtual machine (MHz).

CalculatedUser

Alpha-numeric text (maximum 128 characters). May be null.

The domain/SAMAccountName of the calculated user. Some inventory systems calculate the user who owns a computer. For example, it might be the user who, over the last ten logins, logged in most often.

ChassisType

Alpha-numeric text (maximum 128 characters). May be null.

The chassis type of the device.

ClusterID

Unsigned integer (bigint). Mandatory. Database key.

The unique identifier for the cluster containing this computer. This must match the ClusterID used in the Cluster spreadsheet. If both the ClusterID and the ClusterNodeType do not match the data provided in the Cluster spreadsheet then the computer will not be associated with a cluster.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.

ClusterNodeType

Alpha-numeric text (maximum 128 characters). Default: 1. May be null.

The Cluster node type of the computer. Must be a (case insentitive) exact match for one of the values shown. If both the ClusterID and the ClusterNodeType do not match the data provided in the Cluster spreadsheet then the computer will not be associated with a cluster.

ComplianceComputerType

Alpha-numeric text (maximum 128 characters). May be null.

If you know that the computer is a virtual machine or VM host, record that data here. If you are unsure, leave this cell empty (NULL): this allows the system to infer the computer type (for example, a computer with VMs linked to it is inferred to be a VM host). If data comes from multiple inventory sources, leaving this value as null also allows the value to be inserted from another source. So, unless there is a very good reason, do not just specify 'Computer', but allow the inference rules to help.

ComputerID

Unsigned integer (bigint). Mandatory. Database key.

The unique identifier for a computer (either physical or virtual). This identifier can either be an integer or a string. Keep this consistent across multiple imports: it is used to track the computer over time.

ComputerName

Alpha-numeric text (maximum 256 characters).

The name of the computer. In Windows, this is the NetBIOS name of the local computer, as returned by GetComputerName(). For UNIX, it is the host name of the machine, as returned by gethostname(2).

CoreAffinity

Alpha-numeric text (maximum 256 characters). May be null.

Contains a comma-separated list of core numbers (or ranges) for which this virtual machine has affinity. Cores are numbered sequentially up the sequence of processors. Example: 1,5-8,10

DomainFlatName

Alpha-numeric text (maximum 100 characters). Mandatory. Database key.

The flatname of the domain of the computer. Example: 'mycompany'.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.

DomainQualifiedName

Alpha-numeric text (maximum 100 characters). Mandatory. Database key.

The fully qualified domain name for the computer. Example: 'prod.mycompany.eu'.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.

EmailAddress

Alpha-numeric text (maximum 256 characters). May be null.

The email address associated with the device. Typically used for mobile devices.

FirmwareSerialNumber

Alpha-numeric text (maximum 100 characters). May be null.

The Serial number in the system firmware such as BIOS, EEPROM etc.

HostComputerID

Alpha-numeric text (maximum 256 characters). Mandatory. Database key.

The ComputerID of the server this virtual machine is hosted on. This may be a string or an integer and must match the ComputerID for another computer in this spreadsheet.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.

HostID

Alpha-numeric text (maximum 100 characters). May be null.

The HostID hardware property for the server hosting this machine partition (when inventorying a machine partition such as Solaris Zone, AIX lPar, HP-UX nPar/vPar).

HostIdentifyingNumber

Alpha-numeric text (maximum 128 characters). May be null.

Virtual hosts may have an identifier that is unique only across that hardware model. It is less unique than the true hardware serial number, for example.

HostType

Alpha-numeric text (maximum 128 characters). May be null.

The type (similar to model number) of the host, used for matching.

IMEI

Alpha-numeric text (maximum 256 characters). May be null.

IMEI (International Mobile Equipment Identity) is a 15- or 17-digit code that uniquely identifies mobile phone sets. Leave blank (null) for other device types.

IPAddress

Alpha-numeric text (maximum 256 characters). May be null.

The IP address of the computer in IPv4 or IPv6 format.

InventoryDate

Date/time field. Default: getdate(). May be null.

The date (and optionally time) the computer last had inventory reported. This field is generally used for differential updates (that is, if the date/time has not changed since the previous import, the data record is not imported/updated).

LastLoggedOnUser

Alpha-numeric text (maximum 128 characters). Mandatory. Database key.

The DOMAIN/SAMAccountName of the user last logged onto the computer.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.

LastLogonDate

Date/time field. May be null.

The date and time when the user last logged on to the computer.

MACAddress

Alpha-numeric text (maximum 256 characters). May be null.

The MAC address of the computer. This may be a comma-separated list if there is more than one active network adapter in the system. Do not include inactive network adapters and network adapters with invalid MAC addresses.

MachineID

Alpha-numeric text (maximum 100 characters). May be null.

For AIX, it is the System ID. For HP-UX, it is the Machine/Software ID. It is unset for other platforms.

Manufacturer

Alpha-numeric text (maximum 128 characters). May be null.

The manufacturer of the computer.

MaxClockSpeed

Unsigned integer (int). May be null.

The maximum clock speed of the fastest processor in the computer in kHz. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.

MemoryUsage

Unsigned integer (bigint). May be null.

The maximum memory usage of the virtual machine (bytes).

ModelNo

Alpha-numeric text (maximum 128 characters). May be null.

The model number of the computer.

NumberOfCores

Unsigned integer (int). May be null.

The total number of cores in the computer. If there is more than one physical processor in the computer, then this would be the sum of the core counts for all the processors. For example, in a computer with two quad-core processors, this value would be 8. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.

NumberOfDisplay Adapters

Unsigned integer (int). May be null.

The number of graphics cards in the computer.

NumberOfHardDrives

Unsigned integer (int). May be null.

The number of physical hard drives in the computer. While the intent is physical drives, often this can end up being the number of disk partitions.

NumberOfLogical Processors

Unsigned integer (int). May be null.

The number of logical processors in the computer. This is the number of 'execution contexts' the operating system has access to. It will commonly be equivalent to the number processors in a single core, non-multi-threaded processor architecture, to the number of cores in a multi-core single threaded processor architecture, and to the number of threads in a multi-threaded processor architecture. For example, in a two processor, quad-core and hyper-threaded computer, this value would be 16. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.

NumberOfNetworkCards

Unsigned integer (int). May be null.

The number of network cards in the computer.

NumberOfProcessors

Unsigned integer (int). May be null.

The total number of physical processors (CPU) in the computer. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.

NumberOfSockets

Unsigned integer (int). May be null.

The number of physical sockets into which a processor may be placed in the computer. It is rare that an inventory source can know this value. If unset, it is typically approximated by the number of processors.

OperatingSystem

Alpha-numeric text (maximum 128 characters). May be null.

The operating system of the computer. For virtual machines, it is the configured operating system of the guest. Note that this operating system identification is not used for licensing.

PartialNumberOf Processors

Fractional number (float). May be null.

Used in processor-based licensing, this is the non-integer number of cores allocated to this partition or virtual machine. When this property is null, the 'NumberOfCores' is used. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.

PhoneNumber

Alpha-numeric text (maximum 128 characters). May be null.

The phone number of the device. Used for mobile devices.

PoolName

Alpha-numeric text (maximum 100 characters). May be null.

The name of the pool that the virtual machine belongs to.

PoolType

Alpha-numeric text (maximum 100 characters). May be null.

The type of the pool that the virtual machine belongs to.

ProcessorType

Alpha-numeric text (maximum 256 characters). May be null.

The descriptive string of the processor(s) in the computer. This may be a comma-separated list in the case where there is more than one physical processor in the system. Note that a number of server-based licenses depend on complete details of the processor types, counts and speeds to calculate a correct license position.

SerialNo

Alpha-numeric text (maximum 100 characters). May be null.

The serial number of the computer.

ServicePack

Alpha-numeric text (maximum 128 characters). May be null.

The service pack installed for the operating system.

TotalDiskSpace

Unsigned integer (bigint). May be null.

The total size of all hard drives in the computer in bytes. Note that this can be a very large number on modern systems. The maximum value for a bigint is 9,223,372,036,854,775,807, which can represent about 9.2 exabyte. While in practice it is unlikely that this size of storage capacity is reached for a single system, some systems can end up with large values through virtualized drives. Therefore, it is worth considering capping values when calculating total disk space, particularly when converting values from kilobytes or megabytes to bytes.

TotalMemory

Unsigned integer (bigint). May be null.

The total RAM in the computer, in bytes.

VMEnabledState

Alpha-numeric text (maximum 128 characters). Default: 4. May be null.

The operational state of the virtual machine. If present, the value must be a (case insensitive) exact match to one of the values shown.

VMLocation

Alpha-numeric text (maximum 256 characters). May be null.

Location of the virtual machine on the file system.

VirtualMachineType

Alpha-numeric text (maximum 100 characters). May be null.

The type of the virtual machine. If present, the value must be a (case insensitive) exact match to one of the values shown.

VirtualMachineUUID

Alpha-numeric text (maximum 256 characters). May be null.

The unique identifier of the virtual machine provided by the virtualization infrastructure. (This may have the same value as the 'BIOSUUID', or have byte order reversed, or be altogether different.)