There is a much easier way to do this. 
 
Assuming you've got TSM accounting turned on at the server, look for the 
dsmaccnt.log (c:\program files\tivoli\tsm\server1 on a Windows box, 
/usr/tivoli/tsm/server/bin on an AIX box). This is a comma-delimited file 
broken down by date, time, and node name, and contains all client activity 
(including bytes transferred).
 
If you import the file to an Excel spreadsheet, look at column Q.
 
--
Mark Stapleton (mark.s AT evolvingsol DOT com)
Senior consultant
 
________________________________

From: ADSM: Dist Stor Manager on behalf of Ronald Le Large
Sent: Wed 2/14/2007 7:04 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL date convert



Hi everybody,
  
  The last time when I posted a question I received a few very useful and quick 
replies. Thx for that. Hopefully this question is also easy for a few of you to 
answer.
  
  Case:
  A client want's to know how big the daily backup is for a Lotus client 
backedp up via TDP.
  I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a script 
but the output is useless (even with grep) because TDP reports a summary for 
every *.nfs its backing up and I am only interested in the total bytes 
transferred. (which is also reported with msg 4991 at the end of the log).
  The alternative (which has my preference ) is an sql query:
  select START_TIME,ACTIVITY,ENTITY from summary where ENTITY='[nodename]' and 
ACTIVITY='BACKUP'
  but I struggle with the date.
  The format TSM is using in its table is
  2007-01-15 21:08:34.000000
  I am only interested in the backupsize of last night so I use " 
START_TIME='2007-02-14%' but that is obviously not the correct syntax.
  Does anyone of you know how I must convert the date ? Or is there a  
possibility to use something like "today-1" like you use with a q actlog.
  
  Your advise would be highly appreciated.
  Thx in advance,
  Abulifia

               
---------------------------------
 New Yahoo! Mail is the ultimate force in competitive emailing. Find out more 
at the Yahoo! Mail Championships. Plus: play games and win prizes.