Skip to content

Instantly share code, notes, and snippets.

@escgeek
Last active December 8, 2023 12:28
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.
// 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)
@jvolkov
Copy link

jvolkov commented May 10, 2022

Just what I was looking for. Thanks!

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