Column Name | Data Type | Description |
allocated_capacity_gb | NUMBER | Allocated configured capacity in Gigabytes |
array_group_id | NUMBER | Foreign key to the array RAID group details |
array_name | STRING | Array name |
chassis_nbr | NUMBER | Chassis number |
free_capacity_gb | NUMBER | Free configured capacity in Gigabytes |
group_name | STRING | Name of the server group |
group_nbr | NUMBER | Group number |
is_external | STRING | Whether the array group is external or not |
last_updated | DATE | Last updated date |
object_id | STRING | Unique internal identifier for the array group |
overhead_gb | NUMBER | Overhead in Gigabytes |
raid_type | STRING | RAID type used by the volume. Possible values include disk -non raided or RAID1, RAID2, RAID3, RAID4, RAID5 |
storage_array_id | NUMBER | Foreign key to the storage array details |
total_capacity_gb | NUMBER | Total configured capacity in Gigabytes |
usable_capacity_gb | NUMBER | Usable capacity after RAID overhead |
Column Name | Data Type | Description |
allocated_capacity_kb | NUMBER | Allocated capacity in KiB |
array_group_id | NUMBER | Foreign key to aps_v_array_group |
array_name | STRING | Array name |
free_capacity_kb | NUMBER | Free/available capacity in KiB |
log_date | DATE | Date when log record was inserted |
storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
total_capacity_kb | NUMBER | Total capacity in KiB |
Column Name | Data Type | Description |
array_group_id | NUMBER | Foreign key to the array group details |
array_group_nbr | NUMBER | Array Group number |
last_updated | DATE | Date/time this pdev was last created/updated |
pdev_id | NUMBER | Pdev ID |
Column Name | Data Type | Description |
nickname | STRING | Nickname |
object_id | STRING | A unique identifier for the array port |
port_id | NUMBER | Foreign key to storage array port details |
port_name | STRING | Port name |
port_nbr | NUMBER | Port number |
port_role | STRING | Port role: possible values are Initiator, RCU, Target |
port_wwn_id | NUMBER | Foreign key to port world wide name details |
storage_array_id | NUMBER | Foreign key to storage array details |
type | STRING | Type |
wwn | STRING | World Wide Name |
Column Name | Data Type | Description |
avg_kbytes_transferred | NUMBER | Average of Kilobytes transferred |
avg_total_io | NUMBER | Average of total IO |
cum_interval_sec | NUMBER | Cumulative interval in seconds |
kbytes_transferred | NUMBER | Kilobytes transferred |
log_date | DATE | Log date |
max_kbytes_transferred | NUMBER | Max Kilobytes transferred |
max_total_io | NUMBER | Maximum of total IO |
port_id | NUMBER | Foreign key from aps_v_array_port |
stddev_kbytes_transferred | NUMBER | Standard deviation of Kilobytes transferred |
stddev_total_io | NUMBER | Standard deviation of Total IO |
total_io | NUMBER | Total IO |
Column Name | Data Type | Description |
diff_kbytes_transferred | NUMBER | Delta data transferred in KiB |
diff_total_io | NUMBER | Delta of total IO |
interval_sec | NUMBER | Interval in seconds |
kbytes_transferred | NUMBER | Data transferred in KiB |
log_date | DATE | Log date |
port_id | NUMBER | Foreign key from aps_v_array_port |
prev_log_date | DATE | Previous log date |
total_io | NUMBER | Total IO |
Column Name | Data Type | Description |
file_system_name | STRING | Filesystem name |
filesystem_capacity_gb | NUMBER | Filesystem capacity in GB |
filesystem_capacity_kb | NUMBER | Filesystem capacity in KiB |
filesystem_id | NUMBER | Foreign key to file system details |
filesystem_used_gb | NUMBER | Filesystem used capacity in GB |
filesystem_used_kb | NUMBER | File system used capacity in KiB |
host_id | NUMBER | Foreign key to host details |
is_at_risk | NUMBER | Indicates if it is an at-risk volume |
mount_point | STRING | File system mount point |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to host details |
host_name | STRING | Host name |
log_date | DATE | Log date |
logical_unit_id | NUMBER | Foreign key to aps_logical_unit |
logical_unit_name | STRING | Name of the logical unit |
policy_id | NUMBER | Foreign key to policy details |
policy_name | STRING | Name of the backup policy |
policy_priority | NUMBER | Priority of the backup policy |
storage_array_id | NUMBER | Foreign key to aps_storage_array |
storage_array_name | STRING | Name of the storage array |
total_gb | NUMBER | Total capacity in Gigabytes |
unit_cost | NUMBER | Unit cost |
Column Name | Data Type | Description |
domain_id | NUMBER | Foreign key from apt_v_domain |
domain_name | STRING | Domain name for the chargeback policy |
group_id | NUMBER | Group ID for the policy |
group_name | STRING | Group name of the policy from apt_v_group |
item_type | STRING | Chargeback policy item type |
item_type_name | STRING | Description of chargeback policy item type |
item_value | STRING | Chargeback policy item type |
policy_id | NUMBER | Unique ID of chargeback policy |
policy_name | STRING | Name of the policy |
policy_priority | NUMBER | Priority of chargeback policy |
policy_type | STRING | Type of chargeback policy |
policy_type_name | STRI”NG | Type of chargeback policy, has value Array or Unknown |
unit_cost | NUMBER | Unit cost of the chargeback policy |
Column Name | Data Type | Description |
datafile_id | NUMBER | Foreign key to database data file details |
db_instance_id | NUMBER | Foreign key to database instance details |
db_instance_name | STRING | Database instance name |
file_system_name | STRING | File system name |
filesystem_id | NUMBER | Foreign key to filesystem details |
free_size_gb | NUMBER | Free size in GiB |
free_size_kb | NUMBER | Free size in KiB |
increment_by_gb | NUMBER | Increment by GiB |
increment_by_kb | NUMBER | Increment by KiB |
increment_by_percent | NUMBER | Increment by percent |
is_auto_extensible | CHAR | Y=Yes, N=No |
last_updated | DATE | Last updated date |
logical_name | STRING | Logical name |
max_size_gb | NUMBER | Max size in GiB |
max_size_kb | NUMBER | Max size in KiB |
physical_name | STRING | Physical name |
status | STRING | Status |
tablespace_id | NUMBER | Foreign key to tablespace details |
tablespace_name | STRING | Tablespace name |
total_size_gb | NUMBER | Total size in GiB |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
datafile_id | NUMBER | Foreign key to database data file details |
db_instance_id | NUMBER | Foreign key to database instance details |
db_instance_name | STRING | Database instance name |
free_size_gb | NUMBER | Free size in GiB |
free_size_kb | NUMBER | Free size in KiB |
log_date | DATE | Last logged date |
logical_name | STRING | Logical name |
physical_name | STRING | Physical name |
tablespace_id | NUMBER | Foreign key to tablespace details |
tablespace_name | STRING | Tablespace name |
total_size_gb | NUMBER | Total size in GiB |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
database_name | STRING | Database name |
database_vendor | CHAR | Database vendor; Q = SQL Server, O = Oracle database |
db_instance_id | NUMBER | Foreign key to database instance details |
db_instance_name | STRING | Database instance name |
free_size_gb | NUMBER | Free size in GiB |
free_size_kb | NUMBER | Free size in KiB |
host_id | NUMBER | Foreign key to host detail |
host_name | STRING | Host name |
is_active | CHAR | Y=Yes, N=No |
last_updated | DATE | Last updated date |
status | STRING | Status |
total_size_gb | NUMBER | Total size in GiB |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
db_instance_id | NUMBER | Foreign key to database instance details |
db_instance_name | STRING | Database instance name |
free_size_gb | NUMBER | Free size in GiB |
free_size_kb | NUMBER | Free size in KiB |
log_date | DATE | Last logged date |
total_size_gb | NUMBER | Total size in GiB |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
db_instance_id | NUMBER | Foreign key to database instance details |
db_instance_name | STRING | Database instance name |
free_size_gb | NUMBER | Free size in GiB |
free_size_kb | NUMBER | Free size in KiB |
last_updated | DATE | Last updated date |
tablespace_id | NUMBER | Foreign key to tablespace details |
tablespace_name | STRING | Tablespace name |
total_size_gb | NUMBER | Total size in GiB |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
db_instance_id | NUMBER | Foreign key to database instance details |
db_instance_name | STRING | Database instance name |
free_size_gb | NUMBER | Free size in GiB |
free_size_kb | NUMBER | Free size in KiB |
log_date | DATE | Last logged date |
tablespace_id | NUMBER | Foreign key to tablespace details |
tablespace_name | STRING | Tablespace name |
total_size_gb | NUMBER | Total size in GiB |
total_size_kb | NUMBER | Total size in KiB |
Column Name | Data Type | Description |
aptare_community_enrolled | STRING | Enrolled in the array performance statistics sharing |
domain_id | NUMBER | Foreign key to domain details |
domain_name | STRING | Domain name |
last_updated | DATE | Date of the last update |
root_group_id | NUMBER | ID of the server group which is the root group for this domain |
Column Name | Data Type | Description |
capacity_kb | NUMBER | Total capacity of the file system in KiB |
filesystem_id | NUMBER | Primary key to the file system |
last_updated | DATE | date and time last updated |
available_kb | NUMBER | Available capacity on the file system in KiB |
host_id | NUMBER | Foreign key to apt_host |
host_name | STRING | Host name |
host_disk_id | NUMBER | Foreign key to apt_host_disk |
host_type | STRING | Host type with the following possible values: VM Server, VIO Server, VM Guest, VIO Guest, Others |
file_system_name | STRING | File system name |
file_system_type | STRING | File system type |
mount_point | STRING | File system mount point |
used_kb | NUMBER | Used capacity in KiB |
quota_kb | NUMBER | Quota in kilobytes |
reservation_kb | NUMBER | Reserved in KiB |
storage_pool_id | NUMBER | Foreign key to apt_storage_pool |
parent_filesystem_id | NUMBER | Parent file system ID |
Column Name | Data Type | Description |
capacity_kb | NUMBER | capacity of the file system in KiB |
filesystem_id | NUMBER | Foreign key to the aps_file_system table |
host_id | NUMBER | Foreign key to apt_host |
log_date | DATE | date and time when the log record was created |
used_kb | NUMBER | used capacity on the file system in KiB |
Column Name | Data Type | Description |
array_port_id | NUMBER | Foreign key to the array port details |
disk_id | STRING | Foreign key to disk details |
disk_id_suffix | STRING | Disk ID suffix |
disk_is_ok | STRING | Y or N |
disk_product_id | STRING | Foreign key to the disk product details |
disk_size_gb | NUMBER | Disk size in GiB |
disk_size_kb | NUMBER | Disk size in KiB |
disk_vendor | STRING | Disk vendor name |
display_name | STRING | Display name of the host |
file_system_name | STRING | File system name |
file_system_type | STRING | The host file system type, such as FAT (file allocation table) or FAT32 |
filesystem_capacity_gb | NUMBER | File system capacity in GiB |
filesystem_capacity_kb | NUMBER | File system capacity in KiB |
filesystem_id | NUMBER | Foreign key to the file system details |
filesystem_used_gb | NUMBER | File system used capacity by stored data in GiB |
filesystem_used_kb | NUMBER | File system used capacity by stored data in KiB |
hba_device_name | STRING | Host bus adaptor device name |
hba_node_wwn | STRING | Host bus adaptor node world wide name |
hba_port_id | NUMBER | Foreign key to the HBA port details |
hba_port_wwn | STRING | Host bus adaptor port world wide name |
host_disk_id | NUMBER | Foreign key to host disk details |
host_id | NUMBER | Foreign key to host details |
host_name | STRING | Host name |
is_san_disk | STRING | Y or N |
mount_point | STRING | File system mount point |
parent_filesystem_id | NUMBER | Foreign key to parent file system details |
partition_name | STRING | Partition name |
partition_size_gb | NUMBER | Partition size in GiB |
partition_size_kb | NUMBER | Partition size in KiB |
port_is_active | STRING | Y or N |
primary_ip_address | STRING | Primary IP address of host |
raw_disk_path | STRING | Raw disk path |
scsi_bus_nbr | NUMBER | SCSI bus number |
scsi_os_lun_nbr | NUMBER | logical unit number as seen from the host side |
scsi_target_nbr | STRING | SCSI target number |
storage_type | STRING | Storage type: D=DAS, N=NAS, S=SAN |
volume_group_id | NUMBER | Foreign key to the volume group details |
volume_group_name | STRING | Logical volume group name |
volume_partition_id | NUMBER | Foreign key to the volume partition |
zfs_available_gb | NUMBER | ZFS available capacity in gigabytes |
Column Name | Data Type | Description |
capacity_90day_avg | NUMBER | average capacity of the file system in the last 90 days |
capacity_90day_max | NUMBER | maximum capacity of the file system in the last 90 days |
capacity_90day_min | NUMBER | minimum capacity of the file system in the last 90 days |
filesystem_id | NUMBER | Foreign key to the file system details |
used_90day_avg | NUMBER | average used capacity of the file system in the last 90 days |
used_90day_max | NUMBER | maximum used capacity of the file system in the last 90 days |
used_90day_min | NUMBER | minimum used capacity of the file system in the last 90 days |
Column Name | Data Type | Description |
connection_options | STRING | Connection options |
data_rate | STRING | Data rate |
device_name | STRING | HBA device name |
driver | STRING | Driver |
driver_version | STRING | Driver Version |
enable_extended_logging | STRING | Y=Yes, N=No |
enable_fc_tape_support | STRING | Y=Yes, N=No |
enable_fc_tape_support | STRING | Y=Yes, N=No |
enable_fcp_error_reovery | STRING | Y=Yes, N=No |
enable_hard_loop_id | STRING | Y=Yes, N=No |
enable_host_hba_bios | STRING | Y=Yes, N=No |
enable_lip_full_login | STRING | Y=Yes, N=No |
enable_target_reset | STRING | Y=Yes, N=No |
execution_throttle | NUMBER | Execution throttle |
firmware_version | STRING | Firmware Version |
frame_size | NUMBER | Frame size |
hard_loop_id | STRING | Hard loop ID |
hba_model | STRING | HBA Model |
host_id | NUMBER | Foreign key to host details |
host_name | STRING | The host name of the client/server |
interrupt_delay_timer_ms | NUMBER | Interrupt delay timer in 100 ms |
last_updated | DATE | Last Updated |
link_down_timeout_sec | NUMBER | Link down time out in seconds |
login_retry_count | NUMBER | Login retry count |
loop_reset_delay_sec | NUMBER | Loop reset delay in seconds |
manufacturer | STRING | Manufacturer |
max_lun_per_target | NUMBER | Max LUN per target |
node_nickname | STRING | Node nickname |
node_wwn | STRING | host bus adapter node world wide name |
node_wwn_id | NUMBER | Foreign key to WWN |
operation_mode | STRING | Operation mode |
port_down_retry_count | NUMBER | Port down retry count |
vendor | STRING | Vendor |
Column Name | Data Type | Description |
device_name | STRING | HBA device name |
host_id | NUMBER | Foreign key to host details |
is_active | STRING | Y=Yes, N=No |
is_csv_load | STRING | Y=Yes, N=No |
last_updated | DATE | Date and time the HBA port data was last updated in the portal database. |
node_wwn_id | NUMBER | Foreign key to the WWN |
port_wwn_id | NUMBER | Foreign key to port world wide name details |
Column Name | Data Type | Description |
host_id | NUMBER | Unique server ID. Primary key in this view |
host_name | STRING | The host name of the client/server. This is the name by which the client/server is known to the underlying backup software. |
host_type | STRING | Host type with the following possible values: VM Server, VIO Server, VM Guest, VIO Guest, Others |
display_name | STRING | The name that is displayed on the Web Interface for this client/server |
primary_ip_address | STRING | IP Address of the backup interface for this client/server |
last_updated | DATE | Date/time this record was last created/updated |
exists_within_host | NUMBER | Exists within host |
Column Name | Data Type | Description |
host_id | NUMBER | Internally generated sequence number that identifies the host. |
filesystem_id | NUMBER | Internal database file identifier. |
filesystem_name | STRING | File system name. |
mount_point | STRING | The mount point of the file system. |
array_port_id | NUMBER | Identifies the array port. |
file_system_type | STRING | File system type. |
capacity_kb | NUMBER | Total capacity of the file system. |
used_kb | NUMBER | Total used capacity of the file system. |
Column Name | Data Type | Description |
disk_id | STRING | Disk ID |
disk_id_suffix | STRING | Disk ID Suffix |
host_disk_id | NUMBER | Sequence generated primary key |
host_id | NUMBER | Foreign key to apt_v_server |
host_type | STRING | Host type with the following possible values: VM Server, VIO Server, VM Guest, VIO Guest, Others |
is_ok | STRING | Yes or No (Y/N) indicating if the disk is ok or not |
last_updated | DATE | Date and time last updated |
product_id | STRING | Product ID |
raw_disk_path | STRING | Raw disk path |
scsi_bus_nbr | NUMBER | SCSI bus number |
scsi_os_lun_nbr | NUMBER | SCSI OS LUN number |
scsi_target_nbr | STRING | SCSI target number |
size_kb | NUMBER | Size in KiB |
vendor | STRING | Vendor |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to host details. |
last_updated | DATE | Last updated date. |
percent_used | NUMBER | Percent of the storage used. |
storage_path_id | NUMBER | Foreign key to storage path details. |
Column Name | Data Type | Description |
array_name | STRING | Array name |
host_disk_id | NUMBER | Foreign key to the host disk details |
host_id | NUMBER | Foreign key to host details Note: This field will be populated when host resources information is collected or if the array provides host information. Otherwise, this field is empty. |
host_name | STRING | Host name |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name (or device number for un-named LUNs |
lun_capacity_gb | NUMBER | LUN capacity in GiB |
storage_array_id | NUMBER | Foreign key to storage array details |
Column Name | Data Type | Description |
capacity_kb | NUMBER | File system capacity in KiB. |
file_system_name | STRING | File system name. |
file_system_type | STRING | The host file system type. Possible values include: FAT- File Allocation Table FAT32 same as above CIFS- Common internet file system NTFS- NT file system or New Technology File System NFS- Network File System Ext2 Second extended file system Ext3 Third extended file system Hfs - Hierarchical File System Jfs -Journaled File System Jfs2 -enhanced journaled file system Ufs -Unix file system Vxfs -Veritas File System |
filesystem_id | NUMBER | Foreign key to filesystem details. |
host_id | NUMBER | Foreign key to host details. |
mount_point | STRING | Filesystem mount point |
pct_available | NUMBER | Filesystem available capacity percentage. |
storage_type | STRING | Storage type: Possible values: D-DAS N-NAS S-SAN. |
used_kb | NUMBER | Filesystem used capacity in KiB. |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to host details |
host_ports | STRING | Concatenated list of host ports |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time last updated |
payload_id | NUMBER | Payload ID |
software_name | STRING | Host software name |
software_type | STRING | Host software type |
software_version | STRING | Host software version |
vendor | STRING | Host vendor |
Column Name | Data Type | Description |
allocated_capacity_gb | NUMBER | Allocated capacity in GB; This column is not relevant for hosts with ZFS pools, since StorageConsole collects capacity using: df -k (not zpool list). |
asm_pct_used | NUMBER | Percentage used ASM file system capacity |
das_pct_used | NUMBER | Percentage used DAS file system capacity |
das_san_pct_used | NUMBER | Percentage used file system capacity |
host_id | NUMBER | Foreign key to apt_v_server |
host_name | STRING | Host name |
last_poll_date | DATE | Last successful updated date of the host |
nas_pct_used | NUMBER | Percentage used NAS file system capacity |
nbr_of_arrays | NUMBER | Number of unique storage arrays |
nbr_of_asm_volumes | NUMBER | Number of distinct Oracle ASM volumes |
nbr_of_das_san_volumes | NUMBER | Number of distinct file systems |
nbr_of_das_volumes | NUMBER | Number of distinct DAS volumes |
nbr_of_filesystems_at_risk | NUMBER | Number of file systems at risk of running out of storage |
nbr_of_luns | NUMBER | Number of unique logical units |
nbr_of_nas_volumes | NUMBER | Number of distinct NAS volumes |
nbr_of_san_volumes | NUMBER | Number of distinct SAN volumes |
nbr_of_used_luns | NUMBER | Number of used logical units |
primary_ip_address | STRING | Primary IP address of the host on which the file system resides |
related_host_names | STRING | Related_host_names from aps_v_related_hosts |
san_pct_used | NUMBER | Percentage used SAN file system capacity |
seen_by_host_gb | NUMBER | Seen-by-Host capacity in GiB |
total_asm_capacity_gb | NUMBER | Total ASM file system capacity in GiB |
total_asm_used_gb | NUMBER | Total used ASM file system capacity in GiB |
total_das_capacity_gb | NUMBER | Total DAS file system capacity in GiB |
total_das_san_capacity_gb | NUMBER | Total file system capacity in GiB |
total_das_san_used_gb | NUMBER | Used file system capacity in GiB |
total_das_used_gb | NUMBER | Total used DAS file system capacity in GiB |
total_nas_capacity_gb | NUMBER | Total NAS file system capacity in GiB |
total_nas_used_gb | NUMBER | Total used NAS file system capacity in GiB |
total_san_capacity_gb | NUMBER | Total SAN file system capacity in GiB |
total_san_used_gb | NUMBER | Total used SAN file system capacity in GiB |
Column Name | Data Type | Description |
disk_size_gb | NUMBER | Disk size in GiB |
disk_size_kb | NUMBER | Disk size in KiB |
file_system_name | STRING | File system name |
file_system_type | STRING | Host file system type, such as FAT or FAT32 |
filesystem_id | NUMBER | Foreign key to file system details |
host_id | NUMBER | Foreign key to host details |
logical_unit_name | STRING | Logical unit name |
mount_point | STRING | File system mount point |
path_id | NUMBER | Internal identifier |
raid_type | STRING | RAID type of used by the volume, such as non-raided, RAID1, RAID2 |
scsi_os_lun_nbr | NUMBER | Logical unit number as seen on the host side |
volume_group_name | STRING | Volume group name |
Column Name | Data Type | Description |
array_family | STRING | Array family |
array_group_id | NUMBER | Foreign key to array group (RAID group) details |
array_name | STRING | Array name |
estimate_used_kb | NUMBER | Estimated used capacity |
group_name | STRING | Array group name in which this LUN resides |
logical_unit_id | NUMBER | Foreign key to the logical unit details |
logical_unit_name | STRING | Logical unit name |
lun_type | STRING | LUN type |
nbr_allocated_luns | NUMBER | Total number of allocated logical units on the parent of this LUN |
nbr_of_luns | NUMBER | Number of logical units |
object_id | STRING | Unique internal identifier for the logical unit |
parent_logical_unit_id | Meta-LUN logical unit ID to define meta-private LUN relationship. | |
raid_type | STRING | RAID type of used by the volume, such as non-raided, RAID1, RAID2 |
status | STRING | Possible values include: HDS Open Reserved, allocated undiscovered, allocated unused, allocated used, and unallocated. |
storage_array_id | NUMBER | Foreign key to storage array details |
total_capacity_gb | NUMBER | Total capacity in GiB |
total_capacity_kb | NUMBER | Total capacity in KiB |
Column Name | Data Type | Description |
array_name | STRING | Array name |
array_port_id | NUMBER | Foreign key to array port details |
array_port_wwn | STRING | Array port world wide name |
host_disk_id | NUMBER | Foreign key to the host disk details |
host_id | NUMBER | Foreign key to the host details |
host_name | STRING | Host name |
host_port_id | NUMBER | Foreign key to the host port details |
host_port_wwn | STRING | Host port world wide name |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name |
storage_array_id | NUMBER | Foreign key to storage array details |
Column Name | Data Type | Description |
array_port_id | NUMBER | Foreign key to array port details. |
hba_port_id | NUMBER | Foreign key to host port details. |
host_disk_id | NUMBER | Foreign key to host disk details. |
host_id | NUMBER | Foreign key to host details. |
last_updated | DATE | Last updated date. |
scsi_bus_nbr | NUMBER | SCSI bus number. |
scsi_os_lun_nbr | NUMBER | Logical unit number as seen from the host side. |
scsi_target_nbr | NUMBER | SCSI target number. |
Column Name | Data Type | Description |
array_port_wwn | NUMBER | Array port world wide name |
disk_id_suffix | STRING | Disk ID suffix |
disk_is_ok | STRING | Y or N |
disk_product_id | STRING | Foreign key to the disk product details |
disk_size_gb | NUMBER | Disk size in GiB |
disk_size_kb | NUMBER | Disk size in KiB |
disk_vendor | STRING | Disk vendor name |
display_name | STRING | Display name of the host |
file_system_name | STRING | File system name |
file_system_type | STRING | The host file system type, such as FAT (file allocation table) or FAT32 |
filesystem_capacity_gb | NUMBER | File system capacity in GiB |
filesystem_capacity_kb | NUMBER | File system capacity in KiB |
filesystem_id | NUMBER | Foreign key to the file system details |
filesystem_used_gb | NUMBER | File system used capacity by stored data in GiB |
filesystem_used_kb | NUMBER | File system used capacity by stored data in KiB |
hba_device_name | STRING | Host bus adaptor device name |
hba_node_wwn | STRING | Host bus adaptor node world wide name |
hba_port_wwn | STRING | Host bus adaptor port world wide name |
host_disk_id | NUMBER | Foreign key to host disk details |
host_id | NUMBER | Foreign key to host details |
host_name | STRING | Host name |
host_storage_domain | STRING | Host storage domain name |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name |
lun_capacity_gb | NUMBER | logical unit capacity in GiB |
lun_capacity_kb | NUMBER | logical unit capacity in KiB |
lun_nbr | NUMBER | Logical unit number |
mount_point | STRING | File system mount point |
partition_name | STRING | Partition name |
partition_size_gb | NUMBER | Partition size in GiB |
partition_size_kb | NUMBER | Partition size in KiB |
port_is_active | STRING | Y or N |
port_name | STRING | Port name |
primary_ip_address | STRING | Primary IP address of host |
raid_type | STRING | RAID type used by the volume, such as RAID1, RAID2 |
raw_disk_path | STRING | Raw disk path |
scsi_bus_nbr | NUMBER | SCSI bus number |
scsi_os_lun_nbr | NUMBER | Logical unit number as seen from the host side |
scsi_target_nbr | STRING | SCSI target number |
storage_array_id | NUMBER | Foreign key to the storage array details |
storage_type | STRING | D=DAS, S=SAN, N=NAS |
volume_group_id | NUMBER | Foreign key to the volume group details |
volume_group_name | STRING | Logical volume group name |
volume_partition_id | NUMBER | Foreign key to the volume partition |
Column Name | Data Type | Description |
AVG_KBYTES_READ | NUMBER | Average amount of data read. |
AVG_KBYTES_WRITTEN | NUMBER | Average amount of data written. |
AVG_READ_HIT_IO | NUMBER | Average cache read hit I/O rate; data available from cache. |
AVG_READ_IO | NUMBER | Average read I/O operations per second. |
AVG_READ_IO_RESPONSE_TIME | NUMBER | Average read I/O response time. |
AVG_TOTAL_IO | NUMBER | Average total I/O operations per second. |
AVG_TOTAL_IO_RESPONSE_TIME | NUMBER | Average total I/O response time. |
AVG_WRITE_HIT_IO | NUMBER | Average cache write hit I/O rate; data to be updated resides in cache. |
AVG_WRITE_IO | NUMBER | Average write I/O operations per second. |
AVG_WRITE_IO_RESPONSE_TIME | NUMBER | Average write I/O response time. |
CUM_INTERVAL_SEC | NUMBER | Time interval in seconds for which the data was collected for the daily LUN performance log. |
INTERVAL_TYPE | STRING | Interval type of the aggregated performance history collection. |
KBYTES_READ | NUMBER | Amount of data read from the LUN. |
KBYTES_WRITTEN | NUMBER | Amount of data written to the LUN. |
LOG_DATE | DATE | The date and time the entry was written to the log table. |
LOGICAL_UNIT_ID | NUMBER | Internally generated ID that uniquely identifies the logical unit. |
logical_unit_name | STRING | Name of the LUN |
MAX_KBYTES_READ | NUMBER | Maximum amount of data read. |
MAX_KBYTES_WRITTEN | NUMBER | Maximum amount of data written. |
MAX_READ_HIT_IO | NUMBER | Maximum cache read hit I/O rate; data available from cache. |
MAX_READ_IO | NUMBER | Maximum read I/O operations per second. |
MAX_READ_IO_RESPONSE_TIME | NUMBER | Maximum read I/O response time. |
MAX_TOTAL_IO | NUMBER | Maximum total I/O operations per second. |
MAX_TOTAL_IO_RESPONSE_TIME | NUMBER | Maximum total I/O response time. |
MAX_WRITE_HIT_IO | NUMBER | Maximum cache write hit I/O rate; data to be updated resides in cache. |
MAX_WRITE_IO | NUMBER | Maximum write I/O operations per second. |
MAX_WRITE_IO_RESPONSE_TIME | NUMBER | Maximum write I/O response time. |
MIN_READ_HIT_IO | NUMBER | Minimum cache read hit I/O rate; data available from cache. |
MIN_WRITE_HIT_IO | NUMBER | Minimum cache write hit I/O rate; data to be updated resides in cache. |
READ_HIT_IO | NUMBER | Cache read hit I/O rate; data available from cache. |
READ_IO | NUMBER | Read I/O operations per second. |
READ_IO_RESPONSE_TIME | NUMBER | Read I/O response time. |
READ_IO_TIME_COUNTER | NUMBER | Read I/O time counter. |
STDDEV_KBYTES_READ | NUMBER | Standard deviation for the amount of data read. |
STDDEV_KBYTES_WRITTEN | NUMBER | Standard deviation for the amount of data written. |
STDDEV_READ_HIT_IO | NUMBER | Standard deviation for the cache read hit I/O rate; data available from cache. |
STDDEV_READ_IO | NUMBER | Standard deviation for the read I/O operations per second. |
STDDEV_READ_IO_RESPONSE_TIME | NUMBER | Standard deviation for the read I/O response time. |
STDDEV_TOTAL_IO | NUMBER | Standard deviation for the total I/O operations per second. |
STDDEV_TOTAL_IO_RESPONSE_TIME | NUMBER | Standard deviation for the read I/O response time. |
STDDEV_WRITE_HIT_IO | NUMBER | Standard deviation for the cache write hit I/O rate; data to be updated resides in cache. |
STDDEV_WRITE_IO | NUMBER | Standard deviation for the write I/O operations per second. |
STDDEV_WRITE_IO_RESPONSE_TIME | NUMBER | Standard deviation for the write I/O response time. |
STORAGE_ARRAY_ID | NUMBER | Internally generated sequential ID that uniquely identifies the storage array. |
TOTAL_IO | NUMBER | Total I/O operations per second. |
TOTAL_IO_RESPONSE_TIME | NUMBER | Total I/O response time. |
TOTAL_IO_TIME_COUNTER | NUMBER | Total I/O time counter. |
WRITE_HIT_IO | NUMBER | Write hit I/O rate; data to be updated resides in cache. |
WRITE_IO | NUMBER | Write I/O operations per second. |
WRITE_IO_RESPONSE_TIME | NUMBER | Write I/O response time. |
WRITE_IO_TIME_COUNTER | NUMBER | Write I/O time counter. |
Column Name | Data Type | Description |
avg_kbytes_read | NUMBER | Average KiB read |
avg_kbytes_written | NUMBER | Average KiB written |
avg_read_hit_io | NUMBER | Average read hit I/O, hits/sec to/from cache |
avg_read_io | NUMBER | Average read I/O, hits/sec to/from disk |
avg_read_io_response_time | NUMBER | Average read I/O response time |
avg_total_io | NUMBER | Average total I/O, hits/sec to/from disk |
avg_total_io_response_time | NUMBER | Average total I/O response time |
avg_write_hit_io | NUMBER | Average write hit I/O, hits/sec to/from cache |
avg_write_io | NUMBER | Average write I/O, hits/sec to/from disk |
avg_write_io_response_time | NUMBER | Average write I/O response time |
cum_interval_sec | NUMBER | Cumulative interval in seconds |
kbytes_read | NUMBER | Data read in KiB |
kybytes_written | NUMBER | Data written in KiB |
log_date | DATE | Log date |
logical_unit_id | NUMBER | Foreign key from aps_v_logical_unit |
logical_unit_name | STRING | Name of the LUN |
max_kbytes_read | NUMBER | Maximum data read in KiB |
max_kbytes_written | NUMBER | Maximum data written in KiB |
max_read_hit_io | NUMBER | Maximum read hit I/O, hits/sec to/from cache |
max_read_io | NUMBER | Maximum read I/O, hits/sec to/from disk |
max_read_io_response_time | NUMBER | Maximum read I/O response time |
max_total_io | NUMBER | Maximum total I/O, hits/sec to/from disk |
max_total_io_response_time | NUMBER | Maximum total I/O response time |
max_write_hit_io | NUMBER | Maximum write hit I/O, hits/sec to/from cache |
max_write_io | NUMBER | Maximum write I/O, hits/sec to/from disk |
max_write_io_response_time | NUMBER | Maximum write I/O response time |
min_read_hit_io | NUMBER | Minimum read hit I/O, hits/sec to/from cache |
min_write_hit_io | NUMBER | Minimum write hit I/O, hits/sec to/from cache |
read_hit_io | NUMBER | Read hit I/O, hits/sec to/from cache |
read_io | NUMBER | Read I/O |
read_io_response_time | NUMBER | Read I/O response time |
read_io_time_counter | NUMBER | Read I/O time counter |
stddev_kbytes_read | NUMBER | Standard deviation of KiB read |
stddev_kbytes_written | NUMBER | Standard deviation of KiB written |
stddev_read_hit_io | NUMBER | Standard deviation of read hit I/O, hits/sec to/from cache |
stddev_read_io | NUMBER | Standard deviation of read I/O |
stddev_read_io_response_time | NUMBER | Standard deviation of read I/O response time |
stddev_total_io | NUMBER | Standard deviation of total I/O |
stddev_total_io_response_time | NUMBER | Standard deviation of total I/O response time |
stddev_write_hit_io | NUMBER | Standard deviation of write hit I/O, hits/sec to/from cache |
stddev_write_io | NUMBER | Standard deviation of write I/O |
stddev_write_io_response_time | NUMBER | Standard deviation of write I/O response time |
total_io | NUMBER | Total I/O |
total_io_response_time | NUMBER | Total I/O response time |
total_io_time_counter | NUMBER | Total IO/ time counter |
write_hit_io | NUMBER | Write hit I/O, hits/sec to/from cache |
write_io | NUMBER | Write I/O |
write_io_response_time | NUMBER | Write I/O response time |
write_io_time_counter | NUMBER | Write I/O time counter |
Column Name | Data Type | Description |
diff_kbytes_read | NUMBER | Difference of KiB read |
diff_kbytes_written | NUMBER | Difference of KiB written |
diff_read_hit_io | NUMBER | Difference of read hit IO |
diff_read_io | NUMBER | Difference of read IO |
diff_total_io | NUMBER | Difference of total IO |
diff_write_hit_io | NUMBER | Difference of write hit IO |
diff_write_io | NUMBER | Difference of read IO |
interval_sec | NUMBER | Interval in seconds |
kbytes_read | NUMBER | KiB read |
kybytes_written | NUMBER | KiB written |
log_date | DATE | Log date |
logical_unit_id | NUMBER | Foreign key from aps_v_logical_unit |
logical_unit_name | STRING | Name of the LUN |
prev_log_date | DATE | Previous log date |
read_hit_io | NUMBER | Read hit IO |
read_io | NUMBER | Read IO |
read_io_response_time | NUMBER | Read IO response time |
read_io_time_counter | NUMBER | Read IO time counter |
total_io_response_time | NUMBER | Total IO response time |
total_io_time_counter | NUMBER | Total IO time counter |
write_hit_io | NUMBER | Write hit IO |
write_io | NUMBER | Write IO |
write_io_response_time | NUMBER | Write IO response time |
write_io_time_counter | NUMBER | Write IO time counter |
Column Name | Data Type | Description |
member_disk_id | NUMBER | Foreign key to host disk details |
virtual_disk_id | NUMBER | Primary key to multi-path disks |
Column Name | Data Type | Description |
file_system_name | STRING | File system name |
filesystem_id | NUMBER | Foreign key to the file system details |
host_disk_id | NUMBER | Foreign key to host disk details |
host_id | NUMBER | Foreign key to host details |
host_name | STRING | Host name |
partition_name | STRING | Partition name |
partition_size_gb | NUMBER | Partition size in GiB |
partition_size_kb | NUMBER | Partition size in KiB |
volume_group_id | NUMBER | Foreign key to the volume group details |
volume_group_name | STRING | Logical volume group name |
volume_partition_id | NUMBER | Foreign key to the volume partition |
Column Name | Data Type | Description |
array_name | STRING | Storage Array Name |
capacity_gb | NUMBER | Capacity in GiB |
capacity_kb | NUMBER | Capacity in KiB |
chassis_nbr | NUMBER | Chassis Number |
disk_type | STRING | Disk type |
firmware_version | STRING | Firmware Version |
hot_spare | CHAR | Indicates if the physical device is a hot spare |
last_updated | DATE | Date/time this pdev was last created/updated |
model | STRING | Model |
pdev_id | NUMBER | Pdev ID |
pdev_name | STRING | Pdev Name |
rpm | STRING | Disk speed |
serial_nbr | STRING | Serial Number |
storage_array_id | NUMBER | Storage Array ID |
vendor | STRING | Device Vendor |
vendor_disk_type | STRING | Vendor disk type |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to host details |
host_name | STRING | Host name |
primary_ip_address | STRING | Primary IP address of the host |
related_host_names | STRING | Related host names – hosts that share a clustered disk as failover hosts |
Column Name | Data Type | Description |
agent_version | STRING | Agent version |
allocated_gb | NUMBER | Allocated configured capacity in GiB |
allocated_kb | NUMBER | Allocated configured capacity in KiB |
array_family | STRING | Array family |
array_group_allocated | NUMBER | Allocated capacity of the array groups in the array |
array_group_available | NUMBER | Available capacity of the array groups in the array |
array_group_capacity | NUMBER | Total capacity of the array groups in the array |
array_name | STRING | Array name |
array_type | STRING | Array type |
available_gb | NUMBER | Available configured capacity in GiB |
available_kb | NUMBER | Available configured capacity in KiB |
cache_gb | NUMBER | Array cache size in GiB |
cache_kb | NUMBER | Array cache size in KiB |
capacity_gb | NUMBER | Configured capacity in GiB |
capacity_kb | NUMBER | Configured capacity in KiB |
controller_version | STRING | Storage array controller version |
device_manager_id | NUMBER | Foreign key to device manager details |
domain_id | NUMBER | Foreign key to domain details |
domain_name | STRING | Domain name |
estimated_used_kb | NUMBER | Total estimated used capacity (KiB) of the logical units in the array. |
ip_address | STRING | IP address of the storage array |
is_active | STRING | Y or N. A flag indicating if this array is still active. Y = active, N = inactive. If several arrays had been managed by a device manager and then one array is removed, this flag will indicate which array is inactive and data collection will no longer occur for the inactive array. If the inactive array is moved to a different device manager, it will be treated as a new array because it is now managed by a different device manager; a new array ID will be created and collection will occur on this array (even though it was previously flagged as an inactive array). |
is_rm_enabled | STRING | A flag indicating if this replication data is collected for this array |
largest_free_space_gb | NUMBER | Largest free space available on the storage array, in GiB |
largest_free_space_kb | NUMBER | Largest free space available on the storage array, in KiB |
last_updated | DATE | Last updated date |
nbr_allocated_luns | NUMBER | Number of allocated logical units |
nbr_array_ports | NUMBER | Number of array ports |
nbr_hosts | NUMBER | Number of hosts |
nbr_of_array_groups | NUMBER | Number of Array Groups in the array |
nbr_of_ethernet_ports | NUMBER | Number of Ethernet ports in the array |
nbr_of_fc_ports | NUMBER | Number of Fibre Channel ports in the array |
nbr_of_iscsi_ports | NUMBER | Number of iSCSI ports in the array |
nbr_of_luns | NUMBER | Number of logical units |
nbr_of_physical_disks | NUMBER | Number of physical disks in the array |
nbr_of_storage_pools | NUMBER | Number of storage pools in the array |
nbr_of_thin_pools | NUMBER | Number of thin pools in the array |
object_id | STRING | Unique internal ID for the storage array |
other_allocated_gb | NUMBER | Other allocated in GiB |
other_allocated_kb | NUMBER | Other allocated in KiB |
pool_allocate_kb | NUMBER | Total capacity of the storage pools in the array that have LUNs created |
product_name | STRING | Product name |
raw_allocated_gb | NUMBER | Allocated raw capacity in GiB |
raw_allocated_kb | NUMBER | Allocated raw capacity in KiB |
raw_available_gb | NUMBER | Available raw capacity in GiB |
raw_available_kb | NUMBER | Available raw capacity in KiB |
raw_capacity_gb | NUMBER | Raw capacity in GiB |
raw_capacity_kb | NUMBER | Raw capacity in KiB |
replication_capacity_kb | NUMBER | Total capacity of the logical units in the array that are marked as replication storage |
root_group_id | NUMBER | Foreign key to root group details |
serial_nbr | STRING | Storage array serial number |
storage_array_id | NUMBER | Foreign key to the storage array details |
thin_pool_allocated_kb | NUMBER | Total capacity of the thin pools in the array that have LUNs created |
thin_pool_available_kb | NUMBER | Total capacity of the thin pools in the array that do not have LUNs created |
thin_pool_capacity_kb | NUMBER | Total capacity of the thin pools in the array |
thin_pool_subscribed_kb | NUMBER | Total capacity of the thin pools in the array that are subscribed by hosts |
thin_pool_subscribed_pct | NUMBER | The percentage (%) of the thin pool subscribed capacity vs thin pool total capacity |
usable_external_capacity_gb | NUMBER | Usable external capacity in GiB |
usable_external_capacity_kb | NUMBER | Total Capacity from back-end, external volumes in KiB |
usable_free_capacity_gb | NUMBER | Usable free capacity in GiB |
usable_free_capacity_kb | NUMBER | Usable free capacity in KiB |
usable_internal_capacity_gb | NUMBER | Usable internal capacity in GiB |
usable_internal_capacity_kb | NUMBER | Usable internal capacity in KiB |
usable_used_capacity_gb | NUMBER | Usable used capacity in GiB |
usabled_used_capacity_kb | NUMBER | Usable used capacity in KiB |
vendor_name | STRING | Vendor name |
virtualized_capacity_kb | STRING | Total capacity for volumes that are in use, but are not allocated for the virtual array |
Column Name | Data Type | Description |
allocated_gb | NUMBER | Storage allocate in GiB |
array_name | STRING | Array name |
available_gb | NUMBER | Available configured capacity in GiB |
cache_gb | NUMBER | Array cache size in GiB |
capacity_gb | NUMBER | Configured capacity in GiB |
largest_free_space_gb | NUMBER | Largest free space available on the storage array, in GiB |
log_date | DATE | Date of the storage array log |
nbr_allocated_luns | NUMBER | Number of allocated logical units |
nbr_of_luns | NUMBER | Number of logical units |
raw_allocated_gb | NUMBER | Allocated raw capacity in GiB |
raw_available_gb | NUMBER | Available raw capacity in GiB |
raw_capacity_gb | NUMBER | Raw capacity in GiB |
storage_array_id | NUMBER | Foreign key to the storage array details |
virtual_capacity_gb | NUMBER | Virtual capacity in GiB |
known_virtual_capacity_gb | NUMBER | Known virtual capacity in GiB |
license_capacity_gb | NUMBER | License capacity in GiB |
usable_internal_capacity_gb | NUMBER | Usable internal capacity in GiB |
usable_external_capacity_gb | NUMBER | Usable external capacity in GiB |
usable_used_capacity_gb | NUMBER | Usable used capacity in GiB |
usable_free_capacity_gb | NUMBER | Usable free capacity in GiB |
virtualized_capacity_gb | NUMBER | Virtualized capacity in GiB |
nbr_unallocated_luns | NUMBER | Number of unallocated logical units |
lun_capacity_gb | NUMBER | LUN total capacity in GiB |
lun_allocated_gb | NUMBER | LUN allocated capacity in GiB |
lun_unallocated_gb | NUMBER | LUN unallocated capacity in GiB |
thin_pool_capacity_gb | NUMBER | Thin pool total capacity in GiB |
thin_pool_allocated_gb | NUMBER | Thin pool allocated capacity in GiB |
thin_pool_available_gb | NUMBER | Thin pool available capacity in GiB |
thin_pool_subscribed_gb | NUMBER | Thin pool subscribed capacity in GiB |
Column Name | Data Type | Description |
array_family | STRING | Array family |
array_name | STRING | Array name |
array_port_id | NUMBER | Foreign key to the array port details |
array_port_wwn | STRING | Array port world wide name |
device_nbr | NUMBER | Device number |
host_port_id | NUMBER | Foreign key to the host port details |
host_port_wwn | STRING | Host port world wide name |
host_storage_domain | STRING | Host storage domain |
logical_unit_id | NUMBER | Foreign key to the logical unit detail |
logical_unit_name | STRING | Logical unit name |
lun_nbr | NUMBER | Logical unit number |
nbr_allocated_luns | NUMBER | Number of allocated logical units |
nbr_of_luns | NUMBER | Number of logical units |
object_id | STRING | Unique internal identifier for the storage path |
path_id | NUMBER | Foreign key to path details |
path_name | STRING | Path name |
port_name | STRING | Array port name |
port_nbr | NUMBER | Array port number |
port_role | STRING | Possible values: Initiator, RCU Target, Target |
raid_type | STRING | RAID type |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_domain_id | NUMBER | Foreign key to storage domain details |
total_capacity_kb | NUMBER | Total capacity in KiB |
total_capacity_gb | NUMBER | Total capacity in GiB |