I have been asked to come up with a report to show the occupancy by node & by 
retention time.

Region

Site

TSM Server

Hostname/
NodeName

Total Occupancy all Retention Schedules (MB)

Capacity by retention < 12 Months

Capacity by retention
> 12 Months < 24 Months

Capacity retention
36 Months

Capacity Retention
48 Months

Capacity Retention
60 Months

Capacity Retention
72 Months

Capacity Retention
84 Months

Capacity Retention
96 Months

Capacity Retention
108 Months

Capacity Retention
120 Months

Capacity Retention
>120 Months

Capacity Retention
No Expiry


The part I really can't figure out is how would I identify or break out the 
occupancy by retention.....

Has anyone done this before?



Thanks,
Bruce Kamp
Source One Technical
Providing services for Novartis Backup & Recovery
T +18175687331
bruce.kamp AT novartis DOT com<mailto:bruce.kamp AT novartis DOT com>

US Fort  Worth (USFW)
7001 Calmont Ave.
Fort Worth, TX  76244
USA