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

George Huebschman
Storage Support Team, Media Librarian
Legg Mason, LMTS
410 580-7911 (office)
410 522-8581 (mobile)

Please plant a tree before printing this e-mail, and remember, E-Mail is
forever
...but Diamonds are a girl's best friend.



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jones, Eric J
Sent: Thursday, February 25, 2010 4:23 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Question on Expiration

Bill:
I can see a total on the TSM server for all the machines that have
objects to expire but cannot see for a particular machine.  Is there any
way to tell how many have expired on 1 machine since we are backing up
dozens of machines.  I see each machine listed but it just shows what
it's expiring, not the amount of space.

Thanks

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.