Total size of backed up data for one domain 1

[Trana]

Probably a simple question for you guys.

I have 4 policy domains and about 30 servers being backed up.

How can I get the total size for 1 entire policy domain with all its servers, including all versions of the files, databases and Exchange.

Thank you.

 

[ProbablyDown]

Hmm you can try something like this maybe:

select node_name,cast(float(sum(physical_mb))/1024 as decimal(14,2)) as TOTAL_GB from occupancy where node_name in (select node_name from nodes where domain_name='YOUR-DOMAIN')group by node_name

Then copy the the data to a spreadsheet and sum the TOTAL_GB column?

 

[Trana]

Thanks mate, still a bit new with actually administering the TSM server, didn't realize I could just use SQL.

Thanks!

 

[ProbablyDown]

no worries.. but keep in mind that you can't use all the fancy sql (like joins etc...) so if you do a comparison query be prepared to wait.. hehe..

 

[ProbablyDown]

Oh.. here.. this site is pretty helpful for TSM stuff..

http://www.lascon.co.uk/d005000.htm