Querry help

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

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

Something like - query nodedata

Good Luck,
Sias

A slightly different take on moon-buddy' select statement

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