You need to sign in to do that
Don't have an account?
Vijaykumar
SOQL query to fetch user records ( user license) based on department
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!
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!
You can generate a martix report on user object based on User_License_Name__c field instead of quering.
Refer the below video, how to create matrix report.
https://www.youtube.com/watch?v=vDudLNQIQOc
If this information helps, Please mark it as best answer.
Thanks!!
Please follow below code:-
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh