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" <adrie.vantuyl AT oranjewoud DOT nl> on 02/26/2003 
09:14:07 AM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu
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
postmaster AT oranjewoud DOT nl
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.
**********************************************************************