Re: filespace reporting question

2001-12-12 Thread Steve Harris
8 fax > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Joseph Dawes > Sent: Wednesday, December 12, 2001 10:19 AM > To: [EMAIL PROTECTED] > Subject: filespace reporting question > > > Does anyone know how to use a select stat

Re: filespace reporting question

2001-12-12 Thread Seay, Paul
looks like you could do almost anything. -Original Message- From: Joseph Dawes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:19 AM To: [EMAIL PROTECTED] Subject: filespace reporting question Does anyone know how to use a select statement like the following but instead of ha

Re: filespace reporting question

2001-12-12 Thread Seay, Paul
ECTED]] Sent: Wednesday, December 12, 2001 10:19 AM To: [EMAIL PROTECTED] Subject: filespace reporting question Does anyone know how to use a select statement like the following but instead of having it report on days have it report on hours? i.e. from now -3 hours and less than 15 days.

Re: filespace reporting question

2001-12-12 Thread Mr. Lindsay Morris
-8478 fax > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Joseph Dawes > Sent: Wednesday, December 12, 2001 10:19 AM > To: [EMAIL PROTECTED] > Subject: filespace reporting question > > > Does anyone know how to use a sel

filespace reporting question

2001-12-12 Thread Joseph Dawes
Does anyone know how to use a select statement like the following but instead of having it report on days have it report on hours? i.e. from now -3 hours and less than 15 days. select filespace_name as "Filespace", node_name as "Node", days(current_date)-days(backup_end) as