Marc,
select entity as node_name,bytes as Bytes_transfered,successful from summary
where start_time>=timestamp(current_date -1 day,'20:00:00') and
end_time<=timestamp(current_date,'05:00:00')
I use "days(current_date)-days(end_time)<=1" to report previous 24 hours
activity counted by end_time.
Phillip
-----Original Message-----
From: Marc Levitan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 9:34 PM
To: [EMAIL PROTECTED]
Subject: Re: Select Statement
Hi Phillip,
I like the output of this.
I do have a question.
Can you explain, days(current_date)-days(end_time)<=1
My backups start at 20:00 and end at 05:00 the next day. How can I capture
just this?
Thanks,
Marc
"Guan, Phillip"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
ATE.VA.US> cc:
Sent by: "ADSM: Subject: Re: Select Statement
Dist Stor
Manager"
<[EMAIL PROTECTED]
ST.EDU>
09/25/2001
01:53 PM
Please respond
to "ADSM: Dist
Stor Manager"
Hi Marc,
A sample:
select start_time,end_time,activity ,entity ,bytes as
Bytes_transfered,successful as Successful from summary where
days(current_date)-days(end_time)<=1 order by entity
Phillip
-----Original Message-----
From: Marc Levitan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 1:00 PM
To: [EMAIL PROTECTED]
Subject: Select Statement
I am looking for a script that will list the clients that backed up and how
much data was backed up for the previous night and if they were successful.
This is what I have:
select ENTITY as Node_Name, BYTES as Bytes_Transferred, SUCCESSFUL from
summary where activity='BACKUP' and start_time>='2001-09-23
00:00:00.000000' and bytes>0 order by entity
The problem is that I have to change the Day/Time stamp before I run it.
Is there a way to put a variable like today-1? I have tried but am not
successful.
Does anyone have a better script?
Marc Levitan
Storage Manager
PFPC Global Fund Services
