Gather information that shows the number of people by department

Technote (FAQ)


Question

How can we get information showing us the number of people by department to help audit our person and organization data in Atlas?

Answer

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;

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Atlas eDiscovery Process Management
Administration

Software version:

4.5.1, 4.5.2, 5.0.1, 6.0, 6.0.1, 6.0.1.1, 6.0.1.2, 6.0.1.3, 6.0.1.4

Operating system(s):

Linux, Solaris, Windows

Reference #:

1621762

Modified date:

2013-04-11

Translate my page

Machine Translation

Content navigation