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

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