Bill, The statements work, but the filesizes are reported wrong. For instance I backupped a file from my PC to the (AIX) TSM Server and it said that the size is 20184, but when I do a DIR on the file on my PC it reports the size as 19456.
Could you think of a reason for this behaviour? Richard. -----Original Message----- From: Bill Mansfield [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 4:22 AM To: [EMAIL PROTECTED] Subject: Re: Filesize from client through server select filespace_name,filename,file_size from contents where node_name='YOURNODE' Or you can query the backups table to get different data: select filespace_name,hl_name,ll_name,backup_date from backups where node_name='YOURNODE' _____________________________ William Mansfield Senior Consultant Solution Technology, Inc "Denzel, Richard van" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 03/15/2002 07:43 AM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Filesize from client through server Hi All, I would like to be able to retrieve the filesize etc. for the backupped files for a client through the TSM server (dsmadmc). I know this is possible through the client. But for automation sake it's in my opion better to let the server generate such listings. Is there anyone who knows if this can be done on the TSM server-side? Thanx in advance, Richard. ------------------------------------------------- Richard van Denzel High Availability & Storage Solutions Senior Technical Consultant Infrastructure Consulting & Integration [EMAIL PROTECTED] Getronics Infrastructure Solutions Wiltonstraat 42 Postbus 1005 3900 BA Veenendaal tel.: 0318 - 567 100 fax: 0318 - 567 633 mobiel: 06 - 212 78 569 Building Futures on <<http://www.getronics.com/>>
