ADSM-L

SQL select statement to find volumes for each client

2002-08-07 09:12:58
Subject: SQL select statement to find volumes for each client
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 7 Aug 2002 07:29:49 -0400
Hi!

I don't know much about SQL select statements and I was wondering if anyone
would happen to know a command that would find out the volumes that belong
to that client, how many total and the percent utilized of the tape?  I'm
trying to get an idea of how many tapes I will need when I convert from
3590 magstars to 9840's or LTO.  Thanks in advance!!!!

Joni Moyer
Associate Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338

<Prev in Thread] Current Thread [Next in Thread>