What about:
select volume_name from volumeusage where node_name='<your node>' and
stgpool_name='<copypool>'

You cannot easily add PIT information in the equation..

Zlatko Krastev
IT Consultant






Justin Bleistein <justin.bleistein AT SUNGARD DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
14.08.2003 16:28
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        select statement needed


we recover our systems in dr via our backup storage pools obviously... Our
backup storage pool is not collocated.. So the data is spread across more
tapes. Now is there a report I can run like a select statement which will
tell met how many tapes I would need during a point in time recovery
(-pitd) for a particular node at dr?

thanks!.

--Justin Richard Bleistein
Unix/TSM Systems Administrator (Sungard eSourcing)
Desk: (856) 566 - 3485
Cell:    (856) 912 - 0861
Email: justin.bleistein AT sungard DOT com