ExpiredImportedComputer Table

FlexNet Manager Suite 2020 R1 (On-Premises)

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 (max 4000 characters). 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.

FlexNet Manager Suite (On-Premises)

2020 R1