try
select sum (total_mb) as "total MB" from adsm.auditocc
make sure and run an "audit lic" daily to update teh auditocc table...
Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave. Suit 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109
-----Original Message-----
From: P�tur Ey��rsson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:28 AM
To: [EMAIL PROTECTED]
Subject: TOTAL Data on the Backup System
Hi can anyone give me a Select statemnt witch gives the output of all the
total data on the TSM Backup System.
Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer
[EMAIL PROTECTED]
Nyherji Hf Simi TEL: +354-569-7700
Borgartun 37 105 Iceland
URL: http://www.nyherji.is
