@Secured({"ROLE_ADMIN"})
  @RequestMapping(value = {"/admin/fail"})
  public ModelAndView getPermanentFailConnectors(
      HttpServletResponse response,
      @RequestParam(
              value = "filter",
              required = false,
              defaultValue = "apiKey.reason!='" + ApiKey.PermanentFailReason.NEEDS_REAUTH + "'")
          String filter,
      @RequestParam(value = "guestId", required = false) String guestId,
      @RequestParam(value = "status_0", required = false, defaultValue = "false") boolean statusUp,
      @RequestParam(value = "status_1", required = false, defaultValue = "false")
          boolean statusPermanentFail,
      @RequestParam(value = "status_2", required = false, defaultValue = "false")
          boolean statusTemporaryFail,
      @RequestParam(value = "status_3", required = false, defaultValue = "false")
          boolean statusOverRateLimit)
      throws Exception {
    response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
    response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
    response.setDateHeader("Expires", 0);
    final List<ApiKey.Status> statusFilters = new ArrayList<ApiKey.Status>();
    if (statusUp) statusFilters.add(ApiKey.Status.STATUS_UP);
    if (statusPermanentFail) statusFilters.add(ApiKey.Status.STATUS_PERMANENT_FAILURE);
    if (statusTemporaryFail) statusFilters.add(ApiKey.Status.STATUS_TRANSIENT_FAILURE);
    if (statusOverRateLimit) statusFilters.add(ApiKey.Status.STATUS_OVER_RATE_LIMIT);

    ModelAndView mav = new ModelAndView("admin/permanentFail");

    final StringBuffer queryString = new StringBuffer("SELECT apiKey FROM ApiKey apiKey ");

    StringBuffer whereClause = new StringBuffer();
    boolean whereClauseAdded = addPotentialStatusWhereClause(whereClause, statusFilters);
    if (!StringUtils.isEmpty(guestId)) {
      addGuestIdClause(whereClause, guestId, whereClauseAdded);
      whereClauseAdded = true;
    }
    if (!StringUtils.isEmpty(filter)) {
      addFilterClause(whereClause, filter, whereClauseAdded);
      whereClauseAdded = true;
    }

    if (whereClauseAdded) queryString.append(whereClause).append(" ");

    queryString.append("ORDER BY apiKey.api, apiKey.guestId");

    System.out.println(queryString.toString());

    final List<ApiKey> apiKeys =
        jpaDaoService.executeQueryWithLimitAndOffset(
            queryString.toString(), Integer.MAX_VALUE, 0, ApiKey.class);
    mav.addObject("statusFilters", statusFilters);
    mav.addObject("apiKeys", apiKeys);
    mav.addObject("filter", filter);
    mav.addObject("guestId", guestId);
    mav.addObject("release", env.get("release"));
    return mav;
  }
  @Secured({"ROLE_ADMIN"})
  @RequestMapping(value = {"/admin"})
  public ModelAndView admin(
      HttpServletResponse response,
      @RequestParam(value = "page", required = false, defaultValue = "1") int page,
      @RequestParam(value = "pageSize", required = false, defaultValue = "20") int pageSize)
      throws Exception {
    response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
    response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
    response.setDateHeader("Expires", 0);
    ModelAndView mav = new ModelAndView("admin/index");

    long totalGuests = jpaDaoService.executeNativeQuery("SELECT count(*) from Guest");

    // If pageSize is too small, set to default of 20
    if (pageSize <= 0) pageSize = 20;

    // Limit range of page to be >=1 and <= lastPage)
    int lastPage =
        ((int) totalGuests) % pageSize == 0
            ? ((int) totalGuests) / pageSize
            : ((int) totalGuests) / pageSize + 1;
    if (page < 1) page = 1;
    else if (page > lastPage) page = lastPage;

    final int offset = (page - 1) * pageSize;
    final List<Guest> allGuests =
        jpaDaoService.executeQueryWithLimitAndOffset(
            "SELECT guest FROM Guest guest", pageSize, offset, Guest.class);
    // get scheduled updateWorkerTasks for the current subset of users
    final List<UpdateWorkerTask> tasks = connectorUpdateService.getAllScheduledUpdateWorkerTasks();

    mav.addObject("allGuests", allGuests);
    mav.addObject("release", env.get("release"));
    final List<ConnectorInfo> connectors = systemService.getConnectors();
    mav.addObject("subview", "connectorHealthDashboard");
    mav.addObject("connectors", connectors);
    List<Map.Entry<Guest, List<List<ApiKey>>>> rows =
        new ArrayList<Map.Entry<Guest, List<List<ApiKey>>>>();
    ValueHolder synching = getSynchingUpdateWorkerTasks();

    long consumerTriggerRepeatInterval = Long.valueOf(env.get("consumer.trigger.repeatInterval"));
    ValueHolder due = getDueUpdateWorkerWorkerTasks(tasks, consumerTriggerRepeatInterval);
    ValueHolder overdue = getOverdueUpdateWorkerWorkerTasks(tasks, consumerTriggerRepeatInterval);

    for (Guest guest : allGuests) {
      List<List<ApiKey>> guestApiKeys = new ArrayList<List<ApiKey>>();
      for (ConnectorInfo connector : connectors) {
        final List<ApiKey> apiKeys =
            guestService.getApiKeys(guest.getId(), Connector.fromValue(connector.api));
        guestApiKeys.add(apiKeys);
      }
      final Map.Entry<Guest, List<List<ApiKey>>> guestListEntry =
          new AbstractMap.SimpleEntry<Guest, List<List<ApiKey>>>(guest, guestApiKeys);
      rows.add(guestListEntry);
    }
    mav.addObject("totalGuests", totalGuests);
    mav.addObject("fromGuest", offset);
    mav.addObject("toGuest", offset + allGuests.size());
    mav.addObject("page", page);
    mav.addObject("pageSize", pageSize);
    mav.addObject("synching", synching);
    mav.addObject("tasksDue", due);
    mav.addObject("tasksOverdue", overdue);
    mav.addObject("rows", rows);
    mav.addObject("serverUUID", connectorUpdateService.getLiveServerUUIDs().toString());
    return mav;
  }