Available CommCell Views

The following view options are available in the CommCell.

Table of Contents

CommCellAdminSchedule

The CommCellAdminSchedule view provides information about scheduled administrative jobs.

Column Description
scheduleid The unique schedule ID.
scheduletask The type of scheduled task (administration).
schedtype The type of schedule (e.g., disaster recovery, data aging, auxiliary copy, reports, etc.).
sp_id The unique storage policy ID.
sp The storage policy name.
sp_dest_copy_id The unique ID for the destination copy.
sp_dest_copy The destination copy.
sp_src_copy_id The unique ID for the source copy.
sp_src_copy The source copy.
streams The number of streams used.
schedpattern The scheduling pattern (One Time, Daily, Weekly, Monthly or Yearly).
schedinterval The schedule occurrences based on the schedule pattern.
schedday The scheduled day based on the schedule pattern.
schedtime The scheduled start time.
schednexttime The next scheduled time.

CommCellAuxCopyInfo

The CommCellAuxCopyInfo view provides information about auxiliary copy jobs.

Column Description
auxcopyjobid The Job ID of the auxiliary copy job.
storagepolicy The name of the storage policy that was used to perform the auxiliary copy job.
sourcecopyid The unique ID for the source copy.
sourcecopy The storage policy copy that data was copied from during the auxiliary copy job.
destcopyid The unique ID for the destination copy.
destcopy The storage policy copy that data was written to during the auxiliary copy job.
jobinitfrom Where the operation was initiated.
jobstatus The result of the auxiliary copy job, either Success, Killed, Failed, or Failed to Start.
startdateunixsec The start date and time of the auxiliary copy job. This time represents the number of seconds that have elapsed since 1970.
enddateunixsec The end time of the auxiliary copy job. This time represents the number of seconds that have elapsed since 1970.
startdate The start date and time of the auxiliary coy job.
enddate The end date and time of the auxiliary copy job.
bytesxferred The amount of data (in bytes) that was written to media during the auxiliary copy job.

CommCellBackupInfo

The CommCellBackupInfo view provides information about the backup jobs. Jobs do not appear for subclients that have no assigned storage policy.

Column Description
jobid The unique Job ID of the backup job.
appid The unique subclient ID.
jobinitfrom Where the operation was initiated.
clientname The client computer name.
idataagent The agent name.
instance The name of the instance that conducted the backup job. If the instance option is not applicable for an iDataAgent, the information is displayed as NULL.
backupset The backup set name.
subclient The subclient name.
data_sp The storage policy name.
backuplevelint The backup level initialization
backuplevel The backup type that was selected. Backup types can be Full, Incremental, Differential or Synthetic Full.
incrlevel The incremental levels for Informix and Oracle backup jobs.
jobstatusint The job status initialization.
jobstatus The status of the job. Job status can be Success, Killed, Failed, or Failed to Start.
jobfailedreason The reason the backup job failed.
startdateunixsec The UNIX start date and time of the backup job. This time represents the number of seconds that have elapsed since 1970.
enddateunixsec The UNIX date and end time of the backup job. This time represents the number of seconds that have elapsed since 1970.
startdate The start date and time of the backup job.
enddate The end date and time of the backup job.
durationunixsec The duration of UNIX seconds
duration The length of time for the backup operation to complete.
numstreams The number of data channels used by the storage policy to perform the backup.
numbytesuncomp The amount of uncompressed data.
numbytescomp The amount of compressed data.
numobjects The number of objects that were backed up for the associated job.
isaged The IS aged
isagedstr The IS aged string
xmlJobOptions All of the settings configured for the backup job in XML format.
retentionDays The number of days that data from the backup job will be retained.
systemStateBackup Indicates whether the job is a system state backup. Yes is 1 and No is 0.
inPrimaryCopy Indicates whether the backup job is included in the primary copy for a storage policy.
failedobjects The number of failed objects in the backup job.
totalBackupSize The total size of the backup job.
encrypted Indicates if data in the backup job is encrypted by displaying Yes, No, or Unavailable.

CommCellBkSchedule

The CommCellBkSchedule view provides information about the scheduled backup jobs.

Column Description
commcellid The unique CommCell software ID.
commcellname The CommCell computer name.
scheduleid The unique schedule ID.
schedulename The scheduled name.
scheduletask The scheduled task (backup).
schedbackuptype The scheduled backup type (Full, Incremental, Differential, or Synthetic Full).
schedpattern The scheduling pattern (One Time, Daily, Weekly, Monthly or Yearly).
schedinterval The schedule occurrences based on the schedule pattern.
schedbackupday The schedule day based on the schedule pattern.
schedbackuptime The scheduled start time.
schednextbackuptime The next scheduled time.
appid The unique subclient ID.
clientname The client computer name.
idataagent The iDataAgent name.
instance The instance name.
backupset The backupset name.
subclient The subclient name.

CommCellBkScheduleSummary

The CommCellBkScheduleSummary view provides information about each schedule policy.

Column Description
commcellid The unique CommCell software ID.
commcellname The CommCell name.
scheduleid The unique schedule ID.
schedulePolicy The name of the schedule policy and whether it was created by the user or the system.
scheduleName The name of the schedule.
scheduleTask The scheduled task (backup).
schedbackuptype The scheduled backup type (Full, Incremental, Differential, or Synthetic Full).
schedpattern The scheduling pattern (One Time, Daily, Weekly, Monthly or Yearly).
schedinterval The schedule occurrences based on the schedule pattern.
schedbackupday The schedule day based on the schedule pattern.
schedbackuptime The scheduled start time.
schednextbackuptime The next scheduled time.
associationCount The number of associations that were picked for the schedule policy.
JobsToRun The number of jobs that are configured to run for the schedule.
JobsFiredInLastRun The total number of jobs that ran during the last schedule. A difference between this value and the JobsToRun value might indicate a problem with the schedule.
lastScheduleFiretime The last time the schedule ran.
mismatchedAppTypeCount The number of associations in the schedule policy that do not match the agent type. A mismatched association occurs when a user upgrades from one application version to another, but does not update the association.
TimeZoneId The unique ID for the time zone that the schedule is configured to use.
TimeZoneName The name of the time zone that is used to display times. For example, CS TimeZone, is used for the CommServe computer's local time zone.
TimeZoneOffSet The number of hours between the configured time zone and the UTC time zone in seconds.

CommCellBKupSizeInfo

The CommCellBKupSizeInfo view provides information about the backup size.

Column Description
jobid The unique Job ID of the backup job.
appid The unique subclient ID.
client The client computer.
idataagent The iDataAgent name.
instance The instance name.
backupset The backup set name.
subclient The subclient name.
data_sp The storage policy name.
backup_type The type of backup.
last_bkp_appsize_without_index The last backup size of data without index.
lastbkp_indexsize The size of index in last backup.
lastbkp_totbkpsize the total backup size of the last backup.
lastbkp_percentagechange The change in percentage of the last backup when compared to backup of similar type before the last backup.
iscommpresstion the IS compressed data or not.

CommCellClientConfig

The CommCellClientConfig view provides information about the client configuration.

Column Description
clientid The unique client ID.
clientname The client computer name.
networkinterface The default network interface through which the client communicates and transfers data to and from MediaAgent(s).
os [osrelease | osvendor] The client computer operating system, the version of the operating system and vendor.
processor [hwvendor] The processor platform that runs the client computer and vendor.
galaxyrelease The version of the software component installed on the computer
clientstatus The status of the client (installed or uninstalled).
clientbkenable The activity of the backup operations at the client level. The activity displays Yes if enabled and No if disabled.
clientrstenable The activity of the restore operations at the client level. The activity displays Yes if enabled and No if disabled.

CommCellClientFSFilters

The CommCellClientFSFilters view provides information about the filters that are configured for a client.

Column Description
commcellid The unique CommCell software ID.
commcellname The CommCell name.
appid The unique subclient ID.
clientname The client computer name.
idataagent The iDataAgent name.
backupset The backupset name.
subclient The subclient name.
subclientstatus The status of the subclient.
content The subclient content.
global_exclude_filter The directories and folders to be excluded from the backup operation for the subclient.
exclude_dirs/files/patterns The directories, files, or file patterns to be excluded from the backup operation for the subclient.
except_dirs/files/patterns_to_exclude The directories, files, or file patterns to be included in the backup operation for the subclient.
Backup_System_State Indicates whether system state information is included in the subclient backup content.

CommCellClientLevelBkpJobSummary

The CommCellClientLevelBkpJobsSummary view provides a summary of information about backup jobs that ran at the client level over the last 30 days.

Column Description
ClientID The unique client ID.
ClientName The client computer name.
TotalJobs Total number of jobs that ran on a client over the last 30 days.
Completed Number of jobs completed.
CompletedWithErrors Number of jobs completed with errors.
Killed Number of jobs killed
Failed Number of jobs failed
NoRun Number of jobs which failed for activity disabled or maximum instance running etc.
Dropped Number of jobs failed to start.
Other Number of jobs completed or failed or killed etc.
SchedInitiated Number of Schedule Task initiated.
TotalFullAppSizeGB Total uncompressed backup size in GB for full backup jobs.
TotalIncAppSizeGB Total uncompressed backup size in GB for incremental backup jobs.
TotalOtherAppSizeGB Total uncompressed backup size in GB for differential or synthetic backup jobs.
TotalAppSizeGB Total of all backup jobs run - full/incremental/differential/synthetic jobs.
TotalFullBkpSizeGB The total size of the full backup.
TotalIncBkpSizeGB The total size of the incremental backup.
TotalOtherBkpSizeGB The total size of the differential/synthetic backup.
TotalBkpSizeGB The total size of the backup job.
ProtectedObjects Total number of files backed up.
FailedObjects Total number of files failed to scan or backup etc.
FailedFolders Total number of folders failed to scan/backup etc.
StartTime The time of the backup job started.
EndTime The time of the backup job ended.

CommCellCompletedBkpJobsInfo

The CommCellCompletedBkpJobsInfo view provides information about client level backup jobs.

Column Description
ClientID The unique client ID.
ClientName The client computer name.
TotalBkpJobs Number of backup jobs ran on a client computer.
TotalFullBkpJobs Number of Full backup jobs ran on a client computer.
TotalIncBkpJobs Number of Incremental backup jobs ran on a client computer.
TotalOtherBkpJobs Number of Other backup jobs ran on a client computer.
TotalBkpSizeGb The total size of the backup.
TotalFullBkpSizeGB The total size of the full backup.
TotalIncBkpSizeGB The total size of the incremental backup.
TotalOtherBkpSizeGB The total size of the other backup.

CommCellDriveInfo

The CommCellDriveInfo view provides information about drives.

Column Description
maname The MediaAgent name.
libname The library name
drivename The drive name
drivealiasname The alternative name assigned to the drive.
drivebroken  The drive broken status
cleaning reqd The drive cleaning requirement
drivestatus The drive status
driveofflinereason The reason drive is offline
offlinetimestamp The drive offline time stamp.

CommCellJobController

The CommCellJobController view provides information about active jobs.

Column Description
jobid The unique ID of the job.
operation The type of operation.
clientComputer The name of the client computer.
agentType The agent that is performing the operation. (e.g. Windows 2000 File System)
subclient The subclient that was protected during the operation.
jobType The type of operation that is being conducted on data.
phase The current phase of the operation. The number of phases varies depending on the operation.
storagePolicy The storage policy to which the operation is being directed.
mediaAgent The MediaAgent to which the operation is being directed.
status The status of the operation.
progress A status bar indicating progress. The progress bad is not visible for certain operations or for initial phases of some data protection operations.
errors Displays any errors that have occurred during the operation.
delayReason The description of the reason why the operation may be pending, waiting, or failing.
description A brief description of the running job.
scheduleId The unique ID for the job schedule.
instanceName The name of the instance where the job runs.

CommCellJobControllerCount

The CommCellJobControllerCount view provides information about active jobs.

Column Description
commcellid The unique CommCell software ID.
jobtype The type of operation.
numofpending The number of jobs pending.
numofwaiting The number of jobs waiting.
numofstopped The number of jobs stopped.
numofqueued The number of jobs queued.
numofrunning The number of jobs running.

CommCellLibraryInfo

The CommCellLibraryInfo view provides information about library name and status details.

Column Description
libname The name of the library.
libaliasname The alternative name assigned to the library.
libstatus The status of the the library.
libbroken yes or no.
libstatusreason The status reason of library.
offlinetimestamp The offline timestamp of the library management.

CommCellLibraryReservInfo

The CommCellLibraryReservInfo view provides information about active jobs and their respective media and drive reservation details.

Column Description
jobId [reservId | OP] The job reserving the resource, its unique reservation ID number, and operation (e.g., backup, restore).
MA [status] The name of the associated MediaAgent and its status.
libAlias [libName | libStatus | barcodeReaderPresent] The alternative name assigned the library, the library name, its status (e.g., online) and if there is a barcode reader.
driveAlias
[driveName | driveStatus]
The alternative name assigned the drive in the library, the actual drive name and its status (e.g., online).
driveMountStatus [numMount| numBackup | numRestore] The number of mounts, backups, and restores for the drive.
barcode | type The barcode reader and its type.
elapsed The elapsed time of the reservation.

CommCellLicense

The CommCellLicense view provides information about the licenses consumed in the CommCell.

Column Description
licenseid Unique ID for the license.
license Name of the license.
permanentLicenseUsed Number of permanent licenses that are consumed for this license.
evaluationLicenseUsed Number of evaluation licenses that are consumed for this license
clientGroup Client group that is associated with the license.
client Name of the client computer that consumed the license.
installTime Time when the license was installed.
expiryTime Time when the license will expire.
OSName Name of the operating system installed on the computer where the license is consumed.

CommCellMediaAgentInfo

The CommCellMediaAgentInfo view provides information media- related information for each client.

Column Description
maname The MediaAgent name.
mastatus The MediaAgent status.
offlinereason The reason MediaAgent is Offline.
offlinetimestamp The time MediaAgent was offline.

CommCellMediaInDrives

The CommCellMediaInDrives view provides a summary of the media currently available in each drive.

Column Description
libraryname The name of the associated library.
drivename The name of the drive associated with the media.
mediaagent The name of the associated MediaAgent.
driveoccupied Indicates the number of media occupying the associated drive.
mountstatus Indicates the number of mounts.
barcode The barcode reader.
mediaattributes The attributes associated with the media.
sparegroupname Indicates the name of the associated spare group.
storagepolicyname The name of the associated storage policy.
copyname The name of the associated copy.
retentioninfo Information on retention for the associated media.
runningjobs Information on running jobs.

CommCellMediaInfo

The CommCellMediaInfo view provides a summary of media-related information.

Column Description
mediaid The unique ID generated when the media was discovered.
mediabarcode The barcode label of the media.
mediagroupid The unique ID for the media group.
type The hardware type of the media.
format The recording format on the media.
sidename The unique ID generated for each side of the media.
mediaCreationTime The data and time at which the media was discovered.
volumeid The unique volume ID for the media.
volumename The volume name.
blocksizeKB The size measured in bytes of each block in the media.
totalspaceMB The total amount of space available in the media.
usedspaceMB The amount of used space in the media.
freespaceMB The amount of free space available in the media.
writenum The number of times data has been written to the media.
reusenum The number of times the media has been re-used.
mediastatus The status of the media. Media status can be Good, Expired, Bad, or Invalid.
volumestatus The current status of the volume. Volume status can be Active, Full, Idle, Read Only or Bad.
volumefullreason | volumefulljobid The reason the volume is full and job marking it as full.
location The location of the media.
  • If the media is inside the library, indicates whether the media is available in a storage slot or a drive.
  • If the media is exported, indicates the outside storage location recorded by the user, when the media was exported.
slotname The slot number in which the media resides.
drivename The drive name.
exportlocation The outside storage location of the exported media recorded by the user when the media was exported.
lastwritetimeunixsec The most recent time at which data was protected on the media. This time represents the number of seconds that have elapsed since 1970.
rawlastwritetime (not adjusted with daylight saving) The most recent time at which data was protected on the media, not adjusted for daylight savings time.
lastwritetime The most recent date and time at which data was protected on the media.
drivepoolname The drive pool name.
library The library name.
storagepolicy The storage policy name.
storagepolicycopy The storage policy copy name.
retentiondays The number of days data is kept before it is pruned.
fullcycles The number of cycles data is kept before it is pruned.
LabelErrors The number of labeling errors that a media has encountered.
ReadWriteErrors The number of read, write errors that a media has encountered.

CommCellMediaRetentionInfo

The CommCellMediaRetentionInfo view provides a summary of retention info for media.

Column Description
MediaId The unique ID generated when the media was discovered.
BarCode The barcode label of the media.
LibraryName The library name.
ScratchPool The associated spare group of the Media
IsAssignedMedia Indicates if the media is Assigned Media or not
MediaType The hardware type of the media
MediaStatus The status of the media. Media status can be Good, Expired, Bad, or Invalid.
MediaLocation (ExportLocation) The location of the media.
  • If the media is inside the library, the column displays the location as "In Library".
  • If the media is exported, the column displays the outside storage location recorded by the user, when the media was exported.
StoragePolicy The storage policy name.
StoragePolicyCcopy The storage policy copy name.
RetentionDate(Retention Type) The date when the media will age, and if the date is calculated by Basic Retention or Extended Retention. (Updated as per the last data aging job run)
BasicRetentionDays The number of days data is kept before it is pruned (Basic Retention)
BasicRetentionCycles The number of cycles data is kept before it is pruned (Basic Retention)

CommCellOracleBackupInfo

The CommCellOracleBackupInfo view provides a summary of the Oracle backup jobs.

Column Description
jobId The unique ID of the backup job.
appId The Oracle application ID ("22").
jobinitfrom The job initiation.
clientname The name of the client used in the backup.
idataagent The iDataAgent used for the backup ("Oracle").
instance The instance name used in the backup.
backupset The backupset name.
backuplevelInt The backup level initialization.
backuplevel The backup type that was selected. Backup types can be Full, Incremental, Differential or Synthetic Full.
incrlevel The storage policy copy name.
jobstatusInt The job status in numerical form.
jobstatus The status of the job (Success, Killed, Failed, or Failed to Start).
jobfailedreason If the job failed, this is the reason it did.
startdateunixsec The UNIX start date and time of the backup job. This time represents the number of seconds that have elapsed since 1970.
startdate The date the job started.
enddate The date the job ended.
durationunixsec The job duration in Unix seconds. This time represents the number of seconds that have elapsed since 1970.
duration The job duration.
numstreams The number of streams used for the job.
numbytesuncomp The number of bytes that were backed up without being compressed.
numobjects The number of database objects that were backed up.
isAged The IS aged.
isAgedStr The IS aged string.
xmljobOptioins The configured options for the backup job in XML format,
retentiondays The number of retention days.
systemStateBackup Indicates if system state was backed up during the operation.
nextSCN The next System Change Number (SCN) for the backup.
CopyName The name of the storage policy copy.
CopyPrecedence The copy storage policy precedence.

CommCellPrePostCmdInfo

The CommCellPrePostCmdInfo view provides information about the backup jobs.

Column Description
client The client computer name.
appType The application name.
backupset The backupset name.
instance The instance name.
subclientName The subclient name.
preScanCommand The pre scan process command.
postScanCommand The post scan process command.
preBkpCommand The pre backup process command.
postBkpCommand The post backup process command.
userName The user name used to run the command.

CommCellRestoreInfo

The CommCellRestoreInfo view provides information about the restore jobs.

Column Description
jobid The unique job ID of the restore job.
destclientname The name of the client to which the data was recovered.
idataagent The name of the iDataAgent that conducted the restore job.
instance The instance name.
backupset The backupset name.
jobstatus The status of the job (Success, Killed, Failed, or Failed to Start).
jobfailedreason The reason the restore job failed.
starttimeunixsec The UNIX start date and time of the restore job. This time represents the number of seconds that have elapsed since 1970.
endtimeunixsec The UNIX end date and time of the restore job. This time represents the number of seconds that have elapsed since 1970.
starttime The date and time at which the restore job was started.
endtime The date and time when the restore job was completed.
durationunixsec The UNIX length of time for the restore operation to complete. This time represents the number of seconds that have elapsed since 1970.
duration The length of time for the restore operation to complete.
numfiles The number of files that were recovered.
numbytescomp The amount of data (in compressed bytes) that was recovered.
numbytesuncomp The amount of data (in uncompressed bytes) that was recovered.
xmlJobOptions The options that are configured for the restore job in XML format.
UserName The login name for the user who started the restore job.
ScheduleName The name of the schedule if a schedule started the restore job. If a schedule did not start the restore job, then this column is empty.

CommCellRetentionInfo

The CommCellRetentioInfo view provides information about each Retention information.

Column Description
commcellid The unique CommCell software ID.
commcellname The CommCell computer name.
spname The storage policy name.
copyname The storage policy copy name.
retentiondays The number of retention days.
cycles The number of cycles.
Isdataagingenabled The Is data aging enabled on this copy.
Ismanageddiskspaceenabled The disk space Is managed disk space enabled.

CommCellStoragePolicy

The CommCellStoragePolicy view provides information about each storage policy.

Column Description
storagepolicy The storage policy name.
defaultcopy The name of the default storage policy copy associated with the storage policy.
hardwarecompress The hardware compression status. The status displays Yes if enabled and No if disabled.
maxstreams The maximum number of data streams established for the storage policy.
drivepool The name of the drivepool associated with the library to which the backup data from the default copy is directed.
library The library name.
appid The unique subclient ID.
clientname The client computer name.
idataagent The iDataAgent name.
instance The name of the instance associated with the storage policy. If the instance option is not applicable for an iDataAgent, the information is displayed as NULL.
backupset The backupset name.
subclient The subclient name.

CommCellSubClientConfig

The CommCellSubClientConfig view provides information about subclient configuration.

Column Description
appid The unique subclient ID.
clientid The unique client ID.
clientname The client computer name.
idataagent The iDataAgent name.
idataagentstatus The status of the iDataAgent (installed or uninstalled).
idagentbkenable The activity of the backup operations at the iDataAgent level. The activity displays Yes if enabled and No if disabled.
idagentrstenable The activity of the restore operations at the iDataAgent level. The activity displays Yes if enabled and No if disabled.
instance The name of the instance. If the instance option is not applicable for an iDataAgent, the information is displayed as NULL.
backupset The backupset name.
subclient The subclient name.
subclientstatus The status of the subclient (Valid or Deleted).
schedjobpattern The backup scheduling pattern (One Time, Daily, Weekly, Monthly or Yearly).
schedbackupday The backup scheduled start day.
schedbackuptime The backup scheduled start time.
schednextbackuptime The backup next scheduled time.
data_sp The storage policy name.
data_sp_copy The storage policy copy name.
data_sp_copy_retendays The number of days data is kept before it is pruned.
data_sp_copy_fullcycles The number of cycles data is kept before it is pruned.
data_sp_schedauxcopypattern The scheduling pattern for the auxiliary copy operation.
data_sp_schedauxcopyday The auxiliary copy scheduled day based on the schedule pattern.
data_sp_schedauxcopytime The scheduled start time.
data_sp_schednextauxcopytime The next scheduled time.
data_sp_scheddestcopy The secondary copy.
log_sp The storage policy associated with the database transaction logs.
LastFullBkpSize(Bytes) The size of the last full backup.
LastIncBkpSize(Bytes) The size of the last incremental backup.
LastDiffBkpSize(Bytes) The size of the last differential backup.

CommCellUpdateInfo

The CommCellUpdateInfo view provides information about the updates installed for each component in the CommCell.

Column Description
clientid The unique client ID.
client [idataagent] The client and components on which the updates are installed in the CommCell.
galaxyrelease The version of the software component installed on the computer.
installedSP The latest service pack and latest post service pack updates installed for each component in the CommCell.
installedAdditionalPatch[latest] After service pack installation, the current, additional update installed post service pack for each component in the CommCell.
missingPatch After service pack installation, the service pack updates for each component that are missing (uninstalled, or not selected during the service pack installation).