X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fdird%2Fmigrate.c;h=0fe24e0a6738e2abe09d35318d370bf1c3fb4535;hb=44566f589dd96e4414e38ec4bf7d76b22fbcd9aa;hp=38f51f31a848e71ebfc0d1aff3bbc7f08d014eec;hpb=dc73b35ec79d9852ebb77e08ecd331eb8b777fa9;p=bacula%2Fbacula

diff --git a/bacula/src/dird/migrate.c b/bacula/src/dird/migrate.c
index 38f51f31a8..0fe24e0a67 100644
--- a/bacula/src/dird/migrate.c
+++ b/bacula/src/dird/migrate.c
@@ -373,7 +373,7 @@ const char *sql_client =
 
 /* Get JobIds from regex'ed Client names */
 const char *sql_jobids_from_client =
-   "SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool"
+   "SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool,Client"
    " WHERE Client.Name='%s' AND Pool.Name='%s' AND Job.PoolId=Pool.PoolId"
    " AND Job.ClientId=Client.ClientId "
    " ORDER by Job.StartTime";
@@ -651,6 +651,8 @@ static bool get_job_to_migrate(JCR *jcr)
     *  for each of them.  For the last JobId, we handle it below.
     */
    p = ids.list;
+   Jmsg(jcr, M_INFO, 0, _("The following %u JobIds will be migrated: %s\n"),
+      ids.count, ids.list);
    for (int i=1; i < (int)ids.count; i++) {
       JobId = 0;
       stat = get_next_jobid_from_list(&p, &JobId);