pypi
diff --git a/‎warehouse/admin/templates/admin/ip_addresses/detail.html‎
Lines changed: 2 additions & 0 deletions b/‎warehouse/admin/templates/admin/ip_addresses/detail.html‎
Lines changed: 2 additions & 0 deletions
diff --git a/‎warehouse/admin/views/ip_addresses.py‎
Lines changed: 2 additions & 0 deletions b/‎warehouse/admin/views/ip_addresses.py‎
Lines changed: 2 additions & 0 deletions
@@ -71,6 +71,7 @@ <h3 class="card-title">Unique logins</h3>
           <tr>
             <th scope="col">Created</th>
             <th scope="col">User</th>
+            <th scope="col">Frozen</th>
             <th scope="col">Status</th>
             <th scope="col">Device Information</th>
           </tr>
@@ -80,6 +81,7 @@ <h3 class="card-title">Unique logins</h3>
           <tr>
             <td>{{ login.created }}</td>
             <td><a href="{{ request.route_path('admin.user.detail', username=login.user.username ) }}">{{ login.user.username }}</a></td>
+            <td>{% if login.user.is_frozen %}<i class="fa fa-check text-red"></i>{% endif %}</td>
             <td>{{ login.status.value }}</td>
             <td>{{ login.device_information }}</td>
           </tr>
 
@@ -10,6 +10,7 @@
 from pyramid.httpexceptions import HTTPBadRequest, HTTPSeeOther
 from pyramid.view import view_config
 from sqlalchemy.exc import NoResultFound
+from sqlalchemy.orm import joinedload
 
 from warehouse.accounts.models import UserUniqueLogin
 from warehouse.authnz import Permissions
@@ -62,6 +63,7 @@ def ip_address_detail(request: Request) -> dict[str, IpAddress]:
 
     unique_logins = (
         request.db.query(UserUniqueLogin)
+        .options(joinedload(UserUniqueLogin.user))
         .filter(UserUniqueLogin.ip_address == ip_address)
         .order_by(UserUniqueLogin.created.desc())
         .all()