>>>>> On Mon, 20 Nov 2006 21:30:41 +0100 (MET), Arno Lehmann said: > > Hello, > > On 11/20/2006 5:10 PM, Ryan Novosielski wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > I've been seeing my File volumes being reported on the list for "volumes > > possibly needing replacement" for months now. These volumes, IMO, do not > > age like a tape volume would, and do not need to show on this list for > > exceeding mount numbers or write numbers. > > True. > > > I therefore suggest/submit for > > review the attached patch of query.sql. > > > > My understanding of my revision is that I want to know about volumes > > that have a nonzero error count, a status of Error, or a status of > > Disabled (why disabled, BTW, anyone know? -- this was in the original), > > I know, because I wrote the original. The reason is quite smple: I set > volumes to disabled when I have problems with them, or if the changer > can't load them, for example. > > > or have been mounted too many times and are not files. > > > > Is this a good or bad change? > > That change has one problem, which is the same my original version has: > It only works for you, just like my version works for me :-) > > You check for MediaType to not be 'File' which is not an assumption that > is true in every situation. Especially because you might well have > different file-based MediaTypes. Especially if you use more than one > device with files. > > The best solution would be to have some kind of macros in the query.sql > file. One that expands to all media types of file would be very > convenient for this... but I guess this will not soon be available.
Maybe the info could be stored in the MediaType table? __Martin ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
