scalereport_backups_restores_errors_perdrive.sql: This script lists the drives which were used in the last twenty four hours along with the name of the Library in which it is present and total backups, restores etc. happened in the last one and twenty four hours.

Steps to execute

QOperation execscript -sn scalereport_backups_restores_errors_perdrive.sql


This script outputs


Column Name 		Description

--------------------------------------------------------------------------------------------

Library			Name of the Library in which the drive is present

Drive			Name of the drive whose statistics are displayed next.

#Bkps (1hour)		Total number of backups which were taken on the drive in the last 1 hour.

#Bkps (24hours)		Total number of backups which were taken on the drive in the last 24 hours.

#Rsts (1hour)		Total number of restores in the last one hour.

#Rsts (24hours)		Total number of restores in the last twenty four hours.

#Errs (1hour)		Total number of errors (Soft and Hard) in last one hour.

#Errs (24hours)		Total number of errors (Soft and Hard) in last 24 hours.