Loading...

DataProtectionJobSummary

Scope

Intended Audience
All X
CommVault Internal  
CE/System Test  
Development  

Platform

  • CommServer (Database: CommServ)

Release

  • 11.0.0

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']
     
  • 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.



    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']
     
  • 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.



    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.


    Version

  • 1.1.88.1
     
  • 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.