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

Last Published:
Product(s): NetBackup IT Analytics (11.7)
  1. OpsCenter Transition
    1.  
      Introduction
    2.  
      IT Analytics reports search
    3.  
      OpsCenter - Reports Library mapping
    4.  
      OpsCenter - IT Analytics alerts mapping
    5.  
      Importing SQL Report Template Designer (RTD) Reports
    6. OpsCenter to IT Analytics Schema Mapping
      1.  
        domain_Client
      2.  
        domain_ClientImageCollectionLevel
      3.  
        domain_DiskPool
      4.  
        domain_DiskPoolHistory
      5.  
        domain_Entity
      6.  
        domain_EntityAlias
      7.  
        domain_Image
      8.  
        domain_ImageCopy
      9.  
        domain_ImageCopyFormat
      10.  
        domain_ImageFragment
      11.  
        domain_Job
      12.  
        domain_JobArchive
      13.  
        domain_JobImage
      14.  
        domain_Log
      15.  
        domain_MasterServer
      16.  
        domain_Media
      17.  
        domain_Mediaserver
      18.  
        domain_ParentJob
      19.  
        domain_Policy
      20.  
        domain_PolicyClient
      21.  
        domain_Schedule
      22.  
        domain_ScheduleCalendar
      23.  
        domain_ScheduledJob
      24.  
        domain_ScheduleWindow
      25.  
        domain_SkippedFileArchive
      26.  
        domain_TapeDrive
      27.  
        domain_TapeDriveHistory
      28.  
        domain_TapeDriveMap
      29.  
        domain_TapeLibrary
      30.  
        lookup_CalendarType
      31.  
        lookup_DataCollectionStatus
      32.  
        lookup_DataMoverType
      33.  
        lookup_DayOfWeek
      34.  
        lookup_DensityType
      35.  
        lookup_DriveStatus
      36.  
        lookup_DriveType
      37.  
        lookup_JobState
      38.  
        lookup_JobStatus
      39.  
        lookup_JobSubType
      40.  
        lookup_JobType
      41.  
        lookup_MediaStatus
      42.  
        lookup_MediaType
      43.  
        lookup_PolicyStatus
      44.  
        lookup_PolicyType
      45.  
        lookup_PoolType
      46.  
        lookup_robottype
      47.  
        nb_DiskPool
      48.  
        nb_DiskVolume
      49.  
        nb_DiskVolumeHistory
      50.  
        nb_Job
      51.  
        nb_JobArchive
      52.  
        nb_JobAttempt
      53.  
        nb_JobAttemptArchive
      54.  
        nb_JobAttemptLog
      55.  
        nb_JobBackupAttributes
      56.  
        nb_JobBackupAttributesArchive
      57.  
        nb_JobFiles
      58.  
        nb_JobFilesArchive
      59.  
        nb_JobProcessAttribute
      60.  
        nb_JobProcessAttributeArchive
      61.  
        nb_Policy
      62.  
        nb_Robot
      63.  
        nb_StorageServer
      64.  
        nb_StorageServiceDestInfo
      65.  
        nb_StorageServiceInfo
      66.  
        nb_StorageUnit
      67.  
        nb_StorageUnitGroup
      68.  
        nb_StorageUnitsInGroup
      69.  
        nb_TapeDrive
      70.  
        nb_VirtualMachines
      71.  
        nb_VolumeGroup
      72.  
        nb_VolumePool
      73.  
        nom_Drive
      74.  
        nom_NBJob
      75.  
        nom_NBJobClient
      76.  
        nom_NBMedia
      77.  
        nom_NBPolicy
      78.  
        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)

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