Am 10.03.20 um 09:26 schrieb Pierre Bernhardt: > (How can I check it which drive index has been used before and since > 2020 ? Is there a field which shows me the drive index in the db?) Ok, found a field but it is ever filled by 0:
bacula=> select volumename,deviceid,volbytes from media where volumename like 'LTO4%'; volumename | deviceid | volbytes ------------+----------+-------------- LTO40002 | 0 | 812678501376 LTO40004 | 0 | 812714886144 LTO40009 | 0 | 812782107648 LTO40012 | 0 | 812686500864 LTO40007 | 0 | 812761721856 LTO40016 | 0 | 812686758912 LTO40013 | 0 | 812738562048 LTO40015 | 0 | 812673921024 LTO40006 | 0 | 812596248576 LTO40008 | 0 | 812671534080 LTO40010 | 0 | 812681017344 LTO40014 | 0 | 812726369280 LTO40018 | 0 | 812729723904 LTO40020 | 0 | 812725788672 LTO40019 | 0 | 812656180224 LTO40025 | 0 | 628959808512 LTO40031 | 0 | 552112210944 LTO40003 | 0 | 812701596672 LTO40027 | 0 | 629233274880 LTO40022 | 0 | 812717724672 LTO40023 | 0 | 782473273344 LTO40026 | 0 | 628718920704 LTO40028 | 0 | 579429107712 LTO40011 | 0 | 812760173568 LTO40005 | 0 | 812693016576 LTO40001 | 0 | 812703725568 LTO40017 | 0 | 812674050048 LTO40034 | 0 | 475099978752 LTO40024 | 0 | 336473819136 LTO40032 | 0 | 554964544512 LTO40029 | 0 | 548973702144 LTO40035 | 0 | 64512 LTO40033 | 0 | 558934032384 (33 rows) bacula=> select volumename,deviceid from media where deviceid != 0; volumename | deviceid ------------+---------- (0 rows) Cheers, Pierre _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
