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
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
Try this:
SELECT ENTITY AS NODE_NAME, ACTIVITY, BYTES AS BYTES_TRANSFERRED, -
START_TIME, END_TIME, IDLE AS IDLE_IN_SEC, MEDIAW AS
MEDDIA_WAIT_IN_SEC, -
PROCESSES, AFFECTED AS FILES_BACKUP, FAILED, EXAMINED AS ALL -
FROM SUMMARY -
WHERE START_TIME>TIMESTAMP(CURRENT
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)
select sum(bytes)/1000/1000 as "MB_per_day" from summary where
activity='BACKUP' and (current_timestamp-end_time)hours <= 24 hours
However, this only looks at backup traffic. You may want to look at archive
traffic as well.
John G. Talafous IS Technical Principal
The Timken Company
