scratch tape alert ?

[Michael_G_Ander]

Has somebody managed to create a scratch tape alert ?

Know there is a low available media alert,  but that does not quite cover our need of knowning when the number scratch tapes is low in robot(s) especially since you cannot drill down from the master server level.

[RiaanBadenhorst]

This will give the amount of scratch tapes but I have no idea how to create your own Alert.

select count (*) from nom_nbmedia
where nom_nbmedia.volumepoolname ='Scratch'
and nom_nbmedia.robotname not in ('NONE')

[Michael_G_Ander]

Thanks, but that does not quite cover what I am trying too achevie either.

[Michael_G_Ander]

Have changed the SQL query for mutliple robots

select nom_nbmedia.robotnumber, nom_nbmedia.robotname, count(*) from nom_nbmedia

where nom_nbmedia.volumpoolname='Scratch'

group by nom_nbmedia.robotnumber, nom_nbmedia.robotname

For some reason I do not can figure out, this does not show robots completely without scratch tapes.

Probably something to do with null values....