01
About this report
Each active role with its centre type, whether it is a sales, support or web-services-only role, and the number of active employees with login access who hold it.
Roles nobody holds are candidates for inactivation. Roles held by many people deserve a permission review. Click Users to open Users and roles filtered to that role.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Role | Centre type | Sales role | Support role | Web services only | Users |
|---|---|---|---|---|---|
| Employee Center | EMPLOYEECENTER | No | No | No | 38 |
| Accountant | ACCOUNTCENTER | No | No | No | 4 |
| Sales Manager | SALESCENTER | Yes | No | No | 3 |
| Administrator | ACCOUNTCENTER | No | No | No | 2 |
| Warehouse Manager | SHIPPINGCENTER | No | No | No | 0 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT ro.name AS role,
ro.centertype AS center_type,
ro.issalesrole AS sales_role,
ro.issupportrole AS support_role,
ro.iswebserviceonlyrole AS web_services_only,
COUNT(DISTINCT e.id) AS users
FROM role ro
LEFT JOIN employeerolesforsearch er ON er.role = ro.id
LEFT JOIN employee e ON e.id = er.entity AND e.giveaccess = 'T' AND e.isinactive = 'F'
WHERE ro.isinactive = 'F'
GROUP BY ro.name, ro.centertype, ro.issalesrole, ro.issupportrole, ro.iswebserviceonlyrole
ORDER BY users DESC, roleSELECT e.id AS employee__id,
e.entityid AS employee,
e.email AS email,
e.title AS job_title,
BUILTIN.DF(e.supervisor) AS supervisor,
ro.name AS role,
ro.centertype AS center_type,
ro.iswebserviceonlyrole AS web_services_only
FROM employee e
JOIN employeerolesforsearch er ON er.entity = e.id
JOIN role ro ON ro.id = er.role
WHERE e.giveaccess = 'T'
AND e.isinactive = 'F'
ORDER BY employee, role