Querry help

[cwilloug]

I thought I had a querry once upon a time, I'm looking for querry, if possible, on how many tapes a specific node is using? Does anyone have any idea? Is this possible?

Thanks

Have a good weekend!!

[moon-buddy]

select volumes from volumeusage where node_name='node_name' and stgpool_name='stgpool_name'

[LED888]

Something like - query nodedata

Good Luck,
Sias

[ChrisRees]

A slightly different take on moon-buddy' select statement

select stgpool_name, count(*) from volumeusage where node_name='node_name' group by stgpool_name