Capacity Manager Database Views > General Capacity Manager Database Views
  
Version 10.0.01
General Capacity Manager Database Views
The following view are not specific to a storage array or vendor product.
aps_v_array_group
The aps_v_array_group view contains a single row for each array group.
Table 4.1 aps_v_array_group
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
usable_free_capacity_gb
NUMBER
Usable free capacity in GiB
usable_used_capacity_gb
NUMBER
Usable used capacity in GiB
aps_v_array_group_log
The aps_v_array_group_log view contains audit information for array groups.
Table 4.2 aps_v_array_group_log
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
aps_v_array_group_pdev
The aps_v_array_group_pdev view contains a single row for each array group to pdev relationship.
Table 4.3 aps_v_array_group_pdev
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
aps_v_array_port
The aps_v_array_port view contains a single row for each storage array port.
Table 4.4 aps_v_array_port
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
aps_v_array_port_stats_day_log
The aps_v_array_port_stats_day_log view contains a single row for each storage array port statistics daily log.
Table 4.5 aps_v_array_port_stats_day_log
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
aps_v_array_port_stats_log
The aps_v_array_port_stats_log view contains a single row for each storage array port statistics log.
Table 4.6 aps_v_array_port_stats_log
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
aps_v_atrisk_volumes
The aps_v_atrisk_volumes view contains a single row for each at-risk volume.
Table 4.7 aps_v_atrisk_volumes
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
aps_v_chargeback_log
The aps_v_chargeback_log view contains a single row for each storage array chargeback log.
Table 4.8 aps_v_chargeback_log
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
aps_v_chargeback_policy
The aps_v_chargeback_policy view contains a single row for each capacity chargeback policy.
Table 4.9 aps_v_chargeback_policy
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
aps_v_database_datafiles
The aps_v_database_datafiles view contains a single row for each database data file.
Table 4.10 aps_v_database_datafiles
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
aps_v_database_datafiles_log
The aps_v_database_datafiles_log view contains a single row for each database data file log.
Table 4.11 aps_v_database_datafiles_log
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
aps_v_database_instance
The aps_v_database_instance view contains a single row for each database instance.
Table 4.12 aps_v_database_instance
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
aps_v_database_instance_log
The aps_v_database_instance_log view contains a single row for each database instance log.
Table 4.13 aps_v_database_instance_log
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
aps_v_database_tablespace
The aps_v_database_tablespace view contains a single row for each database tablespace.
Table 4.14 aps_v_database_tablespace
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
aps_v_database_tablespace_log
The aps_v_database_tablespace_log view contains a single row for each database tablespace log.
Table 4.15 aps_v_database_tablespace_log
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
aps_v_domain
The aps_v_domain view contains a single row for each storage array domain. This view is only maintained for backward compatibility. See apt_v_domain for the most current incarnation of this view.
Table 4.16 aps_v_domain
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
aps_v_file_system
This view provides a single row for each file system to store the total and used capacity on the filesystem.
Table 4.17 aps_v_file_system
Column Name
Data Type
Description
available_kb
NUMBER
Available capacity on the file system in KiB
capacity_kb
NUMBER
Total capacity of the file system in KiB
file_system_name
STRING
File system name
file_system_type
STRING
File system type. If an unrecognizable file system is encountered, this value will be set to Unknown.
filesystem_id
NUMBER
Primary key to the file system
host_disk_id
NUMBER
Foreign key to apt_host_disk
host_id
NUMBER
Foreign key to apt_host
host_name
STRING
Host name
host_type
STRING
Host type with the following possible values:
VM Server,
VIO Server,
VM Guest,
VIO Guest,
Others
last_updated
DATE
date and time last updated
mount_point
STRING
File system mount point
parent_filesystem_id
NUMBER
Parent file system ID
quota_kb
NUMBER
Quota in kilobytes
reservation_kb
NUMBER
Reserved in KiB
storage_pool_id
NUMBER
Foreign key to apt_storage_pool
used_kb
NUMBER
Used capacity in KiB
aps_v_file_system_log
This view provides a single row for each log table to store the total and used capacity on the filesystem.
Table 4.18 aps_v_file_system_log
Column Name
Data Type
Description
capacity_kb
NUMBER
Capacity of the file system in KiB
display_name
STRING
Name displayed in the log
filesystem_id
NUMBER
Foreign key to the aps_file_system table
filesystem_name
STRING
Name of the file system
host_id
NUMBER
Foreign key to apt_host
host_name
STRING
Name of the host
log_date
DATE
Date and time when the log record was created
mount_point
STRING
The mount point string
used_kb
NUMBER
Used capacity on the file system in KiB
aps_v_file_system_path
The aps_v_file_system_path view contains a single row for each storage array file system path.
Table 4.19 aps_v_file_system_path
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
aps_v_file_system_stat
The aps_v_file_system_stat view contains a single row for each storage array file system’s statistics.
Table 4.20 aps_v_file_system_stat
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
aps_v_hba_node_detail
The aps_v_hba_node_detail view contains a single row for each HBA node.
Table 4.21 aps_v_hba_node_detail
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
aps_v_hba_port
The aps_v_hba_port view contains a single row for each hba port.
Table 4.22 aps_v_hba_port
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
aps_v_host
The aps_v_host view contains a single row for each client or server. This view should be queried when you wish to obtain the internal or external (display) name of any client or server. The host_id is the primary key in this view.
Table 4.23 aps_v_host
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
aps_v_host_alloc_unused_log
The aps_v_host_alloc_unused_log historically collects the allocated and unused SAN storage for each host.
Table 4.24 aps_v_host_alloc_unused_log
Column Name
Data Type
Description
allocated_kb
NUMBER
Total space allocated for the host
host_id
NUMBER
Foreign key to the host details
host_name
STRING
Name of the host
log_date
DATE
Date and time when the data was captured
unused_kb
NUMBER
Unused capacity
aps_v_host_array_port_path
The aps_v_host_array_port_path view contains a single row for each host to array port path.
Table 4.25 aps_v_host_array_port_path
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.
aps_v_host_disk
The aps_v_host_disk view contains a single row for each host disk.
Table 4.26 aps_v_host_disk
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
aps_v_host_disk_alias
The aps_v_host_disk_alias view contains a single row for each host disk alias.
Table 4.27 aps_v_host_disk_alias
Column Name
Data Type
Description
disk_alias_id
STRING
Disk alias ID
host_disk_id
NUMBER
Foreign key to host disk detail
last_updated
DATE
Date and time last updated
raw_disk_alias_path
STRING
Raw disk alias path
aps_v_host_info
The aps_v_host_info view contains a single row for each host.
Table 4.28 aps_v_host_info
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.
aps_v_host_luns
The aps_v_host_luns view contains a single row for each host LUN. Use this view to determine the host/LUN relationship.
Table 4.29 aps_v_host_luns
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
aps_v_host_nas_shares
The aps_v_host_nas_shares view contains a single row for each host NAS share.
Table 4.30 aps_v_host_nas_shares
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.
aps_v_host_ports
The aps_v_host_ports view contains a single row for each host port.
Table 4.31 aps_v_host_ports
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to host details
host_ports
STRING
Concatenated list of host ports
aps_v_host_software
The aps_v_host_software view contains software information on Hosts.
Table 4.32 aps_v_host_software
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
aps_v_host_storage
The aps_v_host_storage view contains a single row for each storage element for a host. Note that the lengths of most of the numeric columns are left blank, as they are calculated values.
Table 4.33 aps_v_host_storage
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
aps_v_host_volume
The aps_v_host_volume view contains a single row for each host volume.
Table 4.34 aps_v_host_volume
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
aps_v_logical_unit
The aps_v_logical_unit view contains a single row for each logical unit.
Table 4.35 aps_v_logical_unit
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
creation_date
DATE
Date and time this logical unit was created
estimated_used_gb
NUMBER
Estimated used capacity (GiB) of the logical units. File system_used / number_of_members (LUNs associated with the filesystem)
estimate_used_kb
NUMBER
Estimated used capacity (KiB) of the logical units. File system_used / number_of_members (LUNs associated with the filesystem)
group_name
STRING
Array group name in which this LUN resides
is_internal
STRING
Indicates if the LUNs are internal: Y or N
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
aps_v_logical_unit_pdev
The aps_v_logical_unit_pdev view contains a single row for each logical unit physical device (pdev) in an array.
Table 4.36 aps_v_logical_unit_pdev
Column Name
Data Type
Description
device_type
STRING
The device type of the device class
drive_capacity_kb
NUMBER
Capacity of the drive in KiB
drive_speed
NUMBER
Speed of the drive
drive_type
STRING
Drive type of the disk
is_hdp
STRING
Indicates if the drive is dynamically provisioned
is_local
STRING
Indicates that if false, the storage is on a remote storage system
last_updated
DATE
The date and time the data was last updated in the StorageConsole database
logical_unit_id
NUMBER
Foreign key to the logical unit physical device details
logical_unit_name
STRING
Name of the logical unit
no_of_drives
NUMBER
Total number of drives
raid_type
STRING
RAID type of used by the volume, such as non-raided, RAID1, RAID2
vendor_disk_type
STRING
Disk type used by the vendor
aps_v_lun_hosts
The aps_v_lun_hosts view contains a single row for each logical unit host.
Table 4.37 aps_v_lun_hosts
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
aps_v_lun_mapping
The aps_v_lun_mapping view contains a single row for each LUN mapping.
Table 4.38 aps_v_lun_mapping
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.
aps_v_lun_path
The aps_v_lun_path view contains a single row for each storage array LUN path.
Table 4.39 aps_v_lun_path
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
aps_v_lun_perform_log
The aps_v_lun_perform_log view contains raw LUN performance history data.
Note: This view was altered in StorageConsole version 9.2.01P4, with more than 30 columns removed. Also, two LUN performance views were deprecated in version 9.2.01P4: aps_v_lun_stats_day_log and aps_v_lun_stats_log.
Column Name
Data Type
Description
array_name
STRING
Name of the array.
CUM_INTERVAL_SEC
NUMBER
Time interval in seconds for which the data was collected for the daily LUN performance log.
 
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
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.
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.
aps_v_multi_path_disk
The aps_v_multi_path_disk view contains a single row for each disk path type for multi-path disks.
Table 4.40 aps_v_multi_path_disk
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
aps_v_partition_disk
The aps_v_partition_disk view contains a single row for each partition disk.
Table 4.41 aps_v_partition_disk
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
aps_v_pdev
The aps_v_pdev view provides physical device details.
Table 4.42 aps_v_pdev
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
aps_v_related_hosts
The aps_v_related_hosts view contains a single row for each partition disk.
Table 4.43 aps_v_related_hosts
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
nbr_of_related_hosts
NUMBER
Number of related hosts
related_host_names
STRING
Related host names – hosts that share a clustered disk as failover hosts
aps_v_storage_array
The aps_v_storage_array view contains a single row for each storage array.
Table 4.44 aps_v_storage_array
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
creation_date
DATE
Date and time the storage array was added to the database
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
aps_v_storage_array_log
The aps_v_storage_array_log view contains a single row for each storage array log.
Table 4.45 aps_v_storage_array_log
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
aps_v_storage_path
The aps_v_storage_path view contains a single row for each storage array path.
Table 4.46 aps_v_storage_path
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_id
NUMBER
Foreign key to the host details
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