Thanks everyone. Got exactly what I wanted.
1 other question is, is there a way to tell how many objects were added to the
DB a day/week by server.
Thanks
Eric
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT vm.marist DOT edu] On Behalf Of
Huebschman, George J.
Sent: Thursday, February 25, 2010 5:07 PM
To: ADSM-L AT vm.marist DOT edu
Subject: [ADSM-L] FW: [ADSM-L] Question on Expiration
Eric,
That only shows and object count, not bytes.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Huebschman, George J.
Sent: Thursday, February 25, 2010 5:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Question on Expiration
Eric,
Try this:
select nodename, substr (message, 1,9) as MESSAGE, cast(substr (message,
44,10)as char (20)) as ObjExpired from actlog where msgno=4970 and
date(date_time)>date(current_timestamp)-1 day
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive or action-oriented messages to us via
electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|