>So, I was wondering: > >How do you folks deal with the desire to automatically answer the question > >"Are my copy pools up to date" > >? > > I email the output from the following query run at the end of my backup stgpool cycle:
select node_name as "Node Name ",stgpool_name as "STGPool ", - cast(sum(num_files) as decimal(10,0)) as "Num Files", - cast(sum(logical_mb) as decimal (15,2)) as "Log Occ (MB))" - from occupancy group by node_name,stgpool_name - order by node_name,stgpool_name David
