Functions and Views for All Products > apt_v_host_source_info
  
Version 10.0.01
apt_v_host_source_info
The apt_v_host__source_info view contains a single row for each host’s source information. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Storage Viewer for Capacity.
Table 20 apt_v_host_source_info
Column Name
Data Type
Description
aptare_product_type
NUMBER
APTARE product type: 1 = backup, 2 = capacity, 4 = virtualization, 8 = replication, 16 = fabric, and 32 = file analytics.
backup_server_type
NUMBER
Backup server type.
boot_prom
STRING
Boot PROM of the host.
collector_id
NUMBER
Unique ID of the Data Collector that collected the host data.
collector_name
STRING
Name of the Data Collector that collected the host data.
creation_date
DATE
The date and time the host was added to the reporting database.
display_name
STRING
The name that is displayed on the Web interface for this client/server.
host_id
NUMBER
Foreign key to apt_v_server.
host_name
STRING
The hostname of the client/server. This is the name by which the client/server is known.
last_updated
DATE
Date and time this data was updated in the reporting database.
make
STRING
Make of the host.
model
STRING
Model of the host.
os_bits
STRING
OS bits, such as 32-bit or 64-bit.
os_platform
STRING
OS platform.
os_version
STRING
Operating system version.
primary_ip_address
STRING
Primary IP Address for this client/server.
product_vendor
NUMBER
Product vendor.
product_vendor_name
STRING
Product vendor name.