Skip to content

Instantly share code, notes, and snippets.

@escgeek

escgeek/SOQL for Frozen Users

Last active September 24, 2024 15:33
Show Gist options
  • Save escgeek/8a255fb90b991d5f46c7bcfb7a416e78 to your computer and use it in GitHub Desktop.
Save escgeek/8a255fb90b991d5f46c7bcfb7a416e78 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SOQL for Frozen Users
// This displays the list of users that are active and 'Frozen' in Salesforce.com
SELECT Name, IsActive, LastLoginDate, Id, username FROM User WHERE IsActive = TRUE AND Id IN (SELECT userId FROM userLogin WHERE IsFrozen = TRUE)
@PatrickSantosEverymind
Copy link

Thanks for shared!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment