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)
domain_Client	apt_v_nbu_policy, apt_v_server
domain_ClientImageCollectionLevel	apt_v_nbu_policy_client, apt_v_nbu_client_detail
domain_DiskPool	apt_v_nbu_disk_pool
domain_DiskPoolHistory	apt_v_nbu_disk_pool
domain_Entity	apt_v_nbu_job, apt_v_server, apt_v_nbu_job
domain_EntityAlias	apt_v_nbu_host_alias, apt_v_server
domain_Image	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule
domain_ImageCopy	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule
domain_ImageCopyFormat	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule
domain_ImageFragment	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule
domain_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
domain_JobArchive	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
domain_JobImage	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule
domain_Log	apt_v_nbu_job_detail, apt_v_nbu_event_notification_log
domain_MasterServer	apt_v_nbu_host_detail, apt_v_server
domain_Media	apt_v_server, apt_v_nbu_tape_media, apt_v_nbu_tape_library, apt_v_nbu_volume_group, apt_v_nbu_volume_pool
domain_Mediaserver	apt_v_server, apt_v_nbu_media_server
domain_ParentJob	apt_v_nbu_job, apt_v_nbu_job_detail
domain_Policy	apt_v_nbu_policy
domain_PolicyClient	apt_v_nbu_policy, apt_v_nbu_policy_client
domain_Schedule	apt_v_nbu_policy, apt_v_nbu_schedule
domain_ScheduleCalendar	apt_v_nbu_policy, apt_v_nbu_schedule
domain_ScheduledJob	apt_v_nbu_job_detail, apt_v_nbu_schedule
domain_ScheduleWindow	apt_v_nbu_policy, apt_v_nbu_schedule
domain_SkippedFileArchive	apt_v_nbu_job_detail, apt_v_skipped_backup_file
domain_TapeDrive	apt_v_nbu_tape_drive
domain_TapeDriveHistory	apt_v_nbu_tape_drive
domain_TapeDriveMap	apt_v_nbu_tape_drive
domain_TapeLibrary	apt_v_nbu_tape_library
lookup_CalendarType	apt_v_nbu_schedule.selection_type
lookup_CopyState	apt_v_nbu_slp_job.copy_state
lookup_DataCollectionStatus	apt_v_nbu_job.vendor_state
lookup_DataMoverType	apt_v_nbu_job.job_type
lookup_DayOfWeek	apt_v_nbu_schedule.day_of_week
lookup_DensityType	apt_v_nbu_tape_media.vendor_media_type
lookup_DiskVolumeStatus	apt_v_nbu_disk_volume.status
lookup_DriveStatus	apt_v_nbu_tape_drive .drive_status_name
lookup_DriveType	apt_v_nbu_tape_drive.vendor_drive_type
lookup_JobState	apt_v_nbu_job.vendor_state
lookup_JobStatus	apt_v_nbu_job.summary_status
lookup_JobSubType	apt_v_nbu_policy_client.policy_type
lookup_JobType	apt_v_nbu_job.job_type
lookup_MediaStatus	apt_v_nbu_tape_media.vendor_media_status
lookup_MediaType	apt_v_nbu_tape_meida.vendor_media_type
lookup_PolicyStatus	apt_v_nbu_policy.is_active
lookup_PolicyType	apt_v_nbu_policy_client.policy_type
lookup_PoolType	apt_v_nbu_volume_pool.is_scratch_pool
lookup_robottype	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
nb_DiskPool	apt_v_nbu_disk_pool, apt_v_nbu_storage_server
nb_DiskVolume	apt_v_nbu_disk_volume
nb_DiskVolumeHistory	apt_v_nbu_disk_volume_log
nb_Job	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule, apt_v_nbu_dedup_job
nb_JobArchive	apt_v_nbu_job_detail, apt_v_nbu_policy, apt_v_nbu_schedule, apt_v_nbu_dedup_job
nb_JobAttempt	apt_v_nbu_job_detail, apt_v_nbu_job_try
nb_JobAttemptArchive	apt_v_nbu_job_try
nb_JobAttemptLog	apt_v_nbu_job_try
nb_JobBackupAttributes	apt_v_nbu_job, apt_v_nbu_job_detail
nb_JobBackupAttributesArchive	apt_v_nbu_job, apt_v_nbu_job_detail
nb_JobFiles	apt_v_nbu_job_detail, apt_v_nbu_job_file
nb_JobFilesArchive	apt_v_nbu_job_detail, apt_v_nbu_file
nb_JobProcessAttribute	apt_v_nbu_job_detail
nb_JobProcessAttributeArchive	apt_v_nbu_job_detail
nb_Policy	apt_v_nbu_policy
nb_Robot	apt_v_nbu_tape_library
nb_StorageServer	apt_v_nbu_storage_server
nb_StorageServiceDestInfo	apt_v_nbu_lifecycle_policy, apt_v_nbu_lifecycpolicy_dest, apt_v_nbu_storage_unit
nb_StorageServiceInfo	apt_v_nbu_lifecycle_policy
nb_StorageUnit	apt_v_storage_unit, apt_v_nbu_disk_pool, apt_v_strgunit_mediasrvr
nb_StorageUnitGroup	apt_v_nbu_storage_unit_group
nb_StorageUnitsInGroup	apt_v_storage_unit_group, apt_v_storage_unit
nb_TapeDrive	apt_v_nbu_tape_drive, apt_v_nbu_tape_media, apt_v_nbu_tape_library
nb_VirtualMachines	apt_v_nbu_host_detail, apt_v_nbu_asset, apt_v_host_source_info
nb_VolumeGroup	apt_v_nbu_volume, apt_v_nbu_volume_group
nb_VolumePool	apt_v_nbu_volume_pool
nom_Drive	apt_v_nbu_tape_drive, apt_v_nbu_tape_library, apt_v_server, apt_v_nbu_tape_media
nom_NBJob	apt_v_nbu_job
nom_NBJobClient	apt_v_nbu_job_detail
nom_NBMedia	apt_v_tape_media
nom_NBPolicy	apt_v_nbu_policy
nom_Server	apt_v_server_instance

OpsCenter to IT Analytics Schema Mapping

Feedback

Feedback