Skip to main content

Hi,

 

I am trying to create a custom report to see our remaining user licenses. I have got this far but am unsure how to add a field for the remaining licenses.

 

Any advice please!

Ty,

Remaining user license report question

 

TH.png

 

#Reports & Dashboards  #User Licenses

4 answers
  1. Sep 4, 2024, 11:03 AM

    Hi Amber,

     

    User License object have multiple fields but you can setup report only 7 fields.

    Hi Amber, User License object have multiple fields but you can setup report only 7 fields.But there is few fields we can query but can not add in report like usedlicense.But there is few fields we can query but can not add in report like usedlicense. 

    Select Id,Name,Status,TotalLicenses,UsedLicenses from UserLicense

    For getting the remaining license you need to do some manual works.

    remaining license = TotalLicenses - UsedLicenses 

    We have also same requirement and we have multiple org so we create different functionalty for this like below. 

     

    ds (6).png

0/9000