Total volume of backed-up files per TSM-server ?

obiwan2

ADSM.ORG Member
Joined
Dec 8, 2005
Messages
184
Reaction score
0
Points
0
Location
Cologne / Germany
Website
Visit site
PREDATAR Control23

Hi TSM-Pro's !!

I have special questions to get 2 kinds of reports.....

1) How many data is (or was) backed-up (in GB/TB) per day and per TSM-Server ?

2) The second: How many files are stored in the primary-pool (ONLY the active versions) and what is the total volume (in GB/TB) ? This summary also per TSM-Server...

Maybe someone can help me as fast as possible ?

Very bad, that there is no "library" for (normal and special) TSM SQL-Queries :)

Many thanks for any help !!!
 
PREDATAR Control23

1) select sum(cast(bytes/1024/1024/1024 as decimal(9,2))) from summary where activity in ('BACKUP','ARCHIVE')and date(start_time)>=current_date -1 days

2) total data backed up for all nodes in a tsm server in TB
select sum(PHYSICAL_MB)/1024/1024 from OCCUPANCY

>How many files are stored in the primary-pool with no of objects:
select char(stgpool_name,30) as stgpool,cast(sum(physical_mb)/1024/1024 as decimal(10,1)) as Physical_GB ,cast(sum(logical_mb)/1024/1024 as decimal(10,1))as logical_gb,sum(num_files) as objects from occupancy group by stgpool_name order by 1

> You can get SQL queries here " http://thobias.org/tsm/index.html "
 
Top