BackTrack had a problem with expiring it's own data.
Here are some scripts that we used to find more info
about the particular files. Hope this will help you.
Mark Adams
(402) 963-8237
/* This will show all files for a particular node */
select * from contents where node_name='SQL_BACKTRACK'
/* This script is designed to pull the files */
/* for SQL_BACKTRACK node given a certain month */
/* for the year 2000 */
select filespace_name, hl_name, -
ll_name from backups where -
node_name='SQL_BACKTRACK' and -
substr(varchar(backup_date),1,7)='2000-$1'
/* This script is designed to pull the files */
/* for SQL_BACKTRACK node given a certain month */
/* for the year 1999 */
select node_name, filespace_name, hl_name, -
ll_name, backup_date from backups where -
node_name='SQL_BACKTRACK' and -
substr(varchar(backup_date),1,7)='1999-$1' -
order by backup_date
/* This script obtains all nodes and their */
/* total amount of occupancy */
select node_name "NODE", type, sum(num_files) -
"# FILES", sum(physical_mb) "PHY(MB)", -
sum(logical_mb) "LOG(MB)" from occupancy -
group by node_name, type order by type
|