Functions and Views for All Products > Detailed View Descriptions (All Products)
  
Version 9.2.00
Detailed View Descriptions (All Products)
apt_v_attribute
The apt_v_attribute view provides details about user-defined attributes.
Table 2.1 apt_v_attribute
Column Name
Data Type
Description
attribute_id
NUMBER
Sequence generated Primary key
attribute_name
STRING
Attribute name
attribute_type
STRING
Attribute type
attribute_type_name
STRING
S = Server, A = Array, L = Library, D = Drive, W = Switch
description
STRING
Description
domain_id
NUMBER
Foreign key from apt_v_domain
list_of_values
STRING
List of values
apt_v_domain
The apt_v_domain view contains a single row for each storage array domain. This view supersedes aps_v_domain.
Table 2.2 apt_v_domain
Column Name
Data Type
Description
aptare_community_enrolled
STRING
Enrolled in the array performance statistics sharing
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
last_updated
DATE
Date of the last update
root_group_id
NUMBER
ID of the server group which is the root group for this domain
apt_v_execution_tracking
The data in the apt_v_execution_tracking view provides a historical record of the execution of report templates. This view provides a means of identifying slow-running reports.
Table 2.3 apt_v_execution_tracking
Column Name
Data Type
Description
db_elapsed_time_ms
NUMBER
Time taken for database access
elapsed_time_ms
NUMBER
Elapsed time in milliseconds
page_size
NUMBER
Page size
params
STRING
Report parameters
report_template_id
NUMBER
Report Template ID
report_template_name
STRING
Report Template Name
transaction_timestamp
DATE
Transaction timestamp
ui_elapsed_time_ms
NUMBER
Time taken for user-interface processing
user_id
NUMBER
User ID
user_name
STRING
User Name
apt_v_group
The apt_v_group view contains a single row for each hierarchical server group. The top-most group on a new customer install is usually “/APTARE”. Users can change the name of this group and create any level of
sub-groups under this tree structure.
Table 2.4 apt_v_group
Column Name
Data Type
Description
group_description
STRING
Description of the server group
group_id
NUMBER
Foreign key to apt_v_group
group_name
STRING
Name of the server group
apt_v_group_member
The apt_v_group_member view contains a single row for each of the parent/child relationships that create the server group hierarchy. For example, for each client that is a member of a single server group, a row will exist within this view.
Table 2.5 apt_v_group_member
Column Name
Data Type
Description
child_id
NUMBER
If child_type = 1, foreign key to apt_v_server
If child_type = 2, foreign key to apt_v_group
child_type
NUMBER
Enumeration field with the following possible values:
1 = child is a server group
2 = child is a client/server
date_modified
DATE
Date/time this record was last created/updated
group_id
NUMBER
Unique group ID. Primary key in this view
modified_by
NUMBER
User ID of the user who modified this group member
modified_by_name
STRING
Name of the user who modified this group member
apt_v_host_collector_status
The apt_v_host_collector_status view contains a single row for each of the host resource data collector status messages. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.6 apt_v_host_collector_status
Column Name
Data Type
Description
collector_id
NUMBER
Collector ID
collector_name
STRING
Collector Name
command_output
STRING
Command output
event_status
STRING
Event Status
event_time
DATE
Event Time Stamp
event_type
STRING
Event Type
host_id
NUMBER
Foreign key to apt_v_server
host_name
STRING
Host Name
ip_address
STRING
Host IP Address
msg_detail
STRING
Message Details
msg_summary
STRING
Message Summary
payload_id
NUMBER
The Payload ID is the policy name defined in the Portal for the Host Resources data collector.
payload_name
STRING
Payload Name
resolution
STRING
Resolution
apt_v_host_cpu
The apt_v_host_cpu view contains a single row for each host CPU. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.7 apt_v_host_cpu
Column Name
Data Type
Description
cpu_nbr
NUMBER
The number of the CPU in the host
cpu_speed
NUMBER
CPU speed
cpu_type
STRING
CPU type
cpu_vendor
STRING
Manufacturer of the CPU
external_name
STRING
Server name used for report displays
internal_name
STRING
Server’s internal name
server_id
NUMBER
Foreign key to apt_v_server
apt_v_host_cpu_log
The apt_v_host_cpu_log view contains a single row for each host CPU log. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.8 apt_v_host_cpu_log
Column Name
Data Type
Description
cpu_nbr
NUMBER
The number of the CPU in the host
external_name
STRING
Server name used for report displays
idle_time_pct
NUMBER
Idle time percentage
internal_name
STRING
Server’s internal name
log_date
DATE
Log date
server_id
NUMBER
Foreign key to apt_v_server
system_processing_time_pct
NUMBER
System processing time percentage
user_processing_time_pct
NUMBER
User processing time percentage
wait_time_pct
NUMBER
Wait time percentage
apt_v_host_info
The apt_v_host_info view contains a single row for each host info. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.9 apt_v_host_info
Column Name
Data Type
Description
boot_prom
STRING
Boot PROM
external_name
STRING
Server name used for report displays
host_type
STRING
Host type with the following possible values:
VM Server,
VIO Server,
VM Guest,
VIO Guest,
Others
internal_name
STRING
Server’s internal name
make
STRING
Make of the host
model
STRING
Model of the host
os_platform
STRING
Operating System platform
os_version
STRING
Operating System version
os_bits
STRING
Operating System bits
server_id
NUMBER
Foreign key to apt_v_server
apt_v_host_memory
The apt_v_host_memory view contains a single row for each host memory. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.10 apt_v_host_memory
Column Name
Data Type
Description
external_name
STRING
Server name used for report displays
internal_name
STRING
Server’s internal name
page_file_size_kb
NUMBER
Page file size in KiB
page_file_location
STRING
Page file location
physical_memory_kb
NUMBER
Physical memory in KiB
server_id
NUMBER
Foreign key to apt_v_server
swap_file_size_kb
NUMBER
Swap file size in KiB
swap_file_location
STRING
Swap file location
virtual_memory_kb
NUMBER
Virtual memory in KiB
apt_v_host_memory_log
The apt_v_host_memory_log view contains a single row for each host memory log. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.11 apt_v_host_memory_log
Column Name
Data Type
Description
external_name
STRING
Server name used for report displays
internal_name
STRING
Server’s internal name
log_date
DATE
Log Date
page_blocks_free
NUMBER
Page blocks free
physical_memory_kb
NUMBER
Physical memory in KiB
server_id
NUMBER
Foreign key to apt_v_server
swap_file_used_kb
NUMBER
Swap file used in KiB
swap_file_free_kb
NUMBER
Swap file free in KiB
virtual_memory_free_kb
NUMBER
Virtual Memory free in KiB
virtual_memory_swap_kb
NUMBER
Virtual Memory swap in KiB
virtual_memory_used_kb
NUMBER
Virtual Memory used in KiB
vm_page_faults_in
NUMBER
Virtual Memory page faults - In
vm_page_faults_out
NUMBER
Virtual Memory page faults - Out
apt_v_host_network
The apt_v_host_network view contains a single row for each host network. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.12 apt_v_host_network
Column Name
Data Type
Description
external_name
STRING
Server name used for report displays
gateway
STRING
Host’s gateway to the network
hardware_address
STRING
Hardware address
internal_name
STRING
Server’s internal name
ip_address
STRING
IP address of the host
nic_name
STRING
Name of the network interface card
server_id
NUMBER
Unique server ID
speed_mbps
NUMBER
Speed in MB per second
status
STRING
Status of the host network connectivity
subnet_mask
STRING
Subnet mask
apt_v_host_network_log
The apt_v_host_network_log view contains a single row for each host network log. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.13 apt_v_host_network_log
Column Name
Data Type
Description
external_name
STRING
Server name used for report displays
internal_name
STRING
Server’s internal name
kilo_bytes_received
NUMBER
Received in kilobytes
kilo_bytes_sent
NUMBER
Sent in kilobytes
log_date
DATE
Log date
nic_name
STRING
Name of the network interface card
packets_dropped
NUMBER
Packets dropped
packets_received
NUMBER
Packets received
packets_sent
NUMBER
Packets sent
server_id
NUMBER
Foreign key to apt_v_server
apt_v_host_process_log
The apt_v_host_process_log view contains a single row for each host process log. Note that this view begins with apt (not aps), as it is designed for future applications that will not be limited to Capacity Manager.
Table 2.14 apt_v_host_process_log
Column Name
Data Type
Description
cpu_usage_pct
NUMBER
% of CPU usage
external_name
STRING
Server name used for report displays
internal_name
STRING
Server’s internal name
log_date
DATE
Date of the log
process_name
STRING
Process name
process_owner
STRING
Process owner
server_id
NUMBER
Foreign key to apt_v_server
virtual_memory_size_kb
NUMBER
Virtual memory size in KiB
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 Capacity Manager.
Table 2.15 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.
apt_v_note
The apt_v_note view contains the history information of a ticket created on an object.
Table 2.16 apt_v_note
Column Name
Data Type
Description
domain_id
NUMBER
Foreign key to apt_v_domain
modified_user
STRING
User who modified the note
note_date
DATE
Date the note was created
note_type
STRING
If it is an Object note or a Ticket note
object_id
NUMBER
Object ID - Job id or tape media id, etc.
object_type
NUMBER
Whether the object is Job or tape media, etc.
owner_user
STRING
If note is ticket note then it is the owner of the ticket
ticket_status
STRING
If note is ticket note then it is the status of the ticket
user_note
STRING
Text of the note
apt_v_object_alias
The apt_v_object_alias view contains a single row for each object alias.
Table 2.17 apt_v_object_alias
Column Name
Data Type
Description
alias_name
STRING
Alias name for this object
domain_id
NUMBER
Domain ID for the alias object
domain_name
STRING
Domain name for the alias object
is_user_maintained
STRING
Flag to indicate whether this object is maintained by user
object_alias_id
NUMBER
Unique identifier to apt_v_object_alias view
object_id
NUMBER
ID of this alias object
object_name
STRING
Name of the object
object_type
STRING
Type of the object
apt_v_object_attribute
The apt_v_object_attribute view is created dynamically to take into account user-added attributes.
Table 2.18 apt_v_object_attribute
Column Name
Data Type
Description
attribute_id
NUMBER
Foreign key from apt_v_attribute
attribute_value
STRING
Attribute value
object_id
NUMBER
Object ID
apt_v_server
The apt_v_server view contains a single row for each client or server within the StorageConsole 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 2.19 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 APTARE StorageConsole 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 StorageConsole 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
apt_v_server_attribute
This view is created dynamically to take into account user-added attributes.
Table 2.20 apt_v_server_attribute
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to apt_v_server.
host_name
STRING
Name of the host
apt_v_server_instance
The apt_v_server_instance view contains a single row for each client or server instance within the StorageConsole database.
Table 2.21 apt_v_server_instance
Column Name
Data Type
Description
backup_product_version
STRING
The backup software version on the master server
display_name
STRING
The name that is displayed on the StorageConsole 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
instance_name
STRING
Name of the instance
instance_restart_date
DATE
Instance restart date
is_active
CHAR
Y=Yes, N=No
port_number
NUMBER
Server’s port number
product_type
NUMBER
Enumeration field with the following possible values:
1 –Symantec NetBackup
2 – Symantec Backup Exec
3 – EMC NetWorker
4 – IBM Tivoli Storage Manager
5 – CommVault Galaxy
6 – HP Data Protector
product_type_name
STRING
Name of the above product
server_id
NUMBER
Foreign key to apt_v_server.
server_instance_id
NUMBER
Primary key for this view.
apt_v_system_upgrade
The apt_v_system_upgrade contains a single row for each system upgrade information
Table 2.22 apt_v_system_upgrade
Column Name
Data Type
Description
attempt_nbr
NUMBER
Number of attempts
component_id
NUMBER
ID of the component
component_name
STRING
Name of the component, such as the data collector policy.
component_type
STRING
Type of the component, such as collector.
created_date
DATE
Created date.
domain_id
NUMBER
Domain ID
message_from
STRING
Message From. For collector upgrade the message is from upgrade manager or from Ant
status
STRING
Status of the upgrade.
system_upgrade_id
NUMBER
Primary key of the database table.
updated_date
DATE
Date and time this data was updated in the database.
version_from
STRING
Software version upgrading to from
version_to
STRING
Software version upgrading to
apt_v_system_upgrade_detail
The apt_v_system_upgrade_detail contains a single row for each system upgrade detail information.
Table 2.23 apt_v_system_upgrade_detail
Column Name
Data Type
Description
message
STRING
Status or error message text
message_date
DATE
Date the message was logged
message_type
STRING
Message type, such as info, warning
system_upgrade_id
NUMBER
Foreign key to apt_v_system_upgrade
apt_v_user
The apt_v_user view contains a single row for each user.
Table 2.24 aps_v_user
Column Name
Data Type
Description
active_indicator
NUMBER
Flag to indicate whether user is active
cell_phone
STRING
Cell phone number of the user
email_address
STRING
Email address of the user
first_name
STRING
First name of the user
group_id
NUMBER
Starting group ID of the user
last_login_time
DATE
Date and time user last logged in
last_name
STRING
Last name of the user
user_id
NUMBER
Unique ID of the user
user_type
NUMBER
Type of User
work_phone
STRING
Work phone number of the user