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 |
Column Name | Data Type | Description |
component | STRING | Abbreviation of the subsystem for which logging details are captured. Possible values: BASE - Base, common to all backup collection NBU - NetBackup BUE - Backup Exec LEG - Legato/NetWorker TSM - Tivoli Storage Manager HPD - HP Data Protector AVM - Avamar GEN - Generic Backup CMV - Commvault Simpana SRM - Base, common to all capacity collection SRM HDS - Hitachi Data Systems SRM HDS HNAS - HDS H-NAS SRM EMC - EMC common SRM EMC CLA - EMC CLARiiON SRM EMC SYM - EMC Symmetrix SRM EMC VNX - EMC Celerra SRM EMC ISI - EMC Isilon SRM EMC VPL - EMC Vplex SRM NAP - NetApp common SRM NAP NTC - NetApp Cluster-Mode SRM HP - Hewlett-Packard SRM HP 3PAR - HP 3PAR SRM IBM - IBM common SRM IBM SVC - IBM SVC SRM IBM XIV - IBM XIV SRM DLL CPL - Dell Compellent SRM EVA - HP EVA SRM OSS - OpenStack Swift SRM SDK - Generic Storage Array SRM HOST - Host SRM BROCADE LT - Brocade Zone Alias SRM CISCO LT - Cisco Zone Alias DATA DOMAIN - Data Domain VMM - Virtualization base VMM VMW - VMware VMM VIO - IBM VIO VMM SOL - Oracle Container/Zone SNAPMIRROR - NetApp SnapMirror SNAPVAULT - NetApp SnapVault SDK - SDK Generic Storage Array SWI - Switch base AFA - File Analytics |
package_name | STRING | Name of database package for which logging details are captured. |
procedure_name | STRING | Name of database procedure for which logging details are captured. |
sum_nbr_of_records | NUMBER | Total number of records processed for this database procedure call in this log hour. |
sum_db_elapsed_time_sec | NUMBER | Sum of the time spent in this log hour for this database procedure call. |
min_db_time_per_rec_sec | NUMBER | Minimum time spent in this log hour for this database procedure call. |
max_db_time_per_rec_sec | NUMBER | Maximum time spent in this log hour for this database procedure call. |
max_db_time_per_rec_date | DATE | Exact time at which this database call took maximum time to complete in this log hour. |
log_hour | NUMBER | The hour of the day for which data is saved in this table. |
last_updated | DATE | Date/Time when the data was captured for this procedure. |
Column Name | Data Type | Description |
component | STRING | Abbreviation of the subsystem for which logging details are captured. Possible values: BASE - Base, common to all backup collection NBU - NetBackup BUE - Backup Exec LEG - Legato/NetWorker TSM - Tivoli Storage Manager HPD - HP Data Protector AVM - Avamar GEN - Generic Backup CMV - Commvault Simpana SRM - Base, common to all capacity collection SRM HDS - Hitachi Data Systems SRM HDS HNAS - HDS H-NAS SRM EMC - EMC common SRM EMC CLA - EMC CLARiiON SRM EMC SYM - EMC Symmetrix SRM EMC VNX - EMC Celerra SRM EMC ISI - EMC Isilon SRM EMC VPL - EMC Vplex SRM NAP - NetApp common SRM NAP NTC - NetApp Cluster-Mode SRM HP - Hewlett-Packard SRM HP 3PAR - HP 3PAR SRM IBM - IBM common SRM IBM SVC - IBM SVC SRM IBM XIV - IBM XIV SRM DLL CPL - Dell Compellent SRM EVA - HP EVA SRM OSS - OpenStack Swift SRM SDK - Generic Storage Array SRM HOST - Host SRM BROCADE LT - Brocade Zone Alias SRM CISCO LT - Cisco Zone Alias DATA DOMAIN - Data Domain VMM - Virtualization base VMM VMW - VMware VMM VIO - IBM VIO VMM SOL - Oracle Container/Zone SNAPMIRROR - NetApp SnapMirror SNAPVAULT - NetApp SnapVault SDK - SDK Generic Storage Array SWI - Switch base AFA - File Analytics |
package_name | STRING | Name of database package for which logging details are captured. |
procedure_name | STRING | Name of database procedure for which logging details are captured. |
query_name | STRING | Name of SQL Query for which logging details are captured. |
nbr_of_records | NUMBER | Number of records processed for this database procedure call. |
db_elapsed_time_sec | NUMBER | Time spent for processing this database procedure call. |
last_updated | DATE | Date/Time when the data was captured for this procedure. |
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 |
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 |
system_name | STRING | System 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 |
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 |
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 |
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 |
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 |
Column Name | Data Type | Description |
cpu_util_pct | NUMBER | Percentage of CPU time during which I/O requests were issued to the device |
external_name | STRING | Server external name |
host_disk_id | NUMBER | Host disk ID |
internal_name | STRING | Server internal name |
log_date | DATE | Log date |
object_id | STRING | Object ID |
read_kps | NUMBER | Indicates the amount of data read from the device expressed in Kilobytes per second |
server_id | NUMBER | Unique server ID |
total_io_resp_time_ms | NUMBER | Total I/O response time in milliseconds for I/O requests issued to the device to be served |
total_io_tps | NUMBER | Total I/O transactions per second |
volume_partition_id | NUMBER | Volume partition ID |
write_kps | NUMBER | Indicates the amount of data written to the device expressed in Kilobytes per second |
Column Name | Data Type | Description |
cpu_util_pct | NUMBER | Percentage of CPU time during which I/O requests were issued to the device |
external_name | STRING | Server external name |
host_disk_id | NUMBER | Host disk ID |
internal_name | STRING | Server internal name |
log_date | DATE | Log date |
object_id | STRING | Object ID |
read_kps | NUMBER | Indicates the amount of data read from the device expressed in Kilobytes per second |
server_id | NUMBER | Unique server ID |
total_io_resp_time_ms | NUMBER | Total I/O response time in milliseconds for I/O requests issued to the device to be served |
total_io_tps | NUMBER | Total I/O transactions per second |
volume_partition_id | STRING | Volume Partition ID |
write_kps | NUMBER | Indicates the amount of data written to the device expressed in Kilobytes per second |
Column Name | Data Type | Description |
cpu_nbr | NUMBER | Number of CPUs |
external_name | STRING | Server external name |
idle_time_pct | NUMBER | Idle time percentage |
internal_name | STRING | Server internal name |
log_date | DATE | Log date |
nice_priority_time_pct | NUMBER | Nice priority time percentage |
server_id | NUMBER | Unique server ID |
steal_time_pct | NUMBER | Steal time percentage |
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 |
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 |
nice_priority_time_pct | NUMBER | Percentage of CPU utilization that occurred while executing at the user/application level with nice priority |
server_id | NUMBER | Foreign key to apt_v_server |
steal_time_pct | NUMBER | Percentage of time spent in involuntary wait by the virtual CPU or CPUs while the hypervisor was servicing another virtual processor |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
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 |
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 |
Column Name | Data Type | Description |
attribute_id | NUMBER | Foreign key from apt_v_attribute |
attribute_value | STRING | Attribute value |
object_id | NUMBER | Object ID |
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 |
Column Name | Data Type | Description |
host_id | NUMBER | Foreign key to apt_v_server. |
host_name | STRING | Name of the host |
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 –Veritas NetBackup • 2 – Veritas 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. |
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 |
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 |
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 |
homepage_id | NUMBER | User’s home page unique ID |
homepage_type | STRING | User’s home page type |
last_login_time | DATE | Date and time user last logged in |
last_name | STRING | Last name of the user |
ldap_id | STRING | User’s LDAP login ID |
my_report_folder_name | STRING | User’s folder name |
user_id | NUMBER | Unique ID of the user |
user_type | NUMBER | Type of User |
work_phone | STRING | Work phone number of the user |