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 ([EMAIL PROTECTED]) Senior consultant ________________________________
From: ADSM: Dist Stor Manager on behalf of Ronald Le Large Sent: Wed 2/14/2007 7:04 AM To: [email protected] 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.
