Script doesn't work since TSM V6.2 is used

[schuhb]

/* -----------------------------------------------------------------*/
/* Script Name: back_single */
/* Parameter: script <hours> <Nodename> */
/* Description: Displays nodes and their amount of files and MBs. */
/* -----------------------------------------------------------------*/
select Entity,Successful,Bytes/1024/1024 as "MBs",date(start_time)as "START Date",time(START_TIME) as "Time",Date(END_TIME) as "END DATE",time(end_time) as "Time",Examined,Affected,Failed from summary -
where activity in ('BACKUP','ARCHIVE') and cast((current_timestamp-start_time)hours as decimal(8,0)) < $1 and entity='$2' order by Entity



This showed me the backups of node ($2) in the last ($1) hours.
No it shows me ALL backups instead of the last $1 hours.
Any idea
Thx, Hannes

 

[cilesiz]

Hi schuhb,

try this :

select Entity,Successful,Bytes/1024/1024 as "MBs",date(start_time)as "START Date",time(START_TIME) as "Time",Date(END_TIME) as "END DATE",time(end_time) as "Time",Examined,Affected,Failed from summary where activity in ('BACKUP','ARCHIVE') and cast(hour(current_timestamp-start_time) as decimal(8,0)) < $1 and entity='$2' order by Entity

regards

Ugur

 

[schuhb]

Sorry, for the long delay....same outcome

 

[CoMaboy]

select -
entity, -
date(start_time) -
from -
summary -
where -
activity in ('BACKUP','ARCHIVE') -
and entity='$2' -
and start_time>current_timestamp-$1 hours