This is used to populate the respin the Report Server (https://rps01.its.hawaii.edu) to supply the comprehensive list of active staff and students in ITS.
Access to Report Server: Keith HIrata
New SQL:
--STAFF
select sect.sectname as section, role.roledescr, pers.perslastname as lastname, pers.persfirstname as firstname,
pers.persuhuuid as uhnumber, pers.persitsusername as username,
pers.persemail as email, ppos.pposmanager as supervisor
...