Important Update: Cohesity Products Documentation
All Cohesity product documentation are now managed via the Cohesity Docs Portal: https://docs.cohesity.com/HomePage/Content/home.htm. Some documentation available here may not reflect the latest information or may no longer be accessible.
IT Analytics OpsCenter Transition Reference
- OpsCenter Transition
- Introduction
- IT Analytics reports search
- OpsCenter - Reports Library mapping
- OpsCenter - IT Analytics alerts mapping
- Importing SQL Report Template Designer (RTD) Reports
- OpsCenter to IT Analytics Schema Mapping
- domain_Client
- domain_ClientImageCollectionLevel
- domain_DiskPool
- domain_DiskPoolHistory
- domain_Entity
- domain_EntityAlias
- domain_Image
- domain_ImageCopy
- domain_ImageCopyFormat
- domain_ImageFragment
- domain_Job
- domain_JobArchive
- domain_JobImage
- domain_Log
- domain_MasterServer
- domain_Media
- domain_Mediaserver
- domain_ParentJob
- domain_Policy
- domain_PolicyClient
- domain_Schedule
- domain_ScheduleCalendar
- domain_ScheduledJob
- domain_ScheduleWindow
- domain_SkippedFileArchive
- domain_TapeDrive
- domain_TapeDriveHistory
- domain_TapeDriveMap
- domain_TapeLibrary
- lookup_CalendarType
- lookup_DataCollectionStatus
- lookup_DataMoverType
- lookup_DayOfWeek
- lookup_DensityType
- lookup_DriveStatus
- lookup_DriveType
- lookup_JobState
- lookup_JobStatus
- lookup_JobSubType
- lookup_JobType
- lookup_MediaStatus
- lookup_MediaType
- lookup_PolicyStatus
- lookup_PolicyType
- lookup_PoolType
- lookup_robottype
- nb_DiskPool
- nb_DiskVolume
- nb_DiskVolumeHistory
- nb_Job
- nb_JobArchive
- nb_JobAttempt
- nb_JobAttemptArchive
- nb_JobAttemptLog
- nb_JobBackupAttributes
- nb_JobBackupAttributesArchive
- nb_JobFiles
- nb_JobFilesArchive
- nb_JobProcessAttribute
- nb_JobProcessAttributeArchive
- nb_Policy
- nb_Robot
- nb_StorageServer
- nb_StorageServiceDestInfo
- nb_StorageServiceInfo
- nb_StorageUnit
- nb_StorageUnitGroup
- nb_StorageUnitsInGroup
- nb_TapeDrive
- nb_VirtualMachines
- nb_VolumeGroup
- nb_VolumePool
- nom_Drive
- nom_NBJob
- nom_NBJobClient
- nom_NBMedia
- nom_NBPolicy
- nom_Server
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 |