Gather information that shows the number of people by department
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;
More support for:
Atlas eDiscovery Process Management
Software version: 4.5.1, 4.5.2, 5.0.1, 6.0, 6.0.1, 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168
Operating system(s): Linux, Solaris, Windows
Reference #: 1621762
Modified date: 11 April 2013