Try searching the ADSM-L archives for terms like "current_timestamp". Here is one entry that might be helpful:
http://adsm.org/lists/html/ADSM-L/2005-01/msg00511.html Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 02/14/2007 06:04:52 AM: > 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.
