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