OpsCenter to IT Analytics Schema Mapping
The following table displays a mapping of each OpsCenter table with its equivalent IT Analytics table view. You can further click the OpsCenter table link to view the field mapping of each OpsCenter table.
To download a document with full details of the published IT Analytics views, see the Help for Database Views section in the IT Analytics User Guide. In addition, Copilot is the OpsCenter Custom SQL AI conversion agent available in Cohesity's SaaS offering. See Copilot available features section in the SaaS application help for more information.
Table: Equivalent views
OpsCenter Table | IT Analytics equivalent view(s) |
|---|---|
apt_v_nbu_policy, apt_v_server | |
apt_v_nbu_policy_client, apt_v_nbu_client_detail | |
apt_v_nbu_disk_pool | |
apt_v_nbu_disk_pool | |
apt_v_nbu_job, apt_v_server, apt_v_nbu_job | |
apt_v_nbu_host_alias, apt_v_server | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job, apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule, apt_v_nbu_storage_unit , apt_v_nbu_dedup_job | |
apt_v_nbu_job, apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule, apt_v_nbu_storage_unit , apt_v_nbu_dedup_job | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job_detail, apt_v_nbu_event_notification_log | |
apt_v_nbu_host_detail, apt_v_server | |
apt_v_server, apt_v_nbu_tape_media, apt_v_nbu_tape_library, apt_v_nbu_volume_group, apt_v_nbu_volume_pool | |
apt_v_server, apt_v_nbu_media_server | |
apt_v_nbu_job, apt_v_nbu_job_detail | |
apt_v_nbu_policy | |
apt_v_nbu_policy, apt_v_nbu_policy_client | |
apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job_detail, apt_v_nbu_schedule | |
apt_v_nbu_policy, apt_v_nbu_schedule | |
apt_v_nbu_job_detail, apt_v_skipped_backup_file | |
apt_v_nbu_tape_drive | |
apt_v_nbu_tape_drive | |
apt_v_nbu_tape_drive | |
apt_v_nbu_tape_library | |
apt_v_nbu_schedule.selection_type | |
lookup_CopyState | apt_v_nbu_slp_job.copy_state |
apt_v_nbu_job.vendor_state | |
apt_v_nbu_job.job_type | |
apt_v_nbu_schedule.day_of_week | |
apt_v_nbu_tape_media.vendor_media_type | |
lookup_DiskVolumeStatus | apt_v_nbu_disk_volume.status |
apt_v_nbu_tape_drive .drive_status_name | |
apt_v_nbu_tape_drive.vendor_drive_type | |
apt_v_nbu_job.vendor_state | |
apt_v_nbu_job.summary_status | |
apt_v_nbu_policy_client.policy_type | |
apt_v_nbu_job.job_type | |
apt_v_nbu_tape_media.vendor_media_status | |
apt_v_nbu_tape_meida.vendor_media_type | |
apt_v_nbu_policy.is_active | |
apt_v_nbu_policy_client.policy_type | |
apt_v_nbu_volume_pool.is_scratch_pool | |
apt_v_nbu_tape_library.library_type | |
lookup_ScheduleLevelType | apt_v_nbu_schedule.selection_type |
lookup_ScheduleType | apt_v_nbu_schedule.schedule_type |
lookup_SLPState | apt_v_nbu_slp_job.copy_state |
lookup_StorageServerState | apt_v_nbu_storage_server.state |
lookup_StorageServiceRetentionLevel | apt_v_nbu_lifecycpolicy_dest.retention_level |
lookup_StorageServiceRetentionType | apt_v_nbu_lifecycpolicy_dest.retention_type |
lookup_StorageServiceUsageType | apt_v_nbu_slp_job.copy_type |
lookup_StorageUnitType | apt_v_nbu_storage_unit.storage_unit_type |
apt_v_nbu_disk_pool, apt_v_nbu_storage_server | |
apt_v_nbu_disk_volume | |
apt_v_nbu_disk_volume_log | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule, apt_v_nbu_dedup_job | |
apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule, apt_v_nbu_dedup_job | |
apt_v_nbu_job_detail, apt_v_nbu_job_try | |
apt_v_nbu_job_try | |
apt_v_nbu_job_try | |
apt_v_nbu_job, apt_v_nbu_job_detail | |
apt_v_nbu_job, apt_v_nbu_job_detail | |
apt_v_nbu_job_detail, apt_v_nbu_job_file | |
apt_v_nbu_job_detail, apt_v_nbu_file | |
apt_v_nbu_job_detail | |
apt_v_nbu_job_detail | |
apt_v_nbu_policy | |
apt_v_nbu_tape_library | |
apt_v_nbu_storage_server | |
apt_v_nbu_lifecycle_policy, apt_v_nbu_lifecycpolicy_dest, apt_v_nbu_storage_unit | |
apt_v_nbu_lifecycle_policy | |
apt_v_storage_unit, apt_v_nbu_disk_pool, apt_v_strgunit_mediasrvr | |
apt_v_nbu_storage_unit_group | |
apt_v_storage_unit_group, apt_v_storage_unit | |
apt_v_nbu_tape_drive, apt_v_nbu_tape_media, apt_v_nbu_tape_library | |
apt_v_nbu_host_detail, apt_v_nbu_asset, apt_v_host_source_info | |
apt_v_nbu_volume, apt_v_nbu_volume_group | |
apt_v_nbu_volume_pool | |
apt_v_nbu_tape_drive, apt_v_nbu_tape_library, apt_v_server, apt_v_nbu_tape_media | |
apt_v_nbu_job | |
apt_v_nbu_job_detail | |
apt_v_tape_media | |
apt_v_nbu_policy | |
apt_v_server_instance |