Re: SQL date convert
2007-02-14 11:17:11
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.
|
|
|