Functions and Views for All Products > apt_v_server
  
Version 10.0.01
apt_v_server
The apt_v_server view contains a single row for each client or server within the Storage Viewer database. This view should be queried to obtain the internal or external (display) name of any client or server. The first column, server_id, is the primary key in this view.
Table 24 apt_v_server
Column Name
Data Type
Description
capture_file_details
NUMBER
0 = Do NOT capture file-level details for this client/server and 1=Capture file-level details for this server
creation_date
DATE
The date and time the host was created in the Hitachi Storage Viewer database.
date_modified
DATE
Date/time this record was last created/updated
description
STRING
Free-form client/server description field. Users will often enter system characteristics such as the number and type of CPUs, amount of memory etc in this field
display_name
STRING
The name that is displayed on the Storage Viewer Web Interface for this client/server.
hostname
STRING
The hostname 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
ip_address
STRING
IP Address of the backup interface for this client/server
location
STRING
This is a customer-definable column where you would likely enter the physical/geographic location of the server—for example, Chicago.
make
STRING
Enumeration field with the following possible values:
Sun
Dell
HP / Compaq
IBM
Other
Unknown
model
STRING
Model of the client/server
exists_within_host
NUMBER
Indicates in which host it exists
bitflags
RAW
Bit flags
is_auto_update_aptare.jar
STRING
Indicates if the server is configured to update aptare.jar automatically
is_manu_update_aptare.jar
STRING
Indicates if the server is configured to update aptare.jar manually
aptare_jar_last_request
DATE
Date and time of the last request for an aptare.jar update
is_auto_update_boot_strap_jar
STRING
Indicates if the server is configured to update bootstrap.jar automatically
is_manu_update_boot_strap_jar
STRING
Indicates if the server is configured to update bootstrap.jar manually
boot_strap_jar_last_request
DATE
Date and time of the last request for a bootstrap.jar update
os_platform
STRING
OS platform
os_bits
STRING
OS bits
boot_prom
STRING
Boot PROM
os_version
STRING
Operating system
server_id
NUMBER
Primary key for this view.
server_type_name
STRING
Enumeration field with the following possible values:
client
NetBackup Master
NetBackup Media
NetWorker Server
NetWorker Storage Node
TSM Server
TSM Media Server
BackupExec Server
Data Collector Server
99 - Other