Thanks for this. Interesting way of attacking it :)
Matt.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Johnson, Milton
Sent: Tuesday, August 31, 2004 10:19 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
You can create a script
-- ---
COPYPOOL >=50
TAPEPOOL >=50
H. Milton Johnson
Voice: (210) 677-6728
-Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Beha
EMAIL PROTECTED] Behalf Of
Prather, Wanda
Sent: Tuesday, August 31, 2004 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL
[mailto:[EMAIL PROTECTED] Behalf Of
Prather, Wanda
Sent: Tuesday, August 31, 2004 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL Select statement help
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:
I hope I'm wrong, but I don't think it's possible to do that.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Warren, Matthew (Retail)
Sent: Tuesday, August 31, 2004 10:51 AM
To: [EMAIL PROTECTED]
Subject: SQL Select statement help
Hallo ([I]T/AD)SM'ers
Can any wise and clever SQL types help with the following?;
I am trying to get TSM to show the number of tapes that went pending by
date.
I can get this;
ANS8000I Server command: 'select cast(pending_date as char(10)),count(*)
from volumes where status='PENDING' group by p
