.
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     rogerd AT uic DOT edu


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?
>