Count of users mapping with organization count

Hello DHIS2 team,

In DHIS2 version 2.37.3, the User Management module displayed the number of Organization Units (OUs) mapped to each user (please see attached screenshot). This was a very useful feature, as it allowed us to quickly understand how many OUs were linked to a given user.

image

However, in version 2.40.2 and above, this information is no longer visible. We request you to kindly reintroduce this feature, since it greatly helps administrators track and validate user-to-OU assignments more efficiently.

Thank you for your consideration.

Hi @Ravikumar_Varma . If you’d like, you can create a feature request for this at: Log in with Atlassian account

However, you might be able to get the same information you need, for example with a SQL query, which you can create in the maintenance app (other section). For example, the query below should give you a count of the number of users to assigned to each organisation unit.

select ou.name, A.usercount 
from (select organisationunitid, count(userinfoid) as usercount from usermembership group by organisationunitid) A 
left join organisationunit ou on A.organisationunitid=ou.organisationunitid
order by ou.name