Loading

How to Identify Frozen Users in a Salesforce Org via SOQL

Дата публикации: Jun 13, 2026
Описание

Salesforce administrators may need to identify which users have been frozen in their org — for example, during security reviews, license audits, or when investigating login access issues. Frozen users in Salesforce cannot log in to the org but remain active in the system (they are not deactivated). Freezing a user is a temporary measure that prevents login without removing the user's license or data access settings.
This article explains how to retrieve a list of frozen users using a SOQL (Salesforce Object Query Language) query via the UserLogin object.

Решение

How to Query Frozen Users

The UserLogin object in Salesforce stores login-related information for each user, including whether the user is frozen. To retrieve a list of all frozen users in your org, run the following SOQL query in the Developer Console or Workbench:
Query the UserLogin object, selecting the UserId and IsFrozen fields, and filter for records where IsFrozen equals True.
In SOQL syntax: SELECT UserId, IsFrozen FROM UserLogin WHERE IsFrozen = True
This query returns the User ID for every user who is currently frozen in your Salesforce org. You can use these User IDs to cross-reference the User object to get additional details (such as Name or Username) if needed.

Номер статьи базы знаний

000386556

 
Загрузка
Salesforce Help | Article