ExpiredImportedComputer Table

The ExpiredImportedComputer table holds all of the computers which have been retrieved from the source connections and are expired.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ExpiredImportedComputer table

Database Column

Details

ComplianceConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table.

ExternalID

Type: big integer. Key. Nullable

The identifier used in the source connection for the computer.

ComputerName

Type: text (max 256 characters). Nullable

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

Domain

Type: text (max 100 characters). Nullable

The domain of the computer.

OperatingSystem

Type: text (max 128 characters). Nullable

The operating system of the computer.

ServicePack

Type: text (max 128 characters). Nullable

The service pack installed for the operating system.

NumberOfProcessors

Type: integer. Nullable

The number of processors in the computer.

ProcessorType

Type: text (max 256 characters). Nullable

The type of processor in the computer.

MaxClockSpeed

Type: integer. Nullable

The maximum clock speed of the fastest processor in the computer.

NumberOfCores

Type: integer. Nullable

The number of cores in the computer.

TotalMemory

Type: big integer. Nullable

The total RAM in the computer, in bytes.

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.

NumberOfHardDrives

Type: integer. Nullable

The number of hard drives in the computer.

TotalDiskSpace

Type: big integer. Nullable

The total size of all hard drives in the computer.

NumberOfNetworkCards

Type: integer. Nullable

The number of network cards in the computer.

NumberOfDisplayAdapters

Type: integer. Nullable

The number of graphics cards in the computer.

IPAddress

Type: text (max 256 characters). Nullable

The IP address of the computer.

MACAddress

Type: text (max 256 characters). Nullable

The MAC address of the computer.

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’.
ModelNo

Type: text (max 128 characters). Nullable

The model number of the computer.

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’.
HostID

Type: text (max 100 characters). Nullable

An identifier for the host of the computer (when the computer is a virtual machine).

LastLoggedOnUser

Type: text (max 128 characters). Nullable

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

InventoryDate

Type: datetime. Nullable

The date the computer last had inventory reported.

HardwareInventoryDate

Type: datetime. Nullable

The date (and optionally time) when the hardware was last inventoried. For automated/scheduled data uploads through an inventory beacon, make sure that inventory dates are kept current, as they are used to report out-of-date inventory sources. For a one-time upload to the central application server, leave inventory dates empty (null). At each import from the saved file, the import date is used as the inventory date, which prevents the inventory becoming stale.

ServicesInventoryDate

Type: datetime. Nullable

The date when services (for example, Oracle) were last scanned on this computer. For automated/scheduled data uploads through an inventory beacon, make sure that inventory dates are kept current, as they are used to report out-of-date inventory sources. For a one-time upload to the central application server, leave inventory dates empty (null). At each import from the saved file, the import date is used as the inventory date, which prevents the inventory becoming stale.

InventoryAgent

Type: text (max 128 characters)

The name of the person or tool that performed the last inventory.

ComplianceComputerID

Type: integer. Nullable

Identifier of the computer in the ComplianceComputer table that this imported computer links to. This is populated by the import process and does not need to be provided by the source connections.

ComplianceDomainID

Type: integer. Nullable

Identifier of the domain in the ComplianceDomain table that this computer belongs to. This is populated by the import process and does not need to be provided by the source connections.

IncompleteRecord

Type: boolean. Nullable

Used to identify records which do not have all information specified. Primarily used for ManageSoft source connections where the domain name was not reliably reported.

NumberOfSockets

Type: integer. Nullable

The number of sockets in the computer.

PartialNumberOfProcessors

Type: decimal. Nullable

The fractional processor count available to this computer.

UntrustedSerialNo

Type: boolean

Use when this computer is known to have a serial number from a data source that should not be trusted.

FullDetailsFromExternalID

Type: big integer. Nullable

If this computer is marked as incomplete, and some of its properties are updated from another computer, record the external ID if the full computer.

FullDetailsFrom ComplianceConnectionID

Type: integer. Nullable

If this computer is marked as incomplete, and some of its properties are updated from another computer, record the connection ID if the full computer.

ComplianceComputerTypeID

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

ILMTAgentID

Type: big integer. Nullable

Store the unique ID used by the ILMT agent on this device, if the inventory source is aware of this value.

FNMPComputerUID

Type: unique identifier. Nullable

The unique identifier generated for the computer from the IM database. This property should only be populated by the ManageSoft inventory adapter.

HostIdentifyingNumber

Type: text (max 128 characters). Nullable

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

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

Type: integer. Nullable

The number of logical processors in the computer.

IsRemoteACLDevice

Type: boolean

Used to determine if the current record is a remote ACL based device.

IsDuplicate

Type: boolean

Used to identify that imported computer is a duplicate of another, whereby a new computer will not created.

LegacySerialNo

Type: text (max 100 characters). Nullable

A previous serial number of this computer that can also be used for matching.

UUID

Type: unique identifier. Nullable

The BIOS UUID of the computer.

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.

PhoneNumber

Type: text (max 128 characters). Nullable

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

EmailAddress

Type: text (max 256 characters). Nullable

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

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.

LastSuccessful InventoryDate

Type: datetime. Nullable

For incremental imports, this represents the inventory date of the computer in the source at the time this record was last successfully imported. If the import procedure has failed, this may be different to the inventory date. At the end of a successful incremental import, this value is updated to match the inventory date. If no value is present in this field, either there has not been a successful import of this computer or the reader for this record is not using an incremental update model.

MDScheduleGeneratedDate

Type: datetime. Nullable

The last time the managed device schedule was regenerated.

MDScheduleContainsPVUScan

Type: boolean. Nullable

Does this managed device include an event in its current schedule for running extra IBM PVU hardware scans.

FirmwareSerialNumber

Type: text (max 100 characters). Nullable

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

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.

IgnoredDueToLicense

Type: boolean

True if this machine is not imported into compliance computer table due to license limitation

CloudServiceProvider

Type: text (max 256 characters). Nullable

The cloud service provider for the computer record.

CSPMetadataJsonBlob

Type: text. Nullable

Contains the json blob for an Imported Computer record

AgentVersion

Type: text (max 32 characters). Nullable

The version of the agent which generated the inventory package.