From 4b6fc59bf737cc939f077be61d48b1e48b90d6c9 Mon Sep 17 00:00:00 2001 From: Holger Mueller Date: Wed, 6 Jan 2010 10:05:15 +0100 Subject: [PATCH] Modify the sql query to get alphabetical order of clients when selecting the most recent backup for a client Signed-off-by: Eric Bollengier --- bacula/src/cats/sql_get.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bacula/src/cats/sql_get.c b/bacula/src/cats/sql_get.c index 95dbf32fb3..4e34e73eb5 100644 --- a/bacula/src/cats/sql_get.c +++ b/bacula/src/cats/sql_get.c @@ -568,7 +568,7 @@ int db_get_client_ids(JCR *jcr, B_DB *mdb, int *num_ids, uint32_t *ids[]) db_lock(mdb); *ids = NULL; - Mmsg(mdb->cmd, "SELECT ClientId FROM Client"); + Mmsg(mdb->cmd, "SELECT ClientId FROM Client ORDER BY Name"); if (QUERY_DB(jcr, mdb, mdb->cmd)) { *num_ids = sql_num_rows(mdb); if (*num_ids > 0) { -- 2.39.5