I have made two select commands: one is for the count of the missed backup schedules in the month and the other the count of successful backup in the month.
1. select count(message) "Missed Client Backup This Month" from actlog where originator='SERVER' and message LIKE'ANR2578W%' and year(current_timestamp)=year(date_time) and month(current_timestamp)=month(date_time)
2. select count(message) "Total Successful Clients Backups This Month" from actlog where originator='SERVER' and message LIKE'ANR2507I%' and year(current_timestamp)=year(date_time) and month(current_timestamp)=month(date_time)
Is there a way for TSM to hold both values from 2 select commands (say A from first select command and B from 2nd select command) then run the operations of (B-A)/B to get the successful backup ratio result for the month?
Thank you for any idea.
1. select count(message) "Missed Client Backup This Month" from actlog where originator='SERVER' and message LIKE'ANR2578W%' and year(current_timestamp)=year(date_time) and month(current_timestamp)=month(date_time)
2. select count(message) "Total Successful Clients Backups This Month" from actlog where originator='SERVER' and message LIKE'ANR2507I%' and year(current_timestamp)=year(date_time) and month(current_timestamp)=month(date_time)
Is there a way for TSM to hold both values from 2 select commands (say A from first select command and B from 2nd select command) then run the operations of (B-A)/B to get the successful backup ratio result for the month?
Thank you for any idea.