university = Site.find(ENV["UNIVERSITY_SITE_ID"])
    members = university.members
    count = 0
    member_emails = []
    emails_as_eui_count = 0

    # find emails as external user ids
    members.find_each do |member|
      eui = member.external_user_id
      if eui && eui.include?("@")
          emails_as_eui_count += 1
      end
    end

    # finds mismatched university member external_user_ids
    # from their KJB user account id
    members.find_each do |member|
      email = member.email
      eui   = member.external_user_id

      if eui && !eui.include?("@")
        id = eui.split(":")[-1]

        if u = User.find_by(id: id)
          unless u.email == email
            puts "Mismatch! member_id: #{member.id}, email: #{email}, eui: #{eui}"
            member_emails << email
            count +=1
          end
        end
      end
    end

    puts "count: #{count}"


    university_users_count = User.where(email: member_emails).count