sfdc-learn #3 How to check which are users locked or freeze in salesforce org with soql.

 To check which are users locked or freeze in salesforce org with soql query.

Select id,Username,FirstName, LastName from user where Id In (select UserId from UserLogin  where IsPasswordLocked = true)

Select id,Username,FirstName, LastName from user where Id In (select UserId from UserLogin  where IsFrozen = true)