operatingSystem

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.