operatingSystem

Edit online

The operatingSystem table represents the software responsible for interacting with hardware devices.

The following table describes the operatingSystem table.

Table 1. operatingSystem table 
Column name Type Constraints Description

entityId

Integer

not null

The identifier of an operating system entity from the entityData table.

assetID

255-character string

Asset identifier for this entity.

assetTag

255-character string

Asset tag for this entity.

bootTime

64-bit integer

Time duration the operating system has been online.

buildLevel

255-character string

Build level of the operating system without any version or release information.

ciCategory

255-character string

Configuration item category for this entity.

ciRole

Tiny integer

Identifies the environment, or role, in which a configuration item (CI) resides. For example, if a CI is set aside for test purposes, then this column can be set to a value of Test. If a role is needed that is not defined in the enumeration for ciRole, then use the value Other.

configLastUpdate

255-character string

UTC date and time when the information was last altered in the source application.

currentTime

64-bit integer

Current® time of the instance of the operating system.

fqdn

255-character string

Fully-qualified host name assigned to the operating system. In cases where the datacenter does not implement the Domain Name System (DNS), the fully-qualified host name is the short name.

generalCIRole

255-character string

Environment, or role, in which a CI resides.

kernelArchitecture

255-character string

Raw details of the supported system architecture of the kernel component of the operating system.

kernelVersion

255-character string

Raw version of the kernel component of the operating system.

lastAuditState

Tiny integer
Last audit state for this device. Possible values are:
  • 0 Unknown
  • 1 Other
  • 2 Good
  • 3 No Physical CI
  • 4 No CMDB Record
  • 5 Inaccurate CMDB Record

lastAuditTime

Timestamp

Last audit time this entity.

lastLifecycleStateTime

Timestamp

Last lifecycle state time for this entity.

osLevel

Integer

Operating system level.

lifecycleState

Tiny integer
Lifecycle state for this device. Possible values are:
  • 0 Unknown
  • 1 Other
  • 2 Ordered
  • 3 Received
  • 4 In Test
  • 5 Tested
  • 6 Installed
  • 7 Enabled
  • 8 Disabled
  • 9 In Maintenance
  • 10 Retired
  • 11 Archived
  • 12 Accepted
  • 13 Draft
  • 14 Build
  • 15 Validate
  • 16 ProductionReady
  • 17 Production
  • 18 Sunset
  • 19 PostProduction
  • 20 Inventory
  • 21 Development
  • 22 Offline

majorVersion

Integer

Major version of the product, and generally specified as the first number in a version string (for example, in WebSphere® 6.1, the '6' is the major version).

modifier

Integer

Version specification that is normally tied to fixes within a software release, and is normally specified third in a version string. The Modifier may not always be specified, as in WebSphere 6.1.

name

255-character string

The textual name of the physical entity. The value of this object must be the name of the component as assigned by the local device and is suitable for use in commands entered at the console of the device. Depending on the physical component naming syntax of the device, this value might be a text name, for example console, or a single component number, for example a port number or a module number.

osConfidence

Integer

Field used by IBM Tivoli Application Dependency Discovery Manager.

osMode

255-character string

Current kernel bit architecture mode of the operating system.

osName

255-character string

String representation of the operating system name.

osVersion

255-character string

Raw text representation of the operating system version.

osId

Integer

Field used by IBM Tivoli Application Dependency Discovery Manager.

osRelease

Integer

Raw text representation of the operating system release.

systemGuid

255-character string

Globally Unique Identifier (GUID) for the operating system.

versionString

255-character string

Complete version specification of the entity, expressed as a single string.

virtualMemorySize

64-bit integer

Allocated size of memory that does not include physical memory size.