How can we get information showing us the number of people by department to help audit our person and organization data in Atlas?
Executing the following query against the Atlas database will return data showing the number of people per organization:
select o.orgfullname, count(por.personid) numpeople
from personorgrole por
, orgunit o
, person p
where o.orgid = por.orgid
and upper(por.status) = 'ACTIVE'
and p.personid = por.personid
and upper(p.status) = 'ACTIVE'
group by o.orgfullname
order by o.orgfullname;