How to query Internal, Community/Portal and Community/Portal Users in Salesforce using SOQL?
Internal Users: SELECT Id, Name, IsActive, Profile.Name FROM User WHERE ProfileId IN ( SELECT Id FROM Profile WHERE UserType = 'Standard' ) Customer Community/Portal Users: SELECT Id, Name, IsActive, Profile.Name ....