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

(3293)

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in IBM Austraila as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 10 Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply