Systems Inventory Manager Data Structures Manufacturing Part Number : 5187-0789 May 2002 © Copyright 2002 Hewlett-Packard Company.
Legal Notices The information in this document is subject to change without notice. Hewlett-Packard makes no warranty of any kind with regard to this manual, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Hewlett-Packard shall not be held liable for errors contained herein or direct, indirect, special, incidental or consequential damages in connection with the furnishing, performance, or use of this material.
Trademark Notices ActivePerl is a registered trademark of ActiveState Tool Corporation. Apple and Macintosh are trademarks of Apple Computer, Inc., registered in the United States and other countries. AppleShare is a registered trademark of Apple Computer, Inc. CHAMELEON is a trademark of NetManage, Inc. DIGITAL and PATHWORKS are trademarks of Digital Equipment Corporation. DiskAccess is a registered trademark of Intergraph. EXCURSION is a trademark of Digital Equipment Corporation.
Publication History The manual’s publication date and part number indicate its current edition. The publication date will change when a new edition is released. The manual part number will change when extensive changes are made. To ensure that you receive the new editions, you should subscribe to the appropriate product support service. See your HP sales representative for details. • Systems Inventory Manager Data Structures May 2002, Edition 1 Software depot web site at http://software.hp.
Conventions We use the following typographical conventions. audit (5) An HP-UX manpage. audit is the name and 5 is the section in the HP-UX Reference. On the web and on the Instant Information CD, it may be a hot link to the manpage itself. From the HP-UX command line, enter “man audit” or “man 5 audit” to view the manpage. See man (1). Book Title The title of a book. On the web and on the Instant Information CD, it may be a hot link to the book itself. Emphasis Text that is emphasized.
Glossary and Acronyms The following terms and acronyms are used in this guide: CIM Common Information Model DMI Desktop Management Interface DNS Domain Name Service GUI graphical user interface NIS Network Information System NTP Network Time Protocol SIM Systems Inventory Manager 6
Contents 1. Data Structures Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Category Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Data Table Legend . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents 8
1 Data Structures Introduction The Systems Inventory Manager (SIM) is an inventory collection and management web application that can collect over 600 different system attributes. Given that the volume of data you can collect is extremely large, SIM uses the Common Information Model (CIM) to logically group the data. SIM organizes the data into seven groups of information that are further divided into 24 categories. See Table 1-1, “Data Groups & Categories,” on page 10.
Data Structures Introduction Table 1-1 Data Groups & Categories Group Name System Category Name ComputerSystem OperatingSystem BaseKernelParameter Processor Memory LogicalMemory OperatingSystem* (memory attributes only) I/O Devices Device Storage File System FileSystem LVMLogicalVolume LVMPhysicalVolume LVMPhysicalVolumeGroup LVMVolumeGroup Network DNSAdminDomain IPRoute NetworkAdapter NISAdminDomain NTPAdminDomain Software BundleContents Bundle Products Fileset Process Process OperatingSyst
Data Structures Introduction Category Design This section outlines the criteria used to define the categories, the definition of filter attributes, and the GUI display attributes. The implications of these filters on the Comparison Reports are also outlined. Because the number of attributes that data collection engine collects can be high, the number of attributes displayed on the initial screens are limited. As you progress through screens, the level of detail increases to more specific data groupings.
Data Structures Data Table Legend Data Table Legend Each data table contains the following information: • Group Name: One of the seven main groups of information. • Category Name: One of 24 categories of information. It is the actual table name used in the database. • Single Row/Multiple Rows: Defines if the data set is a single row or multiple rows for a selected data snapshot. • Table Attributes: Some of the 600 different system attributes.
Data Structures System Categories & Data Tables System Categories & Data Tables The System group contains the following categories and structure in the data tables: • System: ComputerSystem • System: OperatingSystem • System: BaseKernelParameter • System: Processor Table 1-2 System: ComputerSystem table Group Name: System Category Name: ComputerSystem Single Row Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters ComputerSystemID Caption ~ ~ Description ~ ~ Ins
Data Structures System Categories & Data Tables Table 1-2 System: ComputerSystem table (Continued) Group Name: System Category Name: ComputerSystem PowerState ~ ~ WakeUpType ~ ~ PrimaryOwnerPager HP-UX HP-UX SecondaryOwnerName HP-UX HP-UX SecondaryOwnerContact HP-UX HP-UX SecondaryOwnerPager HP-UX HP-UX SerialNumber HP-UX HP-UX IdentificationNumber HP-UX HP-UX Location HP-UX HP-UX NodeID SnapshotID Table 1-3 System: OperatingSystem table Group Name: System Category Name: Op
Data Structures System Categories & Data Tables Table 1-3 System: OperatingSystem table (Continued) Group Name: System Category Name: OperatingSystem+ LastBootUpTime HP-UX HP-UX LocalDateTime ~ ~ CurrentTimeZone ~ ~ CurrentTimeZoneDescription HP-UX HP-UX NumberOfLicensedUsers ~ ~ NumberOfUsers HP-UX HP-UX NumberOfProcesses HP-UX HP-UX MaxNumberOfProcesses HP-UX HP-UX TotalSwapSpaceSize ~ ~ TotalVirtualMemorySize ~ ~ FreeVirtualMemory ~ ~ FreePhysicalMemory ~ ~ TotalVi
Data Structures System Categories & Data Tables Table 1-4 System: BaseKernelParameter table (Continued) Group Name: System Description Category Name: BaseKernelParameter ~ ~ SettingID HP-UX HP-UX OldName ~ ~ Module ~ ~ CurrentValue HP-UX HP-UX PendingValue ~ ~ PlannedValue ~ ~ LastBootValue ~ ~ DefaultValue ~ ~ Minimum HP-UX HP-UX Maximum HP-UX HP-UX DynamicFlag HP-UX HP-UX Flags HP-UX HP-UX NodeID SnapshotID Table 1-5 System: Processor table Group Name: System C
Data Structures System Categories & Data Tables Table 1-5 System: Processor table (Continued) Group Name: System Category Name: Processor CreationClassName ~ ~ DeviceID ~ ~ PowerManagementSupported ~ ~ PowerManagementCapabilities ~ ~ Availability ~ ~ StatusInfo ~ ~ LastErrorCode ~ ~ ErrorDescription ~ ~ ErrorCleared ~ ~ OtherIdentifyingInfo ~ ~ PowerOnHours ~ ~ TotalPowerOnHours ~ ~ IdentifyingDescriptions ~ ~ AdditionalAvailability ~ ~ MaxQuiesceTime ~ ~ Rol
Data Structures System Categories & Data Tables Table 1-5 System: Processor table (Continued) Group Name: System Category Name: Processor SnapshotID 18 Chapter 1
Data Structures Memory Categories & Data Tables Memory Categories & Data Tables The Memory group contains the following categories and structure in the data tables: • Memory: LogicalMemory • Memory: Operating System Table 1-6 Memory: LogicalMemory table Group Name: Memory Category Name: LogicalMemory Single Row Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters SwapSpaceName HP-UX HP-UX SwapType HP-UX HP-UX LogicalMemoryID SwapPriority HP-UX HP-UX HP-UX SwapS
Data Structures Memory Categories & Data Tables Table 1-7 Memory: OperatingSystem table (Continued) Group Name: Memory Category Name: OperatingSystem** SizeStoredInPagingFiles ~ FreeSpaceInPagingFiles ~ MaxProcessMemorySize ~ *Filter attributes are controlled at OperatingSystem category only. **Attributes do not display until the system collects data.
Data Structures I/O Devices Categories & Data Tables I/O Devices Categories & Data Tables The I/O Devices group contains the following categories and structure in the data tables: • I/O Devices: Device • I/O Devices: Storage Table 1-8 I/O Devices: Device table Group Name: I/O Devices Category Name: Device Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters HP-UX HP-UX DeviceID Type Caption ~ Description ~ HP-UX HP-UX InstallDate ~ ~ Name ~ ~ S
Data Structures I/O Devices Categories & Data Tables Table 1-8 I/O Devices: Device table (Continued) Group Name: I/O Devices Category Name: Device IdentifyingDescriptions ~ ~ AdditionalAvailability ~ ~ MaxQuiesceTime ~ ~ Errors HP-UX HP-UX HardwarePath HP-UX HP-UX HardwareType HP-UX HP-UX DeviceClass HP-UX HP-UX Driver HP-UX HP-UX NodeID SnapshotID Table 1-9 I/O Devices: Storage table Group Name: I/O Devices Category Name: Storage Multiple Rows Table Attributes Filter Para
Data Structures I/O Devices Categories & Data Tables Table 1-9 I/O Devices: Storage table (Continued) Group Name: I/O Devices Category Name: Storage Availability ~ ~ StatusInfo ~ ~ LastErrorCode ~ ~ ErrorDescription ~ ~ ErrorCleared ~ ~ OtherIdentifyingInfo ~ ~ PowerOnHours ~ ~ TotalPowerOnHours ~ ~ IdentifyingDescriptions ~ ~ AdditionalAvailability ~ ~ MaxQuiesceTime ~ ~ Capabilities ~ ~ CapabilityDescriptions ~ ~ ErrorMethodology ~ ~ CompressionMethod ~ ~
Data Structures I/O Devices Categories & Data Tables Table 1-9 I/O Devices: Storage table (Continued) Group Name: I/O Devices Category Name: Storage TimeOfLastMount ~ ~ TotalMountTime ~ ~ UnitsDescription ~ ~ MaxUnitsBeforeCleaning ~ ~ UnitsUsed ~ ~ FormatsSupported ~ ~ EOTWarningZoneSize ~ ~ MaxPartitionCount ~ ~ Padding ~ ~ MaxRewindTime ~ ~ NodeID SnapshotID 24 Chapter 1
Data Structures File System Categories & Data Tables File System Categories & Data Tables The File System group contains the following categories and structure in the data tables: • File System: FileSystem • File System: LVMLogicalVolume • File System: LVMPhysicalVolume • File System: LVMPhysicalVolumeGroup • File System: LVMVolumeGroup Table 1-10 File System: FileSystem table Group Name: File System Category Name: FileSystem Multiple rows Table Attributes Filter Parameters Snapshot Present
Data Structures File System Categories & Data Tables Table 1-10 File System: FileSystem table (Continued) Group Name: File System Category Name: FileSystem CodeSet ~ ~ MaxFileNameLength ~ ~ ClusterSize ~ ~ FileSystemType HP-UX HP-UX Bootable HP-UX HP-UX TotalINodes HP-UX HP-UX FreeINodes HP-UX HP-UX ReservedCapacity HP-UX HP-UX LargeFileFeature ~ ~ Minfree ~ ~ FragmentSize ~ ~ BytesPerInode ~ ~ SectorsPerTrack ~ ~ TracksPerCylinder ~ ~ DiskCylindersPerCylinderG
Data Structures File System Categories & Data Tables Table 1-11 File System: LVMLogicalVolume table (Continued) Group Name: File System InstallDate Category Name: LVMLogicalVolume ~ Name ~ HP-UX HP-UX Status HP-UX HP-UX SystemCreationClassName ~ ~ SystemName ~ ~ CreationClassName ~ ~ DeviceID ~ ~ PowerManagementSupported ~ ~ PowerManagementCapabilities ~ ~ Availability ~ ~ StatusInfo ~ ~ LastErrorCode ~ ~ ErrorDescription ~ ~ ErrorCleared ~ ~ OtherIdentifyingInfo
Data Structures File System Categories & Data Tables Table 1-11 File System: LVMLogicalVolume table (Continued) Group Name: File System Category Name: LVMLogicalVolume AccessPermission HP-UX HP-UX MirrorCopyNumber ~ ~ ConsistencyRecovery ~ ~ SchedulePolicy ~ ~ LogicalExtentSize HP-UX HP-UX Capacity HP-UX HP-UX NumberOfStripes HP-UX HP-UX StripeSize HP-UX HP-UX BadBlockRelocation HP-UX HP-UX AllocationPolicy HP-UX HP-UX StaledLogicalExtents HP-UX HP-UX NumberReadAccesses
Data Structures File System Categories & Data Tables Table 1-12 File System: LVMPhysicalVolume table (Continued) Group Name: File System Category Name: LVMPhysicalVolume CreationClassName ~ ~ DeviceID ~ ~ PowerManagementSupported ~ ~ PowerManagementCapabilities ~ ~ Availability ~ ~ StatusInfo ~ ~ LastErrorCode ~ ~ ErrorDescription ~ ~ ErrorCleared ~ ~ OtherIdentifyingInfo ~ ~ PowerOnHours ~ ~ TotalPowerOnHours ~ ~ IdentifyingDescriptions ~ ~ AdditionalAvailability
Data Structures File System Categories & Data Tables Table 1-12 File System: LVMPhysicalVolume table (Continued) Group Name: File System Category Name: LVMPhysicalVolume Extendable ~ ~ PrimaryPartition ~ ~ PartitionType ~ ~ PartitionSubtype ~ ~ AlternatePVName HP-UX HP-UX PhysicalExtentSize HP-UX HP-UX Capacity HP-UX HP-UX Free HP-UX HP-UX Allocated HP-UX HP-UX NumberStaledPEs HP-UX HP-UX NodeID SnapshotID Table 1-13 File System: LVMPhysicalVolumeGroup table Category Nam
Data Structures File System Categories & Data Tables Table 1-14 File System: LVMVolumeGroup table Group Name: File System Category Name: LVMVolumeGroup Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters LVMVolumeGroupID Caption ~ ~ Description ~ ~ Name HP-UX HP-UX Status HP-UX HP-UX HP-UX HP-UX CollectionID AccessPermission PhysicalExtentSize HP-UX Capacity HP-UX HP-UX HP-UX Allocated HP-UX HP-UX FreeSpace HP-UX HP-UX MaxNumberOfPVs
Data Structures Network Categories & Data Tables Network Categories & Data Tables The Network group contains the following categories and structure in the data tables: • Network: DNSAdminDomain • Network: IPRoute • Network: NetworkAdapter • Network: NISAdminDomain • Network: NTPAdminDomain Table 1-15 Network: DNSAdminDomain table Gropu Name: Network Category Name: DNSAdminDomain Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters DNSAdminDomainID Cap
Data Structures Network Categories & Data Tables Table 1-16 Network: IPRoute table Group Name: Network Category Name: IPRoute Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters IPRouteID Caption ~ ~ Description ~ ~ InstallDate ~ ~ Name ~ ~ Status ~ ~ SystemCreationClassName ~ ~ SystemName ~ ~ ServiceCreationClassName ~ ~ ServiceName ~ ~ CreationClassName ~ ~ IPDestinationAddress HP-UX HP-UX IPDestinationMask HP-UX HP-UX Nex
Data Structures Network Categories & Data Tables Table 1-17 Network: NetworkAdapter table Group Name: Network Category Name: NetworkAdapter Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters NetworkAdapterID Caption ~ ~ Description ~ ~ InstallDate ~ ~ Name HP-UX HP-UX Status ~ ~ SystemCreationClassName ~ ~ SystemName ~ ~ CreationClassName ~ ~ DeviceID HP-UX HP-UX PowerManagementSupported ~ ~ PowerManagementCapabilities ~ ~ Ava
Data Structures Network Categories & Data Tables Table 1-17 Network: NetworkAdapter table (Continued) Group Name: Network Category Name: NetworkAdapter FullDuplex ~ ~ AutoSense ~ ~ OctetsTransmitted ~ ~ OctetsReceived ~ ~ SubnetMask HP-UX StationAddress HP-UX DHCPEnabled HP-UX HP-UX BroadcastAddress HP-UX HP-UX Hostname HP-UX HP-UX NodeID SnapshotID Table 1-18 Network: NISAdminDomain table Group Name: Network Category Name: NISAdminDomain Single Row Table Attributes Filte
Data Structures Network Categories & Data Tables Table 1-18 Network: NISAdminDomain table (Continued) Group Name: Network Category Name: NISAdminDomain IsSlaveServer HP-UX HP-UX ServerWaitFlag HP-UX HP-UX NodeID SnapshotID Table 1-19 Network: NTPAdminDomain table Group Name: Network Category Name: NTPAdminDomain Single Row Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters NTPAdminDomainID Caption ~ ~ Description ~ ~ InstallDate ~ ~ Status ~ ~ Creati
Data Structures Software Categories & Data Tables Software Categories & Data Tables The Software group contains the following categories and structure in the data tables: • Software: BundleContents • Software: Bundle • Software: Product • Software: Fileset Table 1-20 Software: BundleContents table Group Name: Software Category Name: BundleContents Multiple Row Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters Bundle HP-UX HP-UX Content HP-UX HP-UX BundleCont
Data Structures Software Categories & Data Tables Table 1-21 Software: Bundle table (Continued) Group Name: Software Category Name: Bundle WarrantyStartDate ~ ~ WarrantyDuration ~ ~ Architecture HP-UX HP-UX Location HP-UX HP-UX QualifierID HP-UX HP-UX CreateTime HP-UX HP-UX ModificationTime HP-UX HP-UX Size HP-UX HP-UX Copyright HP-UX HP-UX Directory HP-UX HP-UX InstanceIdentifier HP-UX HP-UX IsLocatable HP-UX HP-UX LayoutVersion HP-UX HP-UX MachineType HP-UX HP
Data Structures Software Categories & Data Tables Table 1-22 Software: Product table Group Name: Software Category Name: Product Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters HP-UX HP-UX ProductID Caption Description HP-UX HP-UX IdentifyingNumber HP-UX Name SKUNumber HP-UX HP-UX HP-UX HP-UX Vendor HP-UX HP-UX Version HP-UX HP-UX WarrantyStartDate ~ ~ WarrantyDuration ~ ~ Architecture HP-UX HP-UX Location HP-UX HP-UX QualifierI
Data Structures Software Categories & Data Tables Table 1-22 Software: Product table (Continued) Group Name: Software Category Name: Product OperatingSystemVersion HP-UX HP-UX IsPatch HP-UX HP-UX InstallSource HP-UX HP-UX DataModelRevision HP-UX HP-UX InstallDate HP-UX NodeID SnapshotID Table 1-23 Software: Fileset table Group Name: Software Category Name: Fileset Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters FilesetID Caption Descript
Data Structures Software Categories & Data Tables Table 1-23 Software: Fileset table (Continued) Group Name: Software Category Name: Fileset CreateTime ~ ~ ModificationTime HP-UX HP-UX Size HP-UX HP-UX ControlDirectory HP-UX HP-UX IsKernel HP-UX HP-UX IsLocatable HP-UX HP-UX IsReboot HP-UX HP-UX Location HP-UX HP-UX MediaSequenceList HP-UX HP-UX DataModelRevision HP-UX HP-UX InstanceIdentifier HP-UX HP-UX Architecture HP-UX HP-UX MachineType HP-UX HP-UX OperatingS
Data Structures Process Categories & Data Tables Process Categories & Data Tables The Process group contains the following categories and structure in the data tables: • Process: Process • Process: OperatingSystem Table 1-24 Process: Process table Group Name: Process Category Name: Process Multiple Rows Table Attributes Filter Parameters Snapshot Presentation Snapshot Parameters HP-UX HP-UX ProcessID Handle Caption ~ ~ Description ~ ~ InstallDate ~ ~ Name HP-UX HP-UX Status ~ ~
Data Structures Process Categories & Data Tables Table 1-24 Process: Process table (Continued) Group Name: Process Category Name: Process ProcessSessionID ~ ~ ProcessTTY HP-UX HP-UX ModulePath HP-UX HP-UX Parameters HP-UX HP-UX ProcessNiceValue HP-UX HP-UX ProcessCPUTime ~ ~ ProcessRealText ~ ~ ProcessRealData HP-UX HP-UX ProcessRealStack HP-UX HP-UX ProcessVirtualText HP-UX HP-UX ProcessVirtualData HP-UX HP-UX ProcessVirtualStack HP-UX HP-UX ProcessVirtualMemoryMapp
Data Structures Process Categories & Data Tables 44 Chapter 1
