     if (!db_sql_query(ua->db, rx->query, NULL, NULL)) {
        ua->warning_msg("%s\n", db_strerror(ua->db));
     }
+Index: src/jcr.h
+===================================================================
+--- src/jcr.h	(revision 8163)
++++ src/jcr.h	(working copy)
+@@ -65,6 +65,7 @@
+ #define JT_ADMIN                 'D'  /* admin job */
+ #define JT_ARCHIVE               'A'  /* Archive Job */
+ #define JT_COPY                  'C'  /* Copy Job */
++#define JT_JOBCOPY               'J'  /* Copy Job */
+ #define JT_MIGRATE               'g'  /* Migration Job */
+ #define JT_SCAN                  'S'  /* Scan Job */
+ 
+Index: src/lib/util.c
+===================================================================
+--- src/lib/util.c	(revision 8163)
++++ src/lib/util.c	(working copy)
+@@ -361,6 +361,9 @@
+    case JT_COPY:
+       str = _("Copy");
+       break;
++   case JT_JOBCOPY:
++      str = _("Job Copy");
++      break;
+    case JT_CONSOLE:
+       str = _("Console");
+       break;

    int i;
 
    /* Create temp tables */
@@ -1196,23 +1216,38 @@
    }
 
    /* If Pool specified, add PoolId specification */

+      pm_strcat(other_filter, temp_filter.c_str());
+      Dmsg1(0, "Use mediatype filter (%s)\n", rx->MediaType);
+   }
+   if (bstrcmp(other_filter.c_str(), "")) {
+      Dmsg0(0, "Don't use copy jobs\n");
+      pm_strcpy(other_filter, " AND Type='B' ");
+   }
 
    /* Find JobId of last Full backup for this client, fileset */
    edit_int64(cr.ClientId, ed1);
    Mmsg(rx->query, uar_last_full, ed1, ed1, date, fsr.FileSet,
