Thx Wanda, this is a great script, really appreciate your time/effort Regards Louw Pretorius _______________________________ Informasie Tegnologie Stellenbosch Universiteit There are only 10 kinds of people in the world: Those who understand binary and those who don't
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Friday, July 15, 2005 21:03 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select to see total Size by Policy Domain This is probably the best you can do: select domain_name, sum(occ.backup_mb)/1024 as BACKUP_GB, sum(occ.archive_mb)/1024 - as ARCHIVE_GB from nodes n, auditocc occ where n.node_name=occ.node_name group by domain_name TSM isn't good at telling you "space used", because most people have tape drives that compress the data. What TSM records in occupancy and auditoccupancy is the amount of data that comes in to it from the client. If a client is doing compression, TSM records the amount it receives, which is less than if the client didn't compress the data first. If the clients don't do compression, TSM records that it receives larger amounts of data. Then it sends the data out to tape and the tape drive compresses the data anyway, so the amount TSM tells you the client is using is a lot less than the amount of media you need. If you have a mixture of clients compressing and not compressing, it's real hard to get any numbers that are useful, except your RELATIVE numbers from one month to the next are useful; at least you can tell which domain/client is growing the fastest! Wanda Prather "I/O, I/O, It's all about I/O" -(me) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pretorius Louw <[EMAIL PROTECTED]> Sent: Friday, July 15, 2005 5:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Select to see total Size by Policy Domain Importance: High Is there a way of seeing total space used by Policy Domain? Okay I know there's a way cause its TSM, but alas i do not know it. Regards Louw Pretorius _______________________________ Informasie Tegnologie Stellenbosch Universiteit There is only 10 kinds of people in the world: Those who understand binary and those who don't
