ConsolidatedComputer Template

‘ConsolidatedComputer’ consolidates data for the Computer, VirtualMachine, Domain, User and Cluster 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.

Table 1. Columns included with ConsolidatedComputer templates

Column

Details

ComputerID

Type: big integer. 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.

Destination:

ImportedComputer.ExternalID

ImportedVirtualMachine.VMComputerID

ImportedClusterNode.ComputerExternalID

ImportedCloudServiceInstance.ExternalComputerID

ComputerName

Type: text (max 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).

Destination:

ImportedComputer.ComputerName

DomainFlatName

Type: text (max 100 characters). Key. Nullable

The flatname of the domain of the computer. Example: ‘mycompany’.

Destination:

ImportedDomain.FlatName

DomainQualifiedName

Type: text (max 100 characters). Key. Nullable

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

Destination:

ImportedComputer.Domain

ImportedDomain.QualifiedName

BIOSUUID

Type: unique identifier. Nullable

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

Possible values:

93B5BE3B-88B0-450E-9F75-F6294210DFA0

Destination:

ImportedComputer.UUID

OperatingSystem

Type: text (max 128 characters). Nullable

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.

Destination:

ImportedComputer.OperatingSystem

ImportedVirtualMachine.GuestFullName

ServicePack

Type: text (max 128 characters). Nullable

The service pack installed for the operating system.

Destination:

ImportedComputer.ServicePack

EmailAddress

Type: text (max 256 characters). Nullable

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

Destination:

ImportedComputer.EmailAddress

PhoneNumber

Type: text (max 128 characters). Nullable

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

Destination:

ImportedComputer.PhoneNumber

Manufacturer

Type: text (max 128 characters). Nullable

The manufacturer of the computer hardware. Some examples include:

  • On Windows, the SMBios manufacturer (the WMI Manufacturer property of the ‘Win32_ComputerSystem’ class).
  • On Linux, ‘Manufacturer’ in the ‘System Information’ section resulting from the ‘dmidecode’ command. Sample command: ‘dmidecode -s system-manufacturer’
  • On Solaris x86, as for Linux, with failovers first to ‘sysinfo SI_HW_PROVIDER’ and then to ‘ModelNo’.
  • On Solaris SPARC, the ‘sysinfo SI_HW_PROVIDER’. Typically this value is ‘Sun_Microsystems’ or, more recently, ‘Oracle Corporation’. Failover to the ‘ModelNo’.
  • On HP-UX, the string literal ‘HP’.
  • On AIX, the ‘modelname’ system attribute preceding the comma character. For example, if the ‘modelname’ system attribute is ‘IBM,8202-E4B’, then use ‘IBM’. This value is typically ‘IBM’.

Destination:

ImportedComputer.Manufacturer

ImportedVirtualMachine.Manufacturer

ModelNo

Type: text (max 128 characters). Nullable

The model of the computer hardware or the virtual machine. This value is defined for the context of the current execution environment, rather than the physical server that may be hosting a virtual machine or partition. Examples:

  • On Windows, the SMBios product name. The WMI Model property of the Win32_ComputerSystem class.
  • On Linux, the SMBios product name read using the command ‘dmidecode -s system-product-name’. Specifically, the ‘System Information’ section and the ‘Product Name’ in that section is used.
  • On Solaris x86, as for Linux, with failover to the ‘sysinfo SI_PLATFORM’, stripping ‘SUNW’, and replacing hyphen characters with space characters.
  • On Solaris SPARC, the ‘openprom’ “banner-name” value read from ‘/dev/openprom’. Failover to the ‘sysinfo SI_PLATFORM’, stripping ‘SUNW’, and replacing hyphen characters with space characters.
  • On HP-UX, the ‘confstr _CS_MACHINE_MODEL’.
  • On AIX, the ‘modelname’ system attribute following the comma character. For example, if the ‘modelname’ system attribute is ‘IBM,8202-E4B’, then use ‘8202-E4B’.

Destination:

ImportedComputer.ModelNo

ImportedVirtualMachine.ModelNo

SerialNo

Type: text (max 100 characters). Nullable

The hardware serial number of the computer. The goal of this value is to be tied to the physical hardware, partition or virtual machine and to be as unique as possible across all computers in the organization. This is due to its use in tracking computers, particularly after an operating system rebuild. This value is also used to socialize computer inventory from different inventory sources, and is used to map virtual machine guest operating system inventory to the VM host on which the virtual machine is running. Example sources:

  • On Windows, the SMBios serial number. The WMI ‘SerialNumber’ property of the ‘Win32_BIOS’ class. Can fail over to the ‘SerialNumber’ property of the ‘Win32_SystemEnclosure’ class which is typically the same value.
  • On Linux, the SMBios serial number read using the command ‘dmidecode -s system-serial-number’. Specifically, the ‘System Information’ section and the ‘Serial Number’ in that section is used.
  • On Solaris 10 8/07 or later, for a non-global zone, the UUID value from the /etc/zones/index file. For a global zone, the same as Solaris 10 releases earlier than 8/07.
  • For Solaris 10 releases earlier than 8/07, the hexadecimal version of ‘SI_HW_SERIAL’ with an appended hyphen character followed by the Zone’s name. For example, ‘838bfc7b-global’ or ‘838bfc7b-myzone’.
  • For Solaris 8 and 9, The hexadecimal version of ‘SI_HW_SERIAL’.
  • For Mac OS X, the serial number of the machine as printed on the packaging and found in “About this Mac” from the desktop.
  • For HP-UX, the ‘confstr _CS_PARTITION_IDENT’ partition identifier if it is an nPar or vPar, or ‘_CS_MACHINE_IDENT’ if not; with a failover to the machine serial number, and a final failover to the ‘uname’ machine identification number.
  • For AIX, the ‘id_to_partition’ system attribute, starting from the third character (strips a ‘0X’ from the start). For example, if the ‘id_to_partition’ system attribute is ‘0X0473409002F7B201’ then use ‘0473409002F7B201’.

Destination:

ImportedComputer.SerialNo

ChassisType

Type: text (max 128 characters). Nullable

The type of case of the computer. The value must be a (case insensitive) exact match for one of the values shown. Note that some license types use this information to optimize the licensing position, particularly with desktop and laptop computers.

Destination:

ImportedComputer.ChassisType

TotalMemory

Type: big integer. Nullable

The total RAM in the computer, in bytes.

Destination:

ImportedComputer.TotalMemory

NumberOfDisplayAdapters

Type: integer. Nullable

The number of graphics cards in the computer.

Destination:

ImportedComputer.NumberOfDisplayAdapters

VirtualMachineUUID

Type: text (max 256 characters). Nullable

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

Destination:

ImportedVirtualMachine.UUID

IMEI

Type: text (max 256 characters). Nullable

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.

Destination:

ImportedComputer.IMEI

NumberOfProcessors

Type: integer. Nullable

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.

Destination:

ImportedComputer.NumberOfProcessors

ImportedVirtualMachine.NumberOfProcessors

ProcessorType

Type: text (max 256 characters). Nullable

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.

Destination:

ImportedComputer.ProcessorType

ImportedVirtualMachine.ProcessorType

MaxClockSpeed

Type: integer. Nullable

The maximum clock speed of the fastest processor in the computer in megahertz. 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.

Destination:

ImportedComputer.MaxClockSpeed

NumberOfCores

Type: integer. Nullable

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.

Destination:

ImportedComputer.NumberOfCores

ImportedCloudServiceInstance.CoreCount

NumberOfSockets

Type: integer. Nullable

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.

Destination:

ImportedComputer.NumberOfSockets

NumberOfLogicalProcessors

Type: integer. Nullable

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.

Destination:

ImportedComputer.NumberOfLogicalProcessors

PartialNumberOfProcessors

Type: decimal. Nullable

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.

Possible values:

120.45

Destination:

ImportedComputer.PartialNumberOfProcessors

NumberOfHardDrives

Type: integer. Nullable

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.

Destination:

ImportedComputer.NumberOfHardDrives

ImportedVirtualMachine.NumberOfHardDrives

TotalDiskSpace

Type: big integer. Nullable

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.

Destination:

ImportedComputer.TotalDiskSpace

NumberOfNetworkCards

Type: integer. Nullable

The number of network cards in the computer.

Destination:

ImportedComputer.NumberOfNetworkCards

ImportedVirtualMachine.NumberOfNetworkCards

IPAddress

Type: text (max 256 characters). Nullable

The IP address of the computer in IPv4 or IPv6 format. 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 IP addresses. Examples:

  • ‘69.89.31.226’
  • ‘2002:4559:1FE2::4559:1FE2’

Destination:

ImportedComputer.IPAddress

MACAddress

Type: text (max 256 characters). Nullable

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.

Destination:

ImportedComputer.MACAddress

ImportedCloudServiceInstance.MACAddress

LastLoggedOnUser

Type: text (max 128 characters). Key. Nullable

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

Destination:

ImportedComputer.LastLoggedOnUser

ImportedUser.ExternalID

ImportedUser.UserName (Element 2 after splitting on '\')

ImportedUser.Domain (Element 1 after splitting on '\')

ImportedUser.SAMAccountName (Element 2 after splitting on '\')

LastLogonDate

Type: datetime. Nullable

The date and time when the user last logged on to the computer. The date must be entered in one of the supported formats.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

CalculatedUser

Type: text (max 128 characters). Nullable

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.

Destination:

ImportedComputer.CalculatedUser

HostComputerID

Type: text (max 256 characters). Key. Nullable

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.

Destination:

ImportedVirtualMachine.HostComputerID

ImportedCloudServiceInstance.HostComputerID

VirtualMachineType

Type: text (max 100 characters). Nullable

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

Possible values:

  • VMware
  • HyperV
  • LPAR
  • WPAR
  • nPar
  • vPar
  • SRP
  • Zone
  • Unknown
  • Oracle VM
  • AWS EC2
  • Linux KVM

Destination:

ImportedVirtualMachine.VirtualMachineType

VMEnabledState

Type: text (max 128 characters). Nullable

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

Possible values:

  • Started
  • Stopped
  • Suspended
  • Unknown
  • Terminated

Destination:

ImportedVirtualMachine.VMEnabledStateID

ImportedCloudServiceInstance.VMEnabledStateID

AffinityEnabled

Type: boolean. Nullable

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). Leave blank (null) for a physical computer.

Possible values:

true, false, 0 or 1

Destination:

ImportedVirtualMachine.AffinityEnabled

CPUAffinity

Type: text (max 256 characters). Nullable

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

Destination:

ImportedVirtualMachine.CPUAffinity

CoreAffinity

Type: text (max 256 characters). Nullable

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

Destination:

ImportedVirtualMachine.CoreAffinity

ComplianceComputerType

Type: text (max 128 characters). Nullable

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.

Possible values:

  • Computer
  • VM Host
  • Virtual Machine
  • Remote Device
  • Mobile Device
  • VDI Template
  • Container Image

Destination:

ImportedComputer.ComplianceComputerTypeID

HostIdentifyingNumber

Type: text (max 128 characters). Nullable

A physical server may have an identifier that is unique only across that hardware model, and may be less unique than the true hardware serial number, for example. This value is typically set for physical machines only, which include virtualization hosts, partitioned server hosts, and standalone machines. For a partitioned server, this value can be reported by each of the partitions on that server, such that a record of the physical computer can be created using one of the instances of this value. This value is used for matching computers.

Destination:

HostType

Type: text (max 128 characters). Nullable

The type of the physical host computer. This value is similar to the model number, but it is always for the physical server that an execution context may be running on. Therefore, this will generally be a known value for standalone machines and partitions, but it will not be known for virtual machines. This value is used for matching computers. Examples:

  • ‘i86pc’
  • ‘Sun-Fire-T1000’
  • ‘rx7620’
  • ‘785’ (for a 9000/785/C3700)
  • ‘8202’ (for an IBM,8202-E4B).

Destination:

VMLocation

Type: text (max 256 characters). Nullable

Location of the virtual machine on the file system.

Destination:

ImportedVirtualMachine.VMLocation

PoolName

Type: text (max 100 characters). Nullable

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

Destination:

ImportedVirtualMachine.PoolName

PoolType

Type: text (max 100 characters). Nullable

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

Possible values:

  • Folder
  • Datacenter
  • ComputeResource
  • HostSystem
  • ResourcePool
  • VirtualMachine
  • PhysicalSharedPool
  • VirtualSharedPool
  • LPAR
  • RSET
  • ClusterComputeResource
  • PSET

Destination:

ImportedVirtualMachine.PoolType

CPUUsage

Type: integer. Nullable

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

Destination:

ImportedVirtualMachine.CPUUsage

MemoryUsage

Type: big integer. Nullable

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

Destination:

ImportedVirtualMachine.MemoryUsage

InventoryDate

Type: datetime. Nullable

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). The date must be entered in one of the supported formats.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

ImportedComputer.InventoryDate

ImportedCloudServiceInstance.InventoryDate

ClusterID

Type: big integer. Key. Nullable

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.

Destination:

ImportedClusterNode.ClusterExternalID

ClusterNodeType

Type: text (max 128 characters). Nullable

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.

Possible values:

  • Active
  • Passive
  • Hot
  • Warm
  • Cold

Destination:

ImportedClusterNode.ClusterNodeTypeID

HostID

Type: text (max 100 characters). Nullable

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

Destination:

ImportedComputer.HostID

ImportedCloudServiceInstance.HostID

FirmwareSerialNumber

Type: text (max 100 characters). Nullable

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

Destination:

ImportedComputer.FirmwareSerialNumber

MachineID

Type: text (max 100 characters). Nullable

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

Destination:

ImportedComputer.MachineID

InstanceCloudID

Type: text (max 256 characters). Key. Nullable

The ID of the cloud instance.

Destination:

ImportedCloudServiceInstance.InstanceCloudID

CloudServiceProvider

Type: text (max 256 characters). Key. Nullable

A unique identifier for a cloud service provider record.

Destination:

ImportedCloudServiceInstance.CloudServiceProvider

InstanceAffinity

Type: text (max 256 characters). Nullable

The affinity setting for the instance on the Dedicated Host.

Destination:

ImportedCloudServiceInstance.InstanceAffinity

ImageID

Type: text (max 256 characters). Nullable

The ID of the image used to launch the instance.

Destination:

ImportedCloudServiceInstance.ImageID

LaunchTime

Type: datetime. Nullable

The time the cloud instance was launched or the Reserved Instance started.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

ImportedCloudServiceInstance.LaunchTime

NetworkID

Type: text (max 256 characters). Nullable

The ID of the Virtual Private Cloud.

Destination:

ImportedCloudServiceInstance.NetworkID

LifecycleMode

Type: text (max 256 characters). Nullable

The time the instance was launched.

Destination:

ImportedCloudServiceInstance.LifecycleMode

Account

Type: text (max 256 characters). Nullable

The Account that is used to create the instance.

Destination:

ImportedCloudServiceInstance.Account

ThreadsPerCore

Type: integer. Nullable

The number of thread per core of the instance.

Destination:

ImportedCloudServiceInstance.ThreadsPerCore

InstanceType

Type: text (max 256 characters). Nullable

Cloud provider instance type.

Destination:

ImportedCloudServiceInstance.InstanceType

Region

Type: text (max 256 characters). Nullable

Region of the instance or host.

Destination:

ImportedCloudServiceInstance.Region

AvailabilityZone

Type: text (max 256 characters). Nullable

Location of the instance or host.

Destination:

ImportedCloudServiceInstance.AvailabilityZone

InstanceTenancy

Type: text (max 256 characters). Nullable

Instance tenancy of the instance or host

Destination:

ImportedCloudServiceInstance.InstanceTenancy