Capacity Manager Database Views > Hitachi NAS Array Database Views
  
Version 9.2.00
Hitachi NAS Array Database Views
aps_v_hnas_cifs_share
The aps_v_hnas_cifs_share view contains a single row for each Hitachi NAS CIFS share.
Table 4.177 aps_v_hnas_cifs_share
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
cache_options
STRING
Cache options for the CIFS share.
cifs_share_name
STRING
Name given to the CIFS share.
cifs_share_path
STRING
Path of the CIFS share.
creation_date
DATE
The date and time the HNAS CIFS Share data was created in the StorageConsole database.
evs_id
NUMBER
Unique ID for the enterprise virtual server (EVS) in the HNAS subsystem.
evs_name
STRING
Name given to the enterprise virtual server (EVS).
file_system_free_capacity_gb
NUMBER
File system free space, in GiB.
file_system_free_capacity_kb
NUMBER
File system free space, in KiB.
file_system_total_capacity_gb
NUMBER
File system size in GiB.
file_system_total_capacity_kb
NUMBER
File system size in KiB.
hnas_cifs_share_id
NUMBER
CIFS share ID, for internal use by the StorageConsole database.
hnas_evs_id
NUMBER
Enterprise virtual server (EVS) ID, for internal use by the StorageConsole database.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
instance_name
STRING
The instance name of the file system.
is_access_snapshots
STRING
Indicates the accessibility and visibility of the snapshot directory.
is_display_snapshots
STRING
Indicates if snapshots are enabled.
is_failed
STRING
Indicates if the file system is in a failed state.
is_follow_symlinks
STRING
Indicates if follow symlinks is enabled for the CIFS share.
is_formatted
STRING
Indicates if the file system is formatted.
is_mounted
STRING
Indicates if the file system is mounted.
is_recovered
STRING
Indicates if the file system is recoverable.
is_scan_for_viruses
STRING
Indicates if virus scanning is enabled on the file system.
is_thin_provisioned
STRING
Indicates if the file system is thinly provisioned.
last_updated
DATE
The date and time the HNAS CIFS share data was last updated in the StorageConsole database.
share_comment
STRING
Comment given to the share.
 
aps_v_hnas_evs
The aps_v_hnas_evs view contains a single row for each Hitachi NAS EVS.
Table 4.178 aps_v_hnas_evs
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS enterprise virtual server (EVS) data was created in the StorageConsole database.
evs_id
NUMBER
Unique ID for the enterprise virtual server (EVS) in the HNAS subsystem.
evs_name
STRING
Name given to the enterprise virtual server (EVS).
evs_status
STRING
Status of the enterprise virtual server (EVS).
evs_type
STRING
Enterprise virtual server (EVS) type.
hnas_evs_id
NUMBER
Internal StorageConsole database ID for the Hitachi NAS platform enterprise virtual server (EVS).
hnas_node_id
NUMBER
Node ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
is_enabled
STRING
Indicates if the Hitachi NAS platform enterprise virtual server (EVS) is enabled.
last_updated
DATE
The date and time the HNAS enterprise virtual server (EVS) data was last updated in the StorageConsole database.
node_id
NUMBER
Identifier of the Hitachi NAS clustered node.
node_name
STRING
Name of the Hitachi NAS clustered node.
aps_v_hnas_fc_port
The aps_v_hnas_fc_port view contains a single row for each Hitachi NAS fibre channel port.
Table 4.179 aps_v_hnas_fc_port
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS FC Port data was created in the StorageConsole database.
fc_link
STRING
Indicates if the fibre channel link is up.
fc_port_id
NUMBER
Fibre channel port ID.
fc_port_status
STRING
Status of the fibre channel port: Enabled or Disabled.
hnas_fc_port_id
NUMBER
Fibre channel port ID, for internal use by the StorageConsole database.
hnas_node_id
NUMBER
Node ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
last_updated
DATE
The date and time the HNAS FC Port data was last updated in the StorageConsole database.
node_id
NUMBER
Identifier of the Hitachi NAS clustered node.
node_name
STRING
Name of the Hitachi NAS clustered node.
node_wwn
STRING
Node World Wide Name.
node_wwn_id
NUMBER
Node World Wide Name identifier.
port_wwn
STRING
Port World Wide Name.
port_wwn_id
NUMBER
Port World Wide Name identifier.
aps_v_hnas_file_system
The aps_v_hnas_file_system view contains a single row for each Hitachi NAS filesystem.
Table 4.180 aps_v_hnas_file_system
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
auto_expand_status
STRING
Status of auto-expand.
available_capacity_gb
NUMBER
The amount of formatted available capacity, in GiB.
available_capacity_kb
NUMBER
The amount of formatted available capacity, in KiB.
cluster_size_gb
NUMBER
The cluster size, also known as the file system block size, of the file system in GiB. An - indicates that the cluster size was unavailable at data collection time.
cluster_size_kb
NUMBER
The cluster size, also known as the file system block size, of the file system in KiB. An - indicates that the cluster size was unavailable at data collection time.
confined_capacity_gb
NUMBER
The capacity to which the file system has been confined, in GiB. An - indicates that the file system is not confined.
confined_capacity_kb
NUMBER
The capacity to which the file system has been confined. An - indicates that the file system is not confined.
creation_date
DATE
The date and time the HNAS file system data was created in the StorageConsole database.
deduped_capacity_gb
NUMBER
Deduplicated capacity for the file system, in GiB.
deduped_capacity_kb
NUMBER
Deduplicated capacity for the file system, in KiB.
device_id
NUMBER
The file system's device ID.
dwb
STRING
Indicates if the file system is using dynamic write balancing (DWB).
evs_id
NUMBER
Unique ID for the enterprise virtual server (EVS) in the HNAS subsystem.
evs_name
STRING
Name given to the enterprise virtual server (EVS).
expansion_warn
STRING
After an auto-expansion, if the file system's capacity exceeds this % of its expansion potential, a warning event is logged.
file_system_state
STRING
State of the file system.
file_system_type
STRING
Provides file system characteristics, such as ro (read-only), syslocked (system locked), or WORM.
flag
STRING
Indicates the file system: Worm, RC, or PAFS.
hnas_evs_id
NUMBER
Enterprise virtual server (EVS) ID, for internal use by the StorageConsole database.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_span_id
NUMBER
Span ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
instance_name
STRING
The instance name of the file system.
is_audit
STRING
Indicates if auditing is enabled on the file system.
is_thin_provisioned
STRING
Indicates if the file system is thinly provisioned.
last_updated
DATE
The date and time the HNAS file system data was last updated in the StorageConsole database.
nbr_of_dsbs
NUMBER
The number of dynamic super blocks stored in the file system.
nbr_of_paths
NUMBER
Number of paths associated with the file system.
nbr_of_tiers
NUMBER
Number of tiers associated with the span.
snap
STRING
If the host snap is in snapshot mode, this value is the number of copies of the span. If the span is not in snapshot mode, the field is blank.
snapshot_capacity_gb
NUMBER
The amount (and percentage) of formatted capacity used by snapshots, in GiB. If the file system is a read cache file system this field will display Read Cache because the file system does not contain snapshots.
snapshot_capacity_kb
NUMBER
The amount (and percentage) of formatted capacity used by snapshots, in KiB. If the file system is a read cache file system this field will display Read Cache because the file system does not contain snapshots.
span_instance_name
STRING
The name that was assigned to the span when it was created.
thin_available_capacity_gb
NUMBER
The amount of thinly provisioned capacity available for further data, in GiB.
thin_available_capacity_kb
NUMBER
The amount of thinly provisioned capacity available for further data, in KiB.
thin_total_capacity_gb
NUMBER
The total amount of thinly provisioned capacity for the file system, in GiB.
thin_total_capacity_kb
NUMBER
The total amount of thinly provisioned capacity for the file system, in KiB.
total_capacity_gb
NUMBER
Total capacity of the file system in GiB.
total_capacity_kb
NUMBER
Total capacity of the file system in KiB.
used_capacity_gb
NUMBER
Used capacity of the file system, in GiB.
used_capacity_kb
NUMBER
Used capacity of the file system, in KiB.
wfs_version
STRING
The web file system (WFS) version: WFS-1 or WFS-2.
aps_v_hnas_file_system_log
The aps_v_hnas_file_system_log view contains a single row for each Hitachi NAS file system log entry.
Table 4.181 aps_v_hnas_file_system_log
Column Name
Data Type
Description
available_capacity_gb
NUMBER
The amount of formatted available capacity, in GiB.
available_capacity_kb
NUMBER
The amount of formatted available capacity, in KiB.
cluster_size_kb
NUMBER
The cluster size, also known as the file system block size, of the file system in KiB. An - indicates that the cluster size was unavailable at data collection time.
confined_capacity_gb
NUMBER
The capacity to which the file system has been confined, in GiB. An - indicates that the file system is not confined.
confined_capacity_kb
NUMBER
The capacity to which the file system has been confined. An - indicates that the file system is not confined.
deduped_capacity_gb
NUMBER
Deduplicated capacity for the file system, in GiB.
deduped_capacity_kb
NUMBER
Deduplicated capacity for the file system, in KiB.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
log_date
DATE
The date and time the HNAS file system log data was created in the database.
nbr_of_dsbs
NUMBER
The number of dynamic super blocks stored in the file system.
nbr_of_paths
NUMBER
Number of paths associated with the file system.
snapshot_capacity_gb
NUMBER
The amount (and percentage) of formatted capacity used by snapshots, in GiB. If the file system is a read cache file system this field will display Read Cache because the file system does not contain snapshots.
snapshot_capacity_kb
NUMBER
The amount (and percentage) of formatted capacity used by snapshots, in KiB. If the file system is a read cache file system this field will display Read Cache because the file system does not contain snapshots.
thin_available_capacity_gb
NUMBER
The amount of thinly provisioned capacity available for further data, in GiB.
thin_available_capacity_kb
NUMBER
The amount of thinly provisioned capacity available for further data, in KiB.
thin_total_capacity_gb
NUMBER
The total amount of thinly provisioned capacity for the file system, in GiB.
thin_total_capacity_kb
NUMBER
The total amount of thinly provisioned capacity for the file system, in KiB.
total_capacity_gb
NUMBER
Total capacity of the file system in GiB.
total_capacity_kb
NUMBER
Total capacity of the file system in KiB.
used_capacity_gb
NUMBER
Used capacity of the file system, in GiB.
used_capacity_kb
NUMBER
Used capacity of the file system, in KiB.
aps_v_hnas_interface
The aps_v_hnas_interface view contains a single row for each Hitachi NAS interface.
Table 4.182 aps_v_hnas_interface
Column Name
Data Type
Description
creation_date
DATE
The date and time the HNAS Interface data was created in the StorageConsole database.
hnas_interface_id
NUMBER
Interface ID, for internal use by the StorageConsole database.
hnas_node_id
NUMBER
Node ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
interface_name
STRING
Hitachi NAS interface name.
interface_type
STRING
Indicates the interface type: static or dynamic.
last_updated
DATE
The date and time the HNAS Interface data was last updated in the StorageConsole database.
load_balance
STRING
Load balance
node_id
NUMBER
Identifier of the Hitachi NAS clustered node.
node_name
STRING
Name of the Hitachi NAS clustered node.
aps_v_hnas_interface_member
The aps_v_hnas_interface_member view contains a single row for each Hitachi NAS interface member.
Table 4.183 aps_v_hnas_interface_member
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Interface member data was created in the StorageConsole database.
hnas_interface_id
NUMBER
Interface ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
interface_name
STRING
Hitachi NAS interface name.
last_updated
DATE
The date and time the HNAS Interface member data was last updated in the StorageConsole database.
port_name
STRING
Port name of the interface aggregation.
status
STRING
Status of the port: enabled or disabled.
aps_v_hnas_map_evs_interface
The aps_v_hnas_map_evs_interface view contains a single row for each HDS H-NAS Mapping between EVS and Interface.
Table 4.184 aps_v_hnas_map_evs_interface
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Map enterprise virtual server (EVS) to Interface data was created in the StorageConsole database.
evs_id
NUMBER
Unique ID for the enterprise virtual server (EVS) in the HNAS subsystem.
evs_name
STRING
Name given to the enterprise virtual server (EVS).
hnas_evs_id
NUMBER
Enterprise virtual server (EVS) ID, for internal use by the StorageConsole database.
hnas_interface_id
NUMBER
Interface ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Internal StorageConsole database ID for the Hitachi NAS platform enterprise virtual server (EVS).
interface_name
STRING
Hitachi NAS interface name.
ip_address
STRING
IP address of the enterprise virtual server (EVS) interface.
last_updated
DATE
The date and time the HNAS Map enterprise virtual server (EVS) to Interface data was last updated in the StorageConsole database.
aps_v_hnas_map_filesys_tier
The aps_v_hnas_map_filesys_tier view contains a single row for each Hitachi NAS filesystem tier.
Table 4.185 aps_v_hnas_map_filesys_tier
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
available_capacity_gb
NUMBER
The amount of formatted available capacity, in GiB.
available_capacity_kb
NUMBER
The amount of formatted available capacity, in KiB.
confined_capacity_gb
NUMBER
The capacity to which the file system has been confined, in GiB. An - indicates that the file system is not confined.
confined_capacity_kb
NUMBER
The capacity to which the file system has been confined, in KiB. An - indicates that the file system is not confined.
creation_date
DATE
The date and time the HNAS Map File system to Tier data was created in the StorageConsole database.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
hnas_tier_id
NUMBER
Tier ID, for internal use by the StorageConsole database.
instance_name
STRING
The instance name of the file system.
last_updated
DATE
The date and time the HNAS Map File system to Tier data was last updated in the StorageConsole database.
snapshot_capacity_gb
NUMBER
Capacity used for snapshots, in GiB.
snapshot_capacity_kb
NUMBER
Capacity used for snapshots, in KiB.
tier_name
STRING
Name of the HNAS tier.
total_capacity_gb
NUMBER
Total capacity of the tier in GiB.
total_capacity_kb
NUMBER
Total capacity of the tier in KiB.
used_capacity_gb
NUMBER
Used capacity of the tier, in GiB.
used_capacity_kb
NUMBER
Used capacity of the tier, in KiB.
aps_v_hnas_nfs_export
The aps_v_hnas_nfs_export view contains a single row for each Hitachi NAS NFS export.
Table 4.186 aps_v_hnas_nfs_export
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS NFS Export data was created in the StorageConsole database.
evs_id
NUMBER
Unique ID for the enterprise virtual server (EVS) in the HNAS subsystem.
evs_name
STRING
Name given to the enterprise virtual server (EVS).
file_system_free_capacity_gb
NUMBER
File system free space, in GiB.
file_system_free_capacity_kb
NUMBER
File system free space, in KiB.
file_system_total_capacity_gb
NUMBER
File system size, in GiB.
file_system_total_capacity_kb
NUMBER
Files ystem size, in KiB.
hnas_evs_id
NUMBER
Enterprise virtual server (EVS) ID, for internal use by the StorageConsole database.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_nfs_export_id
NUMBER
NFS export ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
instance_name
STRING
The instance name of the file system.
is_access_snapshots
STRING
Indicates the accessibility and visibility of the snapshot directory.
is_display_snapshots
STRING
Indicates if snapshots are enabled.
is_failed
STRING
Indicates if the file system is in a failed state
is_formatted
STRING
Indicates if the file system is formatted.
is_mounted
STRING
Indicates if the file system is mounted.
is_recovered
STRING
Indicates if the file system is recoverable.
is_thin_provisioned
STRING
Indicates if the file system is thinly provisioned.
last_updated
DATE
The date and time the H-NAS NFS export data was last updated in the StorageConsole database.
nfs_export_name
STRING
Name given to the NFS export.
nfs_export_path
STRING
NFS export path.
read_caching_status
STRING
Status of read caching.
aps_v_hnas_node
The aps_v_hnas_node view contains a single row for each Hitachi NAS node.
Table 4.187 aps_v_hnas_node
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Node data was created in the StorageConsole database.
ethernet_aggr_status
STRING
Ethernet aggregation status of the HNAS node.
fc_status
STRING
Fibre channel port status of the node.
fs_access_status
STRING
File system access status of the node.
hnas_node_id
NUMBER
Node ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
ip_address
STRING
IP address for the node.
is_cluster_master
STRING
Indicates if the node is a cluster master.
last_updated
DATE
The date and time the HNAS Node data was last updated in the StorageConsole database.
mgmnt_network_status
STRING
Management network status of the node.
nbr_of_evs
NUMBER
Number of Hitachi NAS platform enterprise virtual servers (EVS) associated with the node.
nbr_of_fc_ports
NUMBER
Number of fibre channel ports associated with the node.
node_id
NUMBER
Identifier of the Hitachi NAS clustered node.
node_name
STRING
Name of the Hitachi NAS clustered node.
system_model
STRING
System model of the clustered node.
aps_v_hnas_physical_disk
The aps_v_hnas_physical_disk view contains a single row for each Hitachi NAS physical disk.
Table 4.188 aps_v_hnas_physical_disk
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Physical Disk data was created in the StorageConsole database.
device_id
NUMBER
Device ID of the SCSI disk.
disk_revision
STRING
Revision of the storage array of the SCSI disk.
disk_status
STRING
Status of the HNAS physical disk.
disk_type
STRING
Type of HNAS physical disk.
hnas_physical_disk_id
NUMBER
Physical disk ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
in_use
STRING
Indicates if the HNAS physical disk is in use.
last_updated
DATE
The date and time the HNAS Physical Disk data was last updated in the StorageConsole database.
lun_nbr
NUMBER
LUN ID associated with the HNAS physical disk.
make
STRING
Manufacturer of the HNAS physical disk.
model
STRING
Model of the storage array where the HNAS the SCSI disks and LUNs reside.
port_status
STRING
Port status for the HNAS physical disk.
total_capacity_gb
NUMBER
Total capacity of the HNAS physical disk, in GiB.
total_capacity_kb
NUMBER
Total capacity of the HNAS physical disk, in KiB.
aps_v_hnas_physical_disk_pt
The aps_v_hnas_physical_disk_pt view contains a single row for each Hitachi NAS port of Physical Disk.
Table 4.189 aps_v_hnas_physical_disk_pt
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
 
DATE
The date and time the HNAS physical disk port data was created in the StorageConsole database.
device_id
NUMBER
Device ID of the SCSI disk.
hnas_physical_disk_id
NUMBER
Physical disk ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
last_updated
DATE
The date and time the HNAS physical disk port data was last updated in the StorageConsole database.
port_nbr
NUMBER
Port number of the HNAS physical disk.
aps_v_hnas_set
The aps_v_hnas_set view contains a single row for each Hitachi NAS set.
Table 4.190 aps_v_hnas_set
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Set data was created in the StorageConsole database.
hnas_set_id
NUMBER
Set ID, for internal use by the StorageConsole database.
hnas_span_id
NUMBER
Span ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
hnas_tier_id
NUMBER
Tier ID, for internal use by the StorageConsole database.
last_updated
DATE
The date and time the HNAS Set data was last updated in the StorageConsole database.
set_name
STRING
Name of the set in the span.
span_instance_name
STRING
The name that was assigned to the span when it was created.
tier_name
STRING
Name of the HNAS tier.
aps_v_hnas_snapshot
The aps_v_hnas_snapshot view contains a single row for each Hitachi NAS snapshot.
Table 4.191 aps_v_hnas_snapshot
Column Name
Data Type
Description
array_name
STRING
Name given to the storage array.
creation_date
DATE
The date and time the HNAS snapshot data was created in the StorageConsole database.
creation_date
DATE
The date and time the HNAS Snapshot data was created in the StorageConsole database.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
instance_name
STRING
The instance name of the file system.
last_updated
DATE
The date and time the HNAS Snapshot data was last updated in the StorageConsole database.
purpose_of_creation
STRING
Purpose/Reason for creating the snapshot.
snapshot_created_date
DATE
Date and time the snapshot was created.
snapshot_name
STRING
Name give to the snapshot.
snapshot_status
STRING
Status of the snapshot.
used_capacity_gb
NUMBER
Capacity used by virtual volume in GiB.
used_capacity_kb
NUMBER
Capacity used by virtual volume in KiB.
aps_v_hnas_span
The aps_v_hnas_span view contains a single row for each Hitachi NAS span.
Table 4.192 aps_v_hnas_span
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
auto_expand
STRING
Indicates if a span is auto-expandable.
chunk_size_gb
NUMBER
The guideline or approximate size of each chunk, in GiB.
chunk_size_kb
NUMBER
The guideline or approximate size of each chunk, in KiB.
confined_pct
NUMBER
Percentage of the span that is confined, which prevents its file systems from auto-expanding.
creation_date
 
The date and time the HNAS Span data was created in the StorageConsole database.
free_pct
NUMBER
Percentage of the span that is free space, unallocated to file systems.
hnas_span_id
NUMBER
Span ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
is_healthy
STRING
Indicates if the server has I/O with the file systems.
last_updated
DATE
The date and time the HNAS Span data was last updated in the StorageConsole database.
nbr_of_chunks
NUMBER
Number of chunks contained in the span.
nbr_of_file_systems
NUMBER
Number of file systems associated with the span.
nbr_of_sets
NUMBER
Number of sets associated with the span.
nbr_of_tiers
NUMBER
Number of tiers associated with the span.
span_instance_name
STRING
The name that was assigned to the span when it was created.
total_capacity_gb
NUMBER
Total capacity of the span in GiB.
total_capacity_kb
NUMBER
Total capacity of the span in KiB.
aps_v_hnas_storage_system
The aps_v_hnas_storage_system view contains a single row for each Hitachi NAS storage system.
Table 4.193 aps_v_hnas_storage_system
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
cluster_mode
STRING
Cluster mode indicates if the node is clustered.
creation_date
DATE
The date and time the HNAS Storage System data was created in the StorageConsole database.
file_system_free_capacity_gb
NUMBER
Free capacity of the file system in GiB.
file_system_free_capacity_kb
NUMBER
Free capacity of the file system in KiB.
file_system_total_capacity_gb
NUMBER
Total capacity of the file system in GiB.
file_system_total_capacity_kb
NUMBER
Total capacity of the file system in KiB.
file_system_used_capacity_gb
NUMBER
Used capacity of the file system in GiB.
file_system_used_capacity_kb
NUMBER
Used capacity of the file system in KiB.
gen_id
NUMBER
Cluster generation identifier.
health_status
STRING
Cluster’s health status.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
last_updated
DATE
The date and time the HNAS Storage System data was last updated in the StorageConsoledatabase.
nbr_of_cifs_shares
NUMBER
Number of CIFS shares associated with the cluster.
nbr_of_evs
NUMBER
Number of Hitachi NAS platform enterprise virtual servers (EVS) associated with the cluster.
nbr_of_file_systems
NUMBER
Number of file systems associate with the cluster.
nbr_of_interfaces
NUMBER
Number of interfaces associated with the cluster.
nbr_of_nfs_exports
NUMBER
Number of NFS exports associated with the cluster.
nbr_of_nodes
NUMBER
Number of nodes associated with the cluster.
nbr_of_physical_disks
NUMBER
Number of physical disks associated with the cluster.
nbr_of_thin_prov_file_systems
NUMBER
Number of thin-provisioned file systems associate with the cluster.
over_all_status
STRING
Overall status of the cluster.
system_model
STRING
System model of the clustered nodes.
uuid
STRING
Cluster UUID (universally unique identifier).
aps_v_hnas_system_drive
The aps_v_hnas_system_drive view contains a single row for each Hitachi NAS system drive.
Table 4.194 aps_v_hnas_system_drive
Column Name
Data Type
Description
access_status
STRING
HNAS system drive access status. Allowed = access to the system drive is allowed, otherwise the value is set to Denied.
array_name
STRING
The name given to the storage array.
block_size_byte
NUMBER
The number of bytes in an HNAS system drive data block.
creation_date
DATE
The date and time the HNAS System Drive data was created in the StorageConsole database.
ctl_node_wwn
STRING
A list of fibre channel node names of the controller that hosts the HNAS system drive.
ctl_port_wwn
STRING
The fibre channel WWN (World Wide Name) of the controller port through which the cluster is currently accessing the HNAS system drive.
device_id
NUMBER
HNAS system drive number assigned by the server to uniquely identify the system drive.
file_system_cod
STRING
Good = the HNAS system drive is used in a span whose filesystem code is all loadable; otherwise, the name of the file system code that does not load.
hds_ctl_port_name
STRING
Shown only for Hitachi Data Systems storage. This is the name of the controller port that the cluster is currently using to access the HNAS system drive.
hds_device_name
STRING
Shown only for Hitachi Data Systems storage. This is the HNAS system drive’s internal LUN.
hnas_physical_disk_id
NUMBER
Physical disk ID, for internal use by the StorageConsole database.
hnas_set_id
NUMBER
Set ID, for internal use by the StorageConsole database.
hnas_span_id
NUMBER
Span ID, for internal use by the StorageConsole database.
hnas_span_id_mirror
NUMBER
Mirrored span ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
hnas_system_drive_id
NUMBER
System drive ID, for internal use by the StorageConsole database.
hnas_tier_id
NUMBER
Tier ID, for internal use by the StorageConsole database.
is_unloadable_cod
STRING
Yes = the system drive has unloadable span Cod, otherwise this value is set to No.The date and time the HNAS System Drive data was last updated in the StorageConsole database.
last_updated
DATE
Date and time this data was last updated in the StorageConsole database.
luid
STRING
The locally unique identifier, a long string of characters, generated by the RAID controller to uniquely identify the HNAS system drive.
lun
NUMBER
The logical unit number (LUN) used by the RAID controller to identify a system drive.
mirror_role
STRING
The system drive's mirror role: primary or secondary.
sd_comment
STRING
User-assigned comment for the HNAS system drive.
sd_group
STRING
List of all the system drives that are in the same group as this HNAS system drive. This value will be None if the system drive is not in a group.
sd_status
STRING
The system drive’s status on the cluster node, as reported by the SCSI driver.
sd_type
STRING
The vendor, model and revision number that the RAID controller reports to the server; used to identify a specific system drive.
serial_nbr
STRING
System drive's serial number, as taken from the SCSI standard inquiry.
set_name
STRING
Name of the set in the span.
site_id
STRING
Site ID that an administrator has assigned to the HNAS system drive.
span_instance_name
STRING
The name that was assigned to the span when it was created.
span_instance_name_mirror
STRING
The name that was assigned to the mirror span when it was created.
submodel
STRING
If present, this provides additional information about the type of storage hardware.
super_flush
STRING
The number of data disks in the system drive, and the RAID5 stripe size. The server uses these details to optimize write operations.
tier_name
STRING
Name of the HNAS tier.
total_capacity_gb
NUMBER
Total capacity of the HNAS system drive in GiB.
total_capacity_kb
NUMBER
Total capacity of the HNAS system drive in KiB.
used_capacity_gb
NUMBER
Indicates how much of the system drive's capacity, in GiB, is being used by the currently-loaded span.
used_capacity_kb
NUMBER
Indicates how much of the system drive's capacity, in KiB, is being used by the currently-loaded span.
aps_v_hnas_tier
The aps_v_hnas_tier view contains a single row for each Hitachi NAS tier.
Table 4.195 aps_v_hnas_tier
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Tier data was created in the StorageConsole database.
free_capacity_gb
NUMBER
Free capacity of the span in GiB.
free_capacity_kb
NUMBER
Free capacity of the span in KiB.
hnas_span_id
NUMBER
Internal StorageConsole database span ID.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
hnas_tier_id
NUMBER
Tier ID, for internal use by the StorageConsole database.
last_updated
DATE
The date and time the HNAS Tier data was last updated in the StorageConsole database.
span_instance_name
STRING
The name that was assigned to the span when it was created.
tier_name
STRING
Name of the HNAS tier.
total_capacity_gb
NUMBER
Total capacity of the tier in GiB.
total_capacity_kb
NUMBER
Total capacity of the tier in KiB.
aps_v_hnas_virtual_volume
The aps_v_hnas_virtual_volume view contains a single row for each Hitachi NAS virtual volume.
Table 4.196 aps_v_hnas_virtual_volume
Column Name
Data Type
Description
array_name
STRING
The name given to the storage array.
creation_date
DATE
The date and time the HNAS Virtual Volume data was created in the StorageConsole database.
email_list
STRING
Email contact list of an existing virtual volume.
hnas_file_system_id
NUMBER
File system ID, for internal use by the StorageConsole database.
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
hnas_virtual_volume_id
NUMBER
Internal key, primary key in aps_hnas_virtual_volume.
instance_name
STRING
The instance name of the file system.
last_updated
DATE
The date and time the HNAS Virtual Volume data was last updated in the StorageConsole database.
nbr_of_files
NUMBER
Number of files used by virtual volume.
root_path
STRING
Path to the root of the virtual volume.
used_capacity_gb
NUMBER
Capacity used by virtual volume in GiB.
used_capacity_kb
NUMBER
Capacity used by virtual volume in KiB.
virtual_volume_name
STRING
Name of the virtual volume.
aps_v_hnas_virtual_vol_log
The aps_v_hnas_virtual_vol_log view contains a single row for each Hitachi NAS virtual volume log.
Table 4.197 aps_v_hnas_virtual_vol_log
Column Name
Data Type
Description
hnas_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
hnas_virtual_volume_id
NUMBER
Internal key, primary key in aps_hnas_virtual_volume.
log_date
DATE
The date and time the HNAS Virtual Volume log data was created in the database.
nbr_of_files
NUMBER
Number of files used by virtual volume.
used_capacity_gb
NUMBER
Capacity used by virtual volume in GiB.
used_capacity_kb
NUMBER
Capacity used by virtual volume in KiB.