General Capacity Manager Database Views Version 10.0.00

Capacity Manager Database Views > General Capacity Manager Database Views

Version 10.0.00

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

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
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

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_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