How to fetch the Salesforce Profile Name From User Object Using SOQL

Using Below SOQL, We can fetch the Profile name from User Object in single query itself:

Select Username, UserType, Title, ProfileId, Name, LastLoginDate, Id, Email, CompanyName, Alias, Profile.Name From User

Using Below SOQL, We can fetch the list of lost login user details in Profie wise:

Select Username, UserType, Title, ProfileId, Name, LastLoginDate, Id, Email, CompanyName, Alias, Profile.Name From User

Written by 

Salesforce MVP | Lightning Champion | 16x Salesforce Certified | Application Architect | 6x Trailhead Ranger | Techforce Services | Australia

Leave a Reply

Your email address will not be published. Required fields are marked *

*