. That occupancy table can be REALLY slow to process if your system is at all large. I prefer to search the summary table which is fast, even with my 275gb database.
select distinct entity from summary where activity='BACKUP' ...will be MUCH faster. This gives you the past 30 days. If you want fewer days, perhaps somebody who is more of an SQL wizard can help. Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] On Fri, 14 Mar 2008, Richard Sims wrote: select distinct NODE_NAME from occupancy where TYPE='Bkup' > >On Mar 14, 2008, at 4:33 PM, Avy Wong wrote: > >> Hello, >> Is there a command I can run to get the number of nodes being >> backed >> up on tivoli? >
