Turn accounting on and look for dsmaccnt.log in the same directory as the TSM 
server executable.
 
The bonus is that it's ready to drop into a spreadsheet.
 
--
Mark Stapleton (stapleton AT berbee DOT com)

        -----Original Message----- 
        From: Blodgett, Olin [mailto:Olin.Blodgett AT FLHOSP DOT ORG] 
        Sent: Tue 1/13/2004 12:54 
        To: ADSM-L AT VM.MARIST DOT EDU 
        Cc: 
        Subject: tsm select statement help2
        
        

        I have been banging my head againist the wall for monthes now because I
        can't get the stats from the TSM server on how the client nodes have 
done
        each night.
        
        Each night, every node writes the following chunk of code to the 
schedule
        log:
        
        Total number of objects inspected:  802,019
        Total number of objects backed up:   43,021
        Total number of objects updated:          0
        Total number of objects rebound:          0
        Total number of objects deleted:          0
        Total number of objects expired:        119
        Total number of objects failed:           1
        Total number of bytes transferred:     3.02 GB
        Data transfer time:                  145.02 sec
        Network data transfer rate:        21,870.55 KB/sec
        Aggregate data transfer rate:        392.97 KB/sec
        Objects compressed by:                    0%
        Elapsed processing time:           02:14:30
        
        Does this info get saved to the TSM Server? and if so what query works 
to
        get that info?
        I have tried several queries looking at most of the tables on the TSM
        server. I am looking for
        the total inspected, total backed up, and bytes transfered on a daily 
basis.
        Can someone PLEASE!!! help.
        
        
        Olin Blodgett
        
        
        The information contained in this message may be privileged and/or
        confidential and protected from disclosure.  If the reader of this 
message
        is not the intended recipient or agent responsible for delivering this
        message to the intended recipient, you are hereby notified that any
        dissemination, distribution or copying of this communication is strictly
        prohibited.  If you have received this communication in error, please 
notify
        the sender immediately by replying to this message and deleting the 
material
        from any computer.