Query the occupancy of the node Query the filespaces of the node (active data is space occupied) occupancy less space occupied will be the inactive data This will give you an easy if not 100% answer.
"Tuyl Adrie, A.C. van" <[EMAIL PROTECTED]> on 02/26/2003 09:14:07 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: John Naylor/HAV/SSE) Subject: statistics about active and inactive data Hi, Is there a safe way of displaying the amount of active data and inactive data of a node? In the BACKUPS table the state of an abject is stored, but not the size of the object. Besides that I don't think a (joined) select on the BACKUPS table is a good idea considering the amount of data in this table. Anyone an idea? Thanks, Adrie **************************************************************************** This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify [EMAIL PROTECTED] This footnote also confirms that this e-mail message has been checked by McAfee Groupshield for the presence of computer viruses. **************************************************************************** ********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **********************************************************************