Select for total object count of System State backups

[Andrew21210]

Is it possible to run a select that will give me the total object count to the System State backups on my server? If anyone has a canned select, I'd be happy to have it.

 

[moon-buddy]

Simple

select filespace_name,num_files from occupancy where node_name='<node_name_in_CAPS>' and filespace_name like '%\SystemState'

 

[Andrew21210]

Simple

select filespace_name,num_files from occupancy where node_name='<node_name_in_CAPS>' and filespace_name like '%\SystemState'

Thanks. What I'm looking for is the total number of System State objects though. Not on a per node basis but a total on my TSM server.

 

[marclant]

Thanks. What I'm looking for is the total number of System State objects though. Not on a per node basis but a total on my TSM server.

Try:

select sum(num_files) from occupancy where filespace_name like '%\SystemState'

 

[Andrew21210]

Excellent. That is exactly what I was after. Thank you.