IBM Support

Gather information that shows the number of people by department

Technote (FAQ)


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;

Document information

More support for: Atlas eDiscovery Process Management

Software version: 4.5.1, 4.5.2, 5.0.1, 6.0, 6.0.1,,,,

Operating system(s): Linux, Solaris, Windows

Reference #: 1621762

Modified date: 11 April 2013