[ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

Subject:	[ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA
From:	"Lee, Gary" <glee AT BSU DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Fri, 22 Apr 2016 13:51:20 +0000

Just got a request for the amount of active versus inactive data on our tsm 
servers.

Is there a better way than traversing the backups table and summing?
That would be a mighty long query.

We have three servers, and approximately 300 clients about 200 tB total data.

Thanks for any suggestions.

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Lee, Gary <= Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Skylar Thompson Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Lee, Gary Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Schneider, Jim Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Skylar Thompson Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Schneider, Jim Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Maurice van 't Loo Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Zoltan Forray Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Skylar Thompson Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA, Roger Deschner