Re: SQL script

2004-10-05 Thread Richard Sims
On Oct 5, 2004, at 12:20 PM, Fredrik Karlsson wrote: Hi! Does anyone have a script to calculate the size of all active data? Preferably sorted by node. Kind Regards Fredrik Karlsson Fredrik - By definition, Active files are what is currently present in the file system, which after a curre

SQL script

2004-10-05 Thread Fredrik Karlsson
Hi! Does anyone have a script to calculate the size of all active data? Preferably sorted by node. Kind Regards Fredrik Karlsson

Re: SQL script for total traffic

2003-10-12 Thread Wira Chinwong
You may download/install operational reporting program and use it to guide about the good SQL statements. -Original Message- From: Gable, Josh [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 9:20 PM To: [EMAIL PROTECTED] Subject:Re: SQL script for total

Re: SQL script for total traffic

2003-10-09 Thread Hector Chan
ENT DATE -1 DAY, '12:00:00') AND BYTES>0 /hector -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Gable, Josh Sent: October 8, 2003 9:27 AM To: [EMAIL PROTECTED] Subject: SQL script for total traffic Hello TSMers, Does anyone have a g

Re: SQL script for total traffic

2003-10-09 Thread Gable, Josh
I'll check it out and see what I can come up with. Thanks for all the responses. Josh -Original Message- From: Talafous, John G. [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:39 PM To: [EMAIL PROTECTED] Subject: Re: SQL script for total traffic select sum(bytes)

Re: SQL script for total traffic

2003-10-08 Thread Talafous, John G.
le, Josh [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 9:27 AM To: [EMAIL PROTECTED] Subject: SQL script for total traffic Hello TSMers, Does anyone have a good SQL query to determine the total amount of data you've backed up in the last 24 hours? It would need to capture all

SQL script for total traffic

2003-10-08 Thread Gable, Josh
Hello TSMers, Does anyone have a good SQL query to determine the total amount of data you've backed up in the last 24 hours? It would need to capture all data received, since we have backups that go to disk and tape concurrently. Thanks in advance for any assistance, Josh Gable EDS Enterprise S

SQL Script

2002-10-17 Thread Pétur Eyþórsson
Hi TSM Friends. I am looking for a SQL Script, that a client of mine wants. He wanst to be able to see on what volume a spesific file is. and secondly he wants to be able to see on what volume(s) a filespace is on. has anyone a script like that. I know this script will be realy heavy in

Re: TSM SQL Script

2002-03-21 Thread robert
Hi, you can try this one... Checks volumes of a NODE_NAME per storage pool Primairy and Copy. /* ---*/ /* Script Name: Q_NODE_VOL*/ /* Description: Query node for volumes*/ /* occupancy */ /*

Re: TSM SQL Script

2002-03-20 Thread Coats, Jack
[EMAIL PROTECTED] > Subject: Re: TSM SQL Script > > Jack - I think you should just remove the whole 'group by' clause. > You are not selecting a column function such has count(*) or avg(column). > > Unless you have a very small database or a very fast machine, >

Re: TSM SQL Script

2002-03-20 Thread William F. Colwell
Jack - I think you should just remove the whole 'group by' clause. You are not selecting a column function such has count(*) or avg(column). Unless you have a very small database or a very fast machine, this query will run a long time. Hope this helps, Bill At 12:10 PM 3/20/2002 -0600, you wro

TSM SQL Script

2002-03-20 Thread Coats, Jack
Yep, I am an SQL newbie, but some help would be nice. The script at the bottom terminates with this message: ANR2938E The column 'VOLUME_NAME' is not allowed in this context; it must either be named in the GROUP BY clause or be nested within an aggregate function. and points to the left(volume_n