HP Systems Insight Manager 7.1 Database Tables

CIM_OperatingSystem table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTOperatingSystem_LUID
Partly identifies CIM_OperatingSystemBIGINTNodeID
Partly identifies CIM_OperatingSystemBIGINTSnapshotID
Equates to CIM_ComputerSystem.NVARCHAR(256)CSCreationClassName
The value of CIM_ComputerSystem.Name for this
NodeID
NVARCHAR(256)CSName
Equates to CIM_OperatingSystem.NVARCHAR(256)CreationClassName
The inherited Name serves as key of an operating
system instance within a computer system
NVARCHAR(256)Name
Time when the OperatingSystem was last bootedBIGINTLastBootupTime
OperatingSystem notion of the local date and time
of day
BIGINTLocalDateTime
A string describing the OperatingSystem version
number (The format of the version information is as
NVARCHAR(64)Version
follows: <Major Number>..<Minor
Number>.<Revision> or <Major Number>.<Minor
Number>.<Revision Letter>)
Inherited from CIM_ManagedElement.Description;
a textual description of an object
NVARCHAR(512)Description
An integer indicating the type of Operating System
(CIM_OSType enumeration. (0 = Unknown, 1 =
SMALLINTOSType
Other, 2 = MACOS, 3 = ATTUNIX, 4 = DGUX, 5 =
DECNT, 6 = Digital Unix, 7 = OpenVMS, 8 = HPUX,
9 = AIX, 10 = MVS, 11 = OS400, 12 = OS/2; 13
= JavaVM, 14 = MSDOS, 15 = WIN3x, 16 =
WIN95, 17 = WIN98, 18 = WINNT, 19 = WINCE,
20 = NCR3000, 21 = NetWare, 22 =OSF, 23 =
DC/OS, 24 = Reliant UNIX, 25 = SCO UnixWare,
26 = SCO OpenServer, 27 = Sequent, 28 = IRIX,
29 = Solaris, 30 = SunOS, 31 = U6000, 32 =
ASERIES, 33 = TandemNSK, 34 = TandemNT, 35
= BS2000, 36 = LINUX, 37 = Lynx, 38 = XENIX,
39 = VM/ESA, 40 = Interactive UNIX, 41 =
BSDUNIX, 42 = FreeBSD, 43 = NetBSD, 44 = GNU
Hurd, 45 = OS9, 46 = MACH Kernel, 47 = Inferno,
48 = QNX, 49 = EPOC, 50 = IxWorks, 51 =
VxWorks, 52 = MiNT, 53 = BeOS, 54 = HP MPE,
55 = NextStep, 56 = PalmPilot, 57 = Rhapsody, 58
= Windows 2000, 59 = Dedicated, 60 = OS/390,
61 = VSE, 62 = TPF, 63 = Windows (R) Me, 64 =
Caldera Open UNIX, 65 = OpendBSD, 66 = Not
Applicable)
Number of user sessions for which the operating
system is currently storing state information
INTNumberOfUsers
Number of licensed user sessions for which the
operating system is currently storing state information
INTNumberOfLicensedUsers
Number of process contexts currently loaded or
running on the operating system
INTNumberOfProcesses
Max number of process contexts the operating system
can support; if no fixed value, then 0
INTMaxNumberOfProcesses
26 HP SIM database tables