We use the filter function in the GUI to filter out tapes by Last init, or sesam_date in the databse.
However this date is stored as full date (with time) in the database but is only shown as YYYY-MM-DD in the GUI, this means that when we look at the dates when we try ti apply the filter the GUI shows several dates in the filer list with the same date.
This sometimes makes us miss tapes that should be moved offsite.
We have tried to use the filteroption "on or after" as well but this is not always correct either.
As a workaround I now use SQLLite Administrator and do the query directly against the database with a subset on the last_init column:
Code: Select all
select barcode,substr(sesam_date,0,10),pool, eol, slot, loader from media where loader = '4' and substr(sesam_date,0,10) = '2015-03-09' order by slot asc