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