•  Introduction to Database Views
  • About Database Views
  • Accessing Database Views
•  Introduction
  • 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 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_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_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
  • 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_prtotocol_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_snapmirror_error
  • aps_v_nap_snapmirror_schd
  • aps_v_nap_snapmirror_status
  • aps_v_nap_snapshot
  • aps_v_nap_snapshot_log
  • aps_v_nap_snapshot_schedule
  • aps_v_nap_snapvault_config
  • aps_v_nap_snapvault_error
  • aps_v_nap_snapvault_pri_schd
  • aps_v_nap_snapvault_sec_schd
  • aps_v_nap_snapvault_status
  • 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
•  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)