• sanjita njita
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi Team,
i need report of user records (user license) based on the department.
i.e need to know how many licenses are consumed by each department.

I have used below query but its working for only limit 100 becoz of Org limit..we have 1000+ departments. could you please help here?

SELECT COUNT(Id),Department from user where User_License_Name__c='Salesforce' group by Department limit 100

Thank You!