Introduction to Database Views
Accessing Database Views
Functions and Views for All Products
Accessing the Published Database Views from the CLI
Viewing Report Query Examples
Using Pipeline Functions for Report Queries
General Functions
Backup Manager Functions
Policy Auditing Functions
Capacity Functions
Identifying a Host Group’s ID
Identifying a Host ID
Sample Diagram of Relationships
Detailed View Descriptions (All Products)
apt_v_attribute
apt_v_domain
apt_v_execution_tracking
apt_v_group
apt_v_group_member
apt_v_host_collector_status
apt_v_host_cpu
apt_v_host_cpu_log
apt_v_host_info
apt_v_host_memory
apt_v_host_memory_log
apt_v_host_network
apt_v_host_network_log
apt_v_host_process_log
apt_v_host_source_info
apt_v_note
apt_v_object_alias
apt_v_object_attribute
apt_v_server
apt_v_server_attribute
apt_v_server_instance
apt_v_system_upgrade
apt_v_system_upgrade_detail
apt_v_user
Capacity Manager Database Views
General Capacity Manager Database Views
aps_v_array_group
aps_v_array_group_log
aps_v_array_group_pdev
aps_v_array_port
aps_v_array_port_stats_day_log
aps_v_array_port_stats_log
aps_v_atrisk_volumes
aps_v_chargeback_log
aps_v_chargeback_policy
aps_v_database_datafiles
aps_v_database_datafiles_log
aps_v_database_instance
aps_v_database_instance_log
aps_v_database_tablespace
aps_v_database_tablespace_log
aps_v_domain
aps_v_file_system
aps_v_file_system_log
aps_v_file_system_path
aps_v_file_system_stat
aps_v_hba_node_detail
aps_v_hba_port
aps_v_host
aps_v_host_array_port_path
aps_v_host_disk
aps_v_host_info
aps_v_host_luns
aps_v_host_nas_shares
aps_v_host_ports
aps_v_host_software
aps_v_host_storage
aps_v_host_volume
aps_v_logical_unit
aps_v_lun_hosts
aps_v_lun_mapping
aps_v_lun_path
aps_v_lun_perform_log
aps_v_lun_stats_day_log
aps_v_lun_stats_log
aps_v_multi_path_disk
aps_v_partition_disk
aps_v_pdev
aps_v_related_hosts
aps_v_storage_array
aps_v_storage_array_log
aps_v_storage_path
Oracle ASM Database Views
aps_v_asm_dbclient
aps_v_asm_dbclient_diskio_log
aps_v_asm_disk
aps_v_asm_disk_log
aps_v_asm_diskgroup
aps_v_asm_diskgroup_dbclient
aps_v_asm_diskio_log
aps_v_asm_file
aps_v_asm_instance
aps_v_asm_san_details
Dell Compellent Array Database Views
aps_v_cpl_array_group
aps_v_cpl_controller
aps_v_cpl_fc_port
aps_v_cpl_iscsi_port
aps_v_cpl_logical_unit
aps_v_cpl_pdev
aps_v_cpl_replay
aps_v_cpl_replication
aps_v_cpl_server
aps_v_cpl_server_folder
aps_v_cpl_storage_array
aps_v_cpl_storage_profile
aps_v_cpl_tier_class
aps_v_cpl_tier_log
aps_v_cpl_tier_type
aps_v_cpl_volume_folder
EMC CLARiiON Array Database Views
aps_v_emc_cla_logical_unit
aps_v_emc_cla_pdev
aps_v_emc_cla_storage_pool
aps_v_emc_cla_storage_pool_log
EMC Isilon Array Database Views
aps_v_isi_array_performance
aps_v_isi_array_prf_log_day
aps_v_isi_array_prf_log_hr
aps_v_isi_array_prf_log_min
aps_v_isi_chassis
aps_v_isi_cifs_share
aps_v_isi_disk
aps_v_isi_disk_performance
aps_v_isi_disk_pool
aps_v_isi_disk_prf_log_day
aps_v_isi_disk_prf_log_hr
aps_v_isi_disk_prf_log_min
aps_v_isi_drive_bay
aps_v_isi_ftp
aps_v_isi_hdsf
aps_v_isi_license
aps_v_isi_nfs_client
aps_v_isi_nfs_export
aps_v_isi_nfs_export_path
aps_v_isi_node
aps_v_isi_node_interface
aps_v_isi_node_ip_address
aps_v_isi_node_performance
aps_v_isi_node_pool
aps_v_isi_node_prf_log_day
aps_v_isi_node_prf_log_hr
aps_v_isi_node_prf_log_min
aps_v_isi_onefs
aps_v_isi_onefs_performance
aps_v_isi_onefs_prf_log_day
aps_v_isi_onefs_prf_log_hr
aps_v_isi_onefs_prf_log_min
aps_v_isi_protocol_client
aps_v_isi_protocol_performance
aps_v_isi_protocol_prf_log_day
aps_v_isi_protocol_prf_log_hr
aps_v_isi_protocol_prf_log_min
aps_v_isi_snapshot
aps_v_isi_snapshot_schedule
aps_v_isi_storage_system
aps_v_isi_tier
EMC Symmetrix Array Database Views
aps_v_emc_sym_array_group
aps_v_emc_sym_fast_policy
aps_v_emc_sym_logical_unit
aps_v_emc_sym_map_pol_strgrp
aps_v_emc_sym_map_pol_tier
aps_v_emc_sym_map_strgrp_lun
aps_v_emc_sym_port
aps_v_emc_sym_storage_grp
aps_v_emc_sym_storage_path
aps_v_emc_sym_storage_pool
aps_v_emc_sym_storage_pool_log
aps_v_emc_sym_tier
EMC VNX Array Database Views
aps_v_vnx_array_group
aps_v_vnx_array_port
aps_v_vnx_backend_storage_sys
aps_v_vnx_checkpoint
aps_v_vnx_cifs_share
aps_v_vnx_control_station
aps_v_vnx_domain_server
aps_v_vnx_file_system
aps_v_vnx_file_system_log
aps_v_vnx_logical_network_dev
aps_v_vnx_logical_unit
aps_v_vnx_map_filesystem_vol
aps_v_vnx_map_mover_checkpoint
aps_v_vnx_map_mover_filesystem
aps_v_vnx_map_mover_pool
aps_v_vnx_map_mover_volume
aps_v_vnx_map_volumes
aps_v_vnx_mover
aps_v_vnx_mover_domain
aps_v_vnx_mover_interface
aps_v_vnx_mover_route
aps_v_vnx_nfs_export
aps_v_vnx_nfs_export_host
aps_v_vnx_pdev
aps_v_vnx_physical_device
aps_v_vnx_storage_endpoint
aps_v_vnx_storage_pool
aps_v_vnx_storage_pool_log
aps_v_vnx_storage_system
aps_v_vnx_tree
aps_v_vnx_user_quota
aps_v_vnx_volume
aps_v_vnx_volume_log
aps_v_vnx_volume_free_space
HP EVA Database Views
aps_v_eva_array_group
aps_v_eva_array_port
aps_v_eva_cache_memory
aps_v_eva_controller
aps_v_eva_host
aps_v_eva_host_port
aps_v_eva_logical_unit
aps_v_eva_pdev
aps_v_eva_storage_array
MS Exchange Database Views
aps_v_exch_org
aps_v_exch_storage_group
aps_v_exch_store
aps_v_exch_mailbox_folder
Hitachi NAS Array Database Views
aps_v_hnas_cifs_share
aps_v_hnas_evs
aps_v_hnas_fc_port
aps_v_hnas_file_system
aps_v_hnas_file_system_log
aps_v_hnas_interface
aps_v_hnas_interface_member
aps_v_hnas_map_evs_interface
aps_v_hnas_map_filesys_tier
aps_v_hnas_nfs_export
aps_v_hnas_node
aps_v_hnas_physical_disk
aps_v_hnas_physical_disk_pt
aps_v_hnas_set
aps_v_hnas_snapshot
aps_v_hnas_span
aps_v_hnas_storage_system
aps_v_hnas_system_drive
aps_v_hnas_tier
aps_v_hnas_virtual_volume
aps_v_hnas_virtual_vol_log
Hitachi Storage Array Database Views
aps_v_hds_array_group
aps_v_hds_journal_pool
aps_v_hds_journal_pool_log
aps_v_hds_journal_pool_tier
aps_v_hds_ldev
aps_v_hds_ldev_log
aps_v_hds_logical_unit
aps_v_hds_pdev
aps_v_hds_storage_array
aps_v_hds_virtual_volume
HP 3PAR Array Database Views
aps_v_h3p_array_group
aps_v_h3p_fc_port
aps_v_h3p_iscsi_port
aps_v_h3p_ldev
aps_v_h3p_logical_unit
aps_v_h3p_map_ldev_lun
aps_v_h3p_map_ldev_pdev
aps_v_h3p_node
aps_v_h3p_node_cpu
aps_v_h3p_pdev
aps_v_h3p_storage_system
IBM Storage Array Database Views
aps_v_ibm_array
aps_v_ibm_ckd_volume
aps_v_ibm_disk
aps_v_ibm_extent_pool
aps_v_ibm_fb_volume
aps_v_ibm_rank
aps_v_ibm_storage_subsystem
aps_v_ibm_storage_system
aps_v_ibm_subsys_array
aps_v_ibm_subsys_disk
aps_v_ibm_subsys_logical_drive
IBM VIO Database Views
apt_v_vio_disk_path
apt_v_vio_partition
apt_v_vio_scsi_adapter
apt_v_vio_server
apt_v_vio_target_device
apt_v_vio_virtual_system
Volume Manager Database Views
aps_v_vvm_host_disk
aps_v_vvm_lun
aps_v_vvm_plex
aps_v_vvm_sub_disk
aps_v_vvm_volume
NetApp Storage Systems Database Views
aps_v_nap_aggregate
aps_v_nap_cifs_share
aps_v_nap_disk
aps_v_nap_lun
aps_v_nap_nfs_export
aps_v_nap_quota
aps_v_nap_quota_log
aps_v_nap_quota_status
aps_v_nap_Qtree
aps_v_nap_snapshot
aps_v_nap_snapshot_log
aps_v_nap_snapshot_schedule
aps_v_nap_storage_system
aps_v_nap_volume
aps_v_nap_volume_cifs_nfs
aps_v_nap_volume_log
IBM XIV Array Views
aps_v_xiv_cluster
aps_v_xiv_component
aps_v_xiv_consistency_group
aps_v_xiv_fc_adaptor
aps_v_xiv_host_interface
aps_v_xiv_ip_interface
aps_v_xiv_mirror
aps_v_xiv_physical_disk
aps_v_xiv_storage_pool
aps_v_xiv_storage_system
aps_v_xiv_target
aps_v_xiv_target_connect
aps_v_xiv_volume
NetApp Cluster-Mode Database Views
aps_v_ntc_aggregate
aps_v_ntc_aggregate_log
aps_v_ntc_aggregate_relocate
aps_v_ntc_aggr_perform_log
aps_v_ntc_cache_policy
aps_v_ntc_cifs_perform_log
aps_v_ntc_cifs_server
aps_v_ntc_cifs_session
aps_v_ntc_cifs_share
aps_v_ntc_cluster_peer
aps_v_ntc_disk
aps_v_ntc_disk_path
aps_v_ntc_disk_path_mapping
aps_v_ntc_disk_perform_log
aps_v_ntc_export_policy
aps_v_ntc_export_rule
aps_v_ntc_extn_array_err
aps_v_ntc_extn_array_port
aps_v_ntc_extn_array_port_cn
aps_v_ntc_extn_array_port_st
aps_v_ntc_extn_array_profile
aps_v_ntc_fc_adapter
aps_v_ntc_fc_alias
aps_v_ntc_fc_interface
aps_v_ntc_flexcache
aps_v_ntc_host_info
aps_v_ntc_iscsi_interface
aps_v_ntc_license
aps_v_ntc_login_account
aps_v_ntc_login_role
aps_v_ntc_lun
aps_v_ntc_lun_log
aps_v_ntc_lun_perform_log
aps_v_ntc_map_vserver_aggr
aps_v_ntc_net_interface
aps_v_ntc_nfs_perform_log
aps_v_ntc_nfs_server
aps_v_ntc_node
aps_v_ntc_node_log
aps_v_ntc_option
aps_v_ntc_plex
aps_v_ntc_prc_node_perf_log
aps_v_ntc_processor_perf_log
aps_v_ntc_qtree
aps_v_ntc_quota
aps_v_ntc_quota_error
aps_v_ntc_quota_log
aps_v_ntc_quota_status
aps_v_ntc_quota_user
aps_v_ntc_raid_group
aps_v_ntc_raid_perf_log
aps_v_ntc_smb_perform_log
aps_v_ntc_snapshot
APS_V_NTC_snapshot_log
APS_V_NTC_snapshot_policy
APS_V_NTC_snapshot_schdcron
APS_V_ntc_snapshot_schdintvl
APS_V_NTC_snapshot_schedule
APS_V_NTC_storage_system
APS_V_NTC_storage_adapter
APS_V_NTC_system_prf_log
APS_V_NTC_trgt_prt_perform_log
APS_V_NTC_ucm_adapter
APS_V_NTC_Vendor
APS_V_NTC_VOLUME
APS_V_NTC_VOLUME_clone
APS_V_NTC_VOLUME_log
APS_V_NTC_VOLUME_move
APS_V_NTC_VOLUME_PERFORM_LOG
APS_V_NTC_Vserver
Oracle Container Database Views
apt_v_sol_zone
apt_v_sol_zone_dataset
apt_v_sol_zone_ip_address
File Analytics Database Views
apt_v_afa_bucket
apt_v_afa_capacity
apt_v_afa_category
apt_v_afa_collector_progress
apt_v_afa_context
apt_v_afa_data_growth
apt_v_afa_file_category
apt_v_afa_file_duplication
apt_v_afa_file_lifetime
apt_v_afa_file_size
apt_v_afa_file_summary
apt_v_afa_file_types
apt_v_afa_largest_files
apt_v_afa_owner_category
Virtualization Manager Database Views
apt_v_partition
apt_v_virtual_system
apt_v_vmw_cluster
apt_v_vmw_container
apt_v_vmw_datastore
apt_v_vmw_datastore_file
apt_v_vmw_datastore_usage
apt_v_vmw_extent
apt_v_vmw_hardware
apt_v_vmw_map_snapshot_file
apt_v_vmw_partition_profile
apt_v_vmw_partition_stats
apt_v_vmw_partition_stats_log
apt_v_vmw_perform_cpu_log
apt_v_vmw_perform_memory_log
apt_v_vmw_perform_disk_log
apt_v_vmw_physical_disk
apt_v_vmw_virtual_disk
apt_v_vmw_virtual_disk_log
apt_v_vmw_virtual_machine
apt_v_vmw_vm_datastore_usage
apt_v_vmw_vmfile
apt_v_vmw_vmfile_not_inventory
apt_v_vmw_vmguest_disk
apt_v_vmw_vmguest_disk_log
apt_v_vmw_vmsnapshot_log
apt_v_vmw_vmsnapshot_tree
Fabric Manager Database Views
aps_v_swi_alert_ind
aps_v_swi_blade
aps_v_swi_blade_slot
aps_v_swi_chassis
aps_v_swi_chassis_component
aps_v_swi_chassis_fan
aps_v_swi_chassis_power
aps_v_swi_chassis_temp_sensor
aps_v_swi_fabric
aps_v_swi_fc_port_stats
aps_v_swi_fc_port_trunk
aps_v_swi_life_cycle_ind
aps_v_swi_map_fab_physwitch
aps_v_swi_map_zalias_zmemb
aps_v_swi_map_zone_zonememb
aps_v_swi_node
aps_v_swi_node_fc_port
aps_v_swi_perform_daily_log
aps_v_swi_physical_switch
aps_v_swi_platform
aps_v_swi_port_module
aps_v_swi_product
aps_v_swi_protocol_end_point
aps_v_swi_san
aps_v_swi_switch
aps_v_swi_switch_fc_port
aps_v_swi_switch_fc_port_cap
aps_v_swi_switch_fc_port_set
aps_v_swi_switch_service_cap
aps_v_swi_switch_setting
aps_v_swi_switch_software
aps_v_swi_switchfc_port_rate
aps_v_swi_switfcportrate_log
aps_v_swi_topology
aps_v_swi_topology_view
aps_v_swi_zone
aps_v_swi_zone_member_alias
aps_v_swi_zone_membersetting
aps_v_swi_zoneset
aps_v_switch_attribute
Backup Manager Database Views
apt_v_agent_status
apt_v_client_file
apt_v_date_window
apt_v_gen_job
apt_v_job
apt_v_job_file
apt_v_job_message_log
apt_v_job_note
apt_v_skipped_backup_file
apt_v_tape_drive
apt_v_tape_drive_log
apt_v_tape_library
apt_v_tape_media
apt_v_job_tape_media
apt_v_last_client_job
apt_v_product_message
Detailed View Descriptions (Avamar)
apt_v_avm_activities
apt_v_avm_clients
apt_v_avm_datasets
apt_v_avm_event_catalog
apt_v_avm_dpn_statistics
apt_v_avm_dpn_statistics_log
apt_v_avm_event_catalog
apt_v_avm_events
apt_v_avm_gc_status
apt_v_avm_group_members
apt_v_avm_groups
apt_v_avm_node
apt_v_avm_node_log
apt_v_avm_node_space
apt_v_avm_node_util
apt_v_avm_partition
apt_v_avm_plugin_catalog
apt_v_avm_retention_policies
apt_v_avm_schedules
Detailed View Descriptions (Backup Exec)
apt_v_bue_job
Detailed View Descriptions (CommVault Simpana)
apt_v_cmv_backup_copy
apt_v_cmv_backup_policy
apt_v_cmv_backupset
apt_v_cmv_client
apt_v_cmv_dbinstance
apt_v_cmv_dedup_store
apt_v_cmv_disk_drive
apt_v_cmv_disk_library
apt_v_cmv_disk_media
apt_v_cmv_drivepool
apt_v_cmv_idataagent
apt_v_cmv_job
apt_v_cmv_job_disk_media
apt_v_cmv_job_optical_media
apt_v_cmv_job_tape_media
apt_v_cmv_optical_drive
apt_v_cmv_optical_library
apt_v_cmv_optical_media
apt_v_cmv_reason
apt_v_cmv_retention_period
apt_v_cmv_skipped_files
apt_v_cmv_storcopy_dedupstore
apt_v_cmv_storcopy_drvpools
apt_v_cmv_subclient
apt_v_cmv_tape_drive
apt_v_cmv_tape_library
apt_v_cmv_tape_media
Detailed View Descriptions (Data Domain)
apt_v_ddm_disk
apt_v_ddm_enclosure
apt_v_ddm_file_system
apt_v_ddm_logical_strg_unit
apt_v_ddm_system
apt_v_ddm_system_model
apt_v_ddm_system_replication
apt_v_ddm_system_snapshot
apt_v_ddm_tape
apt_v_ddm_tape_drive
apt_v_ddm_tape_pool
apt_v_ddm_virtual_tape_lib
Detailed View Descriptions (HP Data Protector)
apt_v_hpd_backup_schedule
apt_v_hpd_disk_drive
apt_v_hpd_job
apt_v_hpd_session_errclient
apt_v_hpd_session_tape_media
apt_v_hpd_tape_library
apt_v_hpd_tape_media
Detailed View Descriptions (NetWorker)
apt_v_leg_client_resource
apt_v_leg_cr_group
apt_v_leg_directive
apt_v_leg_disk_media
apt_v_leg_job
apt_v_leg_job_tape_media
apt_v_leg_period
apt_v_leg_saveset_group
apt_v_leg_schedule
apt_v_leg_tape_library
apt_v_leg_tape_media
Detailed View Descriptions (NetBackup)
apt_v_last_nbu_backup
apt_v_nbu_client_detail
apt_v_nbu_device_media_server
apt_v_nbu_dedup_job
apt_v_nbu_disk_pool
apt_v_nbu_disk_pool_strg_serve
apt_v_nbu_disk_volume
apt_v_nbu_duplication_job
apt_v_nbu_image_log
apt_v_nbu_job
apt_v_nbu_job_detail
apt_v_nbu_job_disk_media
apt_v_nbu_job_file
apt_v_nbu_job_tape_media
apt_v_nbu_job_try
apt_v_nbu_lifecycle_policy
apt_v_nbu_lifecycpolicy_dest
apt_v_nbu_media_server
apt_v_nbu_policy
apt_v_nbu_policy_client
apt_v_nbu_policy_client_aud
apt_v_nbu_policy_file
apt_v_nbu_policy_file_log
apt_v_nbu_policy_log
apt_v_nbu_related_job
apt_v_nbu_restore_backup_job
apt_v_nbu_schedule
apt_v_nbu_schedule_copy
apt_v_nbu_schedule_log
apt_v_nbu_slp_job
apt_v_nbu_storage_server
apt_v_nbu_storage_unit
apt_v_nbu_storage_unit_group
apt_v_nbu_strgunit_mediasrvr
apt_v_nbu_su_group_member
apt_v_nbu_tape_drive
apt_v_nbu_tape_library
apt_v_nbu_tape_media
apt_v_nbu_tape_media_detail
apt_v_nbu_volume_group
apt_v_nbu_volume_pool
Detailed View Descriptions (TSM)
apt_v_tsm_client_option
apt_v_tsm_client_association
apt_v_tsm_client_schedule
apt_v_tsm_copy_group
apt_v_tsm_database
apt_v_tsm_database_log
apt_v_tsm_disk_media
apt_v_tsm_device_class
apt_v_tsm_drive_media_log
apt_v_tsm_drive_srvrinst
apt_v_tsm_filespace
apt_v_tsm_fs_mgmt_class_usage
apt_v_tsm_job
apt_v_tsm_job_instance
apt_v_tsm_job_message
apt_v_tsm_management_class
apt_v_tsm_node
apt_v_tsm_occupancy_log
apt_v_tsm_policy_domain
apt_v_tsm_policy_set
apt_v_tsm_poll_date_audit
apt_v_tsm_poll_date_log
apt_v_tsm_process
apt_v_tsm_recovery_log
apt_v_tsm_recovery_aud
apt_v_tsm_restore_job
apt_v_tsm_scratch_tape_log
apt_v_tsm_session
apt_v_tsm_stgpool_contents
apt_v_tsm_storage_pool
apt_v_tsm_storage_pool_log
apt_v_tsm_tape_library
apt_v_tsm_tape_media
apt_v_tsm_volume_contents
wUser’s Guide
Detailed View Descriptions (TSM)