Storage Viewer for Capacity Database Views > aps_v_file_system_path
  
Version 10.0.01
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