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