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.