2.29 NC_OperatingSystem Table

The NC_OperatingSystem table contains inventory data about operating systems.

Column

Key

Type

Null

Description

ComponentOID

PK, FK

binary(16)

No

An internal ID number used as a primary key.

OSInternalVersion

 

nvarchar(8)

 

Internal version string for the operating system.

ServicePack

nvarchar(8)

The service pack string.

BootDriveLetter

nvarchar(1)

The drive from which the operating system started (without a colon).

BootTime

datetime

The timestamp of the boot time.

SecondsSinceBoot

int

The seconds elapsed since boot time.

NOTE:The ComponentOID foreign key references the ComponentOID primary key column of the NC_SoftwareComp table.