Description
It returns data protection (Backup, Snap and Archive) jobs ended in the given time range.
Active jobs that were running in the given time range are also included.
Jobs of Virtual Server Agent are shown for each VMs.
Usage:
qoperation execscript -sn QS_DataProtectionJobSummary [-si @FromTime = ''] [-si @ToTime = ''] [-si @LastNDays = '1'] [-si @IncludeAged = '1'] [-si @IncludeRunning = '1'] [-si @BackupType = ''] [-si @OrderBy = 'JobID'] [-si @IncludeCommandLine = '0'] [-si @IncludeOneTouch = '0']
Example:
qoperation execscript -sn QS_DataProtectionJobSummary -si '2013-09-01' -si '2013/09/30 23:59:59'
qoperation execscript -sn QS_DataProtectionJobSummary -si @LastNDays = '7'
Parameters:
1. Time range can be specified by either FromTime and ToTime or by LastNDays. Default is last 1 day.
FromTime and ToTime should be in 'mm/dd/yyyy hh:mm:ss' or 'yyyy-mm-dd hh:mm:ss' format.
2. Default is IncludeAged = 1 for including aged jobs.
3. Default is IncludeRunning = 1 for including jobs that are running but not completed in the given time range.
4. BackupType can be 'Full' or 'Incr'. Default is '' for all backup types.
5. OrderBy can be 'JobID', 'Client' or 'Agent'. Default is descending order of JobID.
6. Both IncludeCommandLine & IncludeOneTouch default to 'No' (0) for compatibility with previous versions of this command.
Columns:
Client - Client computer name
Agent - Data agent type name
Instance - Instance name
Backupset - Backupset name
Subclient - Subclient name
Job Id - Data Protection job ID
Job Status - Running, Completed, Failed or Completed with warnings etc.
VM - Virtual Machine name
VM Status - Completed, Failed or Completed with warnings etc.
VM Failure Reason - VM Failure Reason
Operation - Backup, Synthetic Full, Snap Backup etc.
Job Type - Full, Incremental or Differential etc.
Scan Type - Classic, Change Journal, Mixed or Optimized Scan
Start Date - Job start date (mm/dd/yyyy)
Start Time - Job start time (hh:mm:ss)
End Date - Job end date (mm/dd/yyyy)
End Time - Job end time (hh:mm:ss)
Application Size (GB) - Protected application data size in GB
Compression Rate (%) - Software compression rate in percentage
Data Transferred (GB) - Data transferred over network in GB
Data Written (GB) - Data written on media in GB
Space Saving (%) - Space saving due to compression and deduplication
Data Size Change (%) - Change of application size in percentage
Transfer Time - Data transfer time in hh:mm:ss
Throughput (GB/Hour) - Data transfer throughput in GB/Hour
Protected Objects - Number of Protected files and folders
Failed Objects - Number of files not protected
Failed Folders - Number of folders not protected
Failure Code - Failure code in form of xx:xxx
Storage Policy - Storage Policy name
Client Group - Names of client groups associated by the client
Usage
qoperation execscript -sn QS_DataProtectionJobSummary [-si @FromTime = ''] [-si @ToTime = ''] [-si @LastNDays = '1'] [-si @IncludeAged = '1'] [-si @IncludeRunning = '1'] [-si @BackupType = ''] [-si @OrderBy = 'JobID'] [-si @IncludeCommandLine = '0'] [-si @IncludeOneTouch = '0']
Example:
qoperation execscript -sn QS_DataProtectionJobSummary -si '2013-09-01' -si '2013/09/30 23:59:59'
qoperation execscript -sn QS_DataProtectionJobSummary -si @LastNDays = '7'
Parameters:
1. Time range can be specified by either FromTime and ToTime or by LastNDays. Default is last 1 day.
FromTime and ToTime should be in 'mm/dd/yyyy hh:mm:ss' or 'yyyy-mm-dd hh:mm:ss' format.
2. Default is IncludeAged = 1 for including aged jobs.
3. Default is IncludeRunning = 1 for including jobs that are running but not completed in the given time range.
4. BackupType can be 'Full' or 'Incr'. Default is '' for all backup types.
5. OrderBy can be 'JobID', 'Client' or 'Agent'. Default is descending order of JobID.
6. Both Include CommandLine & Include 1-Touch default to 'No' (0) for compatibility with previous versions of this command.
Output:
1. It returns data protection (Backup, Snap and Archive) jobs ended in the given time range.
2. Active jobs that were running in the given time range are also included.
3. Jobs of Virtual Server Agent are shown for each VMs.
Details
- Platform: CommServe (Database: CommServ)
- Release: 11.0.0
Disclaimer of Warranties
CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.