I'm wondering if this minor change could be put into Bacula so that results
are sorted differently when you do a 'list volumes' inside bconsole.
I believe anybody that uses barcoded tapes would much prefer to see this
list sorted by VolumeName rather than MediaId whenever they need to look at
the list for the purpose of doing media rotation. I can't think of any
negative consequences (however there may be some that I don't experience).
Ideally this would be more configurable, so a person could select which
sort order they want I suppose.
Any thoughts?
Bob
--- bacula-5.2.0rc1.old/src/cats/sql_list.c 2011-08-05 06:25:01.000000000
-0400
+++ bacula-5.2.0rc1/src/cats/sql_list.c 2011-08-24 14:24:00.257479522 -0400
@@ -184,7 +184,7 @@
} else {
Mmsg(mdb->cmd, "SELECT MediaId,VolumeName,VolStatus,Enabled,"
"VolBytes,VolFiles,VolRetention,Recycle,Slot,InChanger,MediaType,LastWritten "
- "FROM Media WHERE Media.PoolId=%s ORDER BY MediaId",
+ "FROM Media WHERE Media.PoolId=%s ORDER BY VolumeName",
edit_int64(mdbr->PoolId, ed1));
}
}
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% more powerful than alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
