total space utilized on tsm server for reporting

[vivek.saini]

for reporting need to take out total space utilized in data backup on tsm server.

 

[marclant]

Try this query:

Select sum(reporting_mb)/1024 AS Total_Managed_GB from occupancy where STGPOOL_NAME in (select distinct STGPOOL_NAME FROM stgpools where POOLTYPE='PRIMARY') and NODE_NAME !=''

 

[Hiten]

But if i need to know total occupancy from the TSM server for month lets say for 30 days then what could be the query? Kindly guide.