TSM Select Statement Backup data last hour

Andimotz80

ADSM.ORG Member
Joined
Oct 20, 2008
Messages
34
Reaction score
0
Points
0
PREDATAR Control23

Hello,

I need a select statement, which show me the summary of the backup data in the last hour. I want to add this to the monitoring to know the capacity during the day.

Thanks,

Andreas
 
PREDATAR Control23

Here you go:

select cast(float(sum(bytes))/1024/1024/1024 as decimal(8,2)) from summary as s,nodes as n where s.activity='BACKUP' and (s.entity=n.node_name) and start_time>current_timestamp-1 hours

Result will be in GiB.

Run this outside of the TSM server in CRON or Windows scheduler every hour, on the hour to create a logging file.
 
PREDATAR Control23

Hello,

thanks for your answer. I think I have written to less information:

I want to monitor via nagios and to know at which time the most backup data are collected.

Do you know which select I can use?

BR

Andreas
 
PREDATAR Control23

No idea about how nagios works.

The select statement I posted should be generic enough to run on any monitoring environment. You just have to kick it off every hour.
 
Top