We need a new feature in the controller UI that allows us to retrieve 'count the number of licenses consumed by each organization'.

While the new feature in https://www.redhat.com/en/blog/subscription-and-host-metric-changes-in-ansible-automation-platform-2.4 is useful on a whole platform level, However, if i have multiple departments (divided by Ansible organisation) using the same AAP platform, the above feature will be limited in its function.

FYI…as an alternative it is possible to query the active hosts from an Organization from the database as follows:
~~~~~
sudo su - awx
awx-manage shell_plus
Host.objects.org_active_count(org_id=1)
quit()
~~~~~
But the expectation is that this function should be in the controller UI that allows us to retrieve 'count the number of licenses consumed by each organization'.