Inventory Object: ConsolidatedComputer

IT Asset Management (Cloud)

ConsolidatedComputer objects are uploaded to the ConsolidatedComputer table in the operations (inventory) database. Multiple imports will merge updated data with existing records, and add new records as applicable.

'ConsolidatedComputer' consolidates data for the Computer, VirtualMachine, Domain, User, Cluster and CloudInstance objects, providing a simpler way to populate this information. Any spreadsheet row that includes a 'HostComputerID' is making that row a virtual machine, and the import process expects that virtualization data will be provided.

Important: A validation error will occur when an optional property has been populated for an object type without providing the other mandatory values. For example, if an optional property of a virtual machine is populated, then the VM type must be provided too. However, not all computers are VMs, meaning it is feasible to leave all properties concerning a VM empty.

Attributes are listed here in alphabetical order.

Property | (associated object type)	Attributes	Notes
Account (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	The Account that is used to create the instance.
AffinityEnabled (VirtualMachine)	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).
AvailabilityZone (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	Location of the instance or host.
BIOSUUID (Computer)	A universally unique identifier. May be null.	The BIOS UUID of the computer (physical or virtual), as provided by the operating system.
CalculatedUser (Computer)	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 (Computer)	Alpha-numeric text (maximum 128 characters). May be null.	The chassis type of the device.
CloudServiceProvider (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). Mandatory. Database key.	A unique identifier for a cloud service provider record. Note: Two different cloud instances cannot have the same InstanceCloudID and CloudServiceProvider. 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.
ClusterID (ClusterNode)	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 (Cluster)	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 (Computer)	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 (Computer, ClusterNode, VirtualMachine, CloudServiceInstance)	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 (Computer)	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 (VirtualMachine)	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
CPUAffinity (VirtualMachine)	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 (VirtualMachine)	Unsigned integer (int). May be null.	The maximum CPU usage of the virtual machine (MHz).
DomainFlatName (Domain)	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 (Computer, Domain)	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 (Computer)	Alpha-numeric text (maximum 256 characters). May be null.	The email address associated with the device. Typically used for mobile devices.
FirmwareSerialNumber (Computer)	Alpha-numeric text (maximum 100 characters). May be null.	The Serial number in the system firmware such as BIOS, EEPROM etc.
HostComputerID (VirtualMachine, CloudServiceInstance)	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 (Computer, CloudServiceInstance)	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 (VirtualMachine)	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 (VirtualMachine)	Alpha-numeric text (maximum 128 characters). May be null.	The type (similar to model number) of the host, used for matching.
ImageID (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	The ID of the image used to launch the instance.
IMEI (Computer)	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.
InstanceAffinity (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	The affinity setting for the instance on the Dedicated Host.
InstanceCloudID (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). Mandatory. Database key.	The identifier used in the source connection for the cloud instance. Note: Two different cloud instances cannot have the same InstanceCloudID and CloudServiceProvider. 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.
InstanceTenancy (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	Identifies whether the current device is a dedicated instance, or if the instance is running on a dedicated host.
InstanceType (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	Cloud provider instance type.
IPAddress (Computer)	Alpha-numeric text (maximum 256 characters). May be null.	The IP address of the computer in IPv4 or IPv6 format.
InventoryDate (Computer, CloudServiceInstance)	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 (Computer, User)	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 (Computer, User)	Date/time field. May be null.	The date and time when the user last logged on to the computer.
LaunchTime (CloudServiceInstance)	Date/time field. May be null.	The time the cloud instance was launched or when the reserved instance started.
LifecycleMode (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	The time the instance was launched.
MACAddress (Computer, CloudServiceInstance)	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 (Computer)	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 (Computer, VirtualMachine)	Alpha-numeric text (maximum 128 characters). May be null.	The manufacturer of the computer.
MaxClockSpeed (Computer)	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 (VirtualMachine)	Unsigned integer (bigint). May be null.	The maximum memory usage of the virtual machine (bytes).
ModelNo (Computer, VirtualMachine)	Alpha-numeric text (maximum 128 characters). May be null.	The model number of the computer.
NetworkID (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	The ID of the Virtual Private Cloud.
NumberOfCores (Computer, CloudServiceInstance)	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.
NumberOfDisplayAdapters (Computer)	Unsigned integer (int). May be null.	The number of graphics cards in the computer.
NumberOfHardDrives (Computer, VirtualMachine)	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.
NumberOfLogicalProcessors (Computer)	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 (Computer, VirtualMachine)	Unsigned integer (int). May be null.	The number of network cards in the computer.
NumberOfProcessors (Computer, VirtualMachine)	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 (Computer)	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 (Computer, VirtualMachine)	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.
PartialNumberOfProcessors (Computer)	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 (Computer)	Alpha-numeric text (maximum 128 characters). May be null.	The phone number of the device. Used for mobile devices.
PoolName (VirtualMachine)	Alpha-numeric text (maximum 100 characters). May be null.	The name of the pool that the virtual machine belongs to.
PoolType (VirtualMachine)	Alpha-numeric text (maximum 100 characters). May be null.	The type of the pool that the virtual machine belongs to.
ProcessorType (Computer, VirtualMachine)	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.
Region (CloudServiceInstance)	Alpha-numeric text (maximum 256 characters). May be null.	The cloud instance or host region. Note: This is not related to the Location ownership property on the computer.
SerialNo (Computer)	Alpha-numeric text (maximum 100 characters). May be null.	The serial number of the computer.
ServicePack (Computer)	Alpha-numeric text (maximum 128 characters). May be null.	The service pack installed for the operating system.
ThreadsPerCore (CloudServiceInstance)	Unsigned integer (int). May be null.	The number of thread per core of the instance.
TotalDiskSpace (Computer)	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 (Computer)	Unsigned integer (bigint). May be null.	The total RAM in the computer, in bytes.
VMEnabledState (VirtualMachine, CloudServiceInstance)	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 (VirtualMachine)	Alpha-numeric text (maximum 256 characters). May be null.	Location of the virtual machine on the file system.
VirtualMachineType (VirtualMachine)	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 (VirtualMachine)	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.)