Jump to content English
hp.com home
HP Systems Insight Manager  |  Reporting  |  Report Views

Reporting
Report Views

» HP Systems Insight Manager

»Table of Contents
»Index
»Product Overview
»Getting Started
»Monitoring Systems, Events, and Clusters
»Using Tasks
»Using Default Tools
»Reporting
»Running a Report
»Adding a Report
»Editing a Report
»Copying Report
»Exporting in CSV format
»Showing SQL
Report Views
»Running a Snapshot Comparison
»About License Report
»Administering the Software
»Troubleshooting
»Printable Version
»Glossary
»Using Help
Content starts here
» Introduction
» Database Views
» Related Topics

Introduction

Reporting uses the following database views to generate reports. Each item in the database views corresponds to an attribute in one of the Common Information Model (CIM) tables within the HP Systems Insight Manager database.

Database Views

There are several database views that are included with HP Systems Insight Manager. These views can be used to generate reports in HP Systems Insight Manager. The following views are available:

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Model

Controller model

Version

Controller Product Revision number

SerialNumber

Controller Serial number

FirmwareRevision

Board firmware revision

SlotNumber

Slot number in the system

BoardName

Board name

SnapshotID

Snapshot ID

Tag

Tag

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

SerialNumber

Serial number

OtherIdentifyingInfo

Asset tag number

SnapshotID

Snapshot ID

Tag

Tag

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

CPUType

Type of CPU

CPUSpeed

CPU speed

SlotNumber

Slot number in the system

FirmwareID

Processor firmware ID

ProcessorLoad

Processor load

ProcessorAllocated

Processor status: 1=Allocated; 0=Not allocated

SnapshotID

Snapshot ID

Location

Location for 64-bit Intel Platform systems. This field is blank for all other systems.

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

SlotNumber

Slot number in the system

MemorySize

Memory size in kilobytes

MemoryTech

Technology type of memory module installed

PartNumber

Memory modules manufacturer part number

SnapshotID

Snapshot ID

MemoryType

Memory type

FromFactor

Type of memory module installed

SerialNumber

Memory modules serial number

Location

Location for 64-bit Intel Platform systems. This field is blank for all other systems.

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Slot

Slot number in the system

BoardName

Board name (for example, PCI SCSI controller, and so on)

BoardRevision

Board revision

BoardModel

Board model

BoardFirmware

Board firmware

BoardSerial

Board serial number

SnapshotID

Snapshot ID

Location

Location for 64-bit Intel Platform systems. This field is blank for all other systems.

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

IPAddress

IP address

IPAddressNumber

IP address in decimal value (for sorting purposes)

DeviceStatus

Hardware status of the device

ProductType

Type of device (for example, server, client, workstation, and so on)

ProducName

Product name (for example, ProLiant 1600, and Compaq Tru64 UNIX System)

SerialNumber

Serial number

AssetTag

Asset tag

MemorySize

Memory size

ROMVersion

ROM version

OSType

Operating system type

OSVendor

Operating system vendor

ServerRoleServer role for ProLiant servers

Location

Location of the device

DeviceOwner

Owner of the device

DeviceBootTime

Time when the operating system was last booted

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Description

Which logical drive (for example, c: [FAT])

SizeMb

Size of the logical drive in megabytes

UsedMb

Size of used space in megabytes

UsedPercent

Percentage of the used space

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Description

Description

MacAddress

MAC address

IPAddress

IP address

IPAddressNumber

IP address in decimal value

InputErrors

Input errors

OutputErrors

Output errors

Speed

Interface speed (bits/sec)

Duplex

Adapter Duplex state

FullDuplex

Flag indicating that the adapter is operating in full duplex mode

InterfaceName

Interface name

SubnetMask

Subnet mask

BroadcastAddress

Broadcast address

InterfaceState

Status information to indicate whether the logical device is enabled (3), disabled (4), some other (1), or unknown (2) state

DHCPEnabled

Indicates whether DHCP is enabled

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Description

Description of the operating system type

Version

Version number of the operating system

SubDesc

Additional description (for example, Service Pack, Rev information)

OSType

Operating System type (for example, Windows 2000)

OSVendor

Operating system vendor

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Slot

Slot number in the system

DeviceType

Device type (for example, CSCI disk)

DriveModel

Drive model

DriveFirmware

Drive firmware

DriveSize

Drive size

TransferMode

Mode of transfer for ATA drives

DriveSerial

Drive serial number

DriveVendor

Drive vendor (for example, HP)

DriveServiceTime

The total number of hours that a physical drive has been operating under the device driver

DriveChassis

Populated only for Fibre Channel attached drives and is the name of the chassis that contains the physical disk drive

DrivePort

The port

DriveLoc

The drive number attached to the port

HardReadErrors

The number of read errors that have occurred on a drive that could not be recovered by the Error Correction Code (ECC) algorithm of the physical drive or through retries

HardWriteErrors

The number of write errors that could not be recovered by a physical drive

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

ModelName

Model name

SerialNumber

Serial number

FirmwareRev

Firmware revision

Status

Status of the fault tolerant power supply system

Condition

Condition of this power supply

ConditionVal

Condition value

MaxCapacity

Maximum capacity in watts

UsedCapacity

Used capacity in watts

RedundancyState

Redundancy state of the power supply

SnapshotID

Snapshot ID

DeviceID

Device ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

RackName

Name of the rack

SnapshotID

Snapshot ID

EnClosureName

Name of the enclosure

Name

Name

SerialNumber

Serial number

Model

Model name

Type

Tag

Slot_number

Slot number

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Description

Software description (for example, Server Agent Service, or Storage Agent Service)

Version

Version number

Date

Date the software item

Executable

Name of the executable

Type

Type of software (for example, agent, application, or driver)

TypeValue

Type value

Status

Software status

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of device associated with device key

CurCount

Actual number of licenses in use for this particular license key for all devices in HP Systems Insight Manager

NumberLicPurchased

The number of licenses purchased for this key

KeyVer

The version of the key in use

ProductName

The name of the product

ProductVer

The version of the product. Can be blank

LicKey

The key the customer has entered

LicType

The type of license on the device

LicDate

The date the license was applied

ExpirationDate

The date the product expires

CollectDate

The date the collection last took place by HP Systems Insight Manager

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

ID

ID

Name

Name of the process

State

Process state

Priority

Process priority

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

OSName

Name of the operating system

OSVersion

Operating system version

Capability

Operating system capability

SystemUptime

System boot up time

NumUsers

Number of users

NumProcesses

Number of processes

MaxProcesses

Max processes

TimeZone

System Date Time

Snapshot ID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

SwapSpaceName

Swap space name

SwapType

Swap type

SwapSpaceSize

Swap space size

SwapSpaceMinSize

Swap space minimum size

SwapSpaceMaxSize

Swap space maximum size

SwapSpaceReservedSize

Swap space reserved size

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

DeviceType

Device type

DeviceDescription

Device description

DeviceIdentifier

Device identifier

DeviceStatus

Device status

DeviceErrors

Device errors

HardwarePath

Hardware path

HardwareType

Hardware type

DeviceClass

Device class

AssociatedDriver

Device driver

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

RouteDestination

Route destination

RouteMask

Route mask

RouteGateway

Route gateway

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

MountPointName

Mount point name

MountSpecialDeviceName

Mount special device name

RemoteMountPointName

Remote mount point name

FileSystemType

File system type

FileSystemAccess

File system access

FileSystemBootable

File system bootable

TotalInodes

Total Inodes

FreeInodes

Free Inodes

DataCapacity

Data capacity

FreeCapacity

Free capacity

MiniFreeSpace

Minimum free space

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

VolumeGroupName

Volume group name

AccessPermission

Access permission

Status

Status

ExtentSize

Physical extent size

Capacity

Volume group capacity

Allocation

Volume group allocated

FreeSpace

Free space

MaxNumPhysicalVol

Max number of physical volume

MaxNumPhysicalExtent

Max number of physical extent

NumDefinedPhysicalVol

Number of defined physical volume

NumActivePhysicalVol

Number of active physical volumes

MaxNumLogicalVol

Max number of logical volumes

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

LogicalVolName

Logical volume name

AccessPermission

Access permission

Status

Logical volume status

ExtentSize

Logical extent size

Capacity

Logical volume capacity

SchedulePolicy

Schedule policy

AllocationPolicy

Allocation policy

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

PhysicalVolName

Physical volume name

Status

Physical volume status

ExtentSize

Physical extent size

Capacity

Physical volume capacity

AllocatedPhysicalExtent

Allocated physical extent

FreePhysicalExtent

Free physical extent

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

DomainName

Domain name

Search

Search list

ServerIPAddress

Server IP address

ServerType

Server type: Unknown (0), Other (1), None (2), Master Server (3), Slave Server (4)

ServerWaitFlag

Server wait flag

ServerAddress

Server address

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

ParameterName

Parameter name

ParameterValue

Parameter value

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

BundleName

Bundle name

VendorTag

Vendor tag

Architecture

Architecture

Revision

Revision

Caption

Caption

ModificationTime

Modification time

Size

Size

LayoutVersion

Layout version

OSName

Operating system name

OSRelease

Operating release

IsPatch

IS patch

InstallSource

Install source

InstallDate

Install date

SnapshotID

Snapshot ID

 Column Name 

Description

DeviceKey

Device key

DeviceName

Name of the device

Specification

Product software specification

ProductName

Product name

Architecture

Architecture

Revision

Revision

VendorTag

Vendor tag

Caption

Product caption

ModificationTime

Modification time

Size

Size

OSName

Operating system name

OSRelease

Operating system release

IsPatch

IS patch

InstallSource

Install source

InstallDate

Install date

SnapshotID

Snapshot ID

Related Topics

» HP Systems Insight Manager - Reporting
» Reporting - Running a Snapshot Comparison