This select statement lists all users and working dirs. Useful to find out users with workdirs out of standard.
SELECT o_textval as workdir, dms_user.o_username
FROM dms_ucfg, dms_user
where dms_ucfg.o_userno=dms_user.o_userno
and dms_ucfg.o_paramno = 171
and o_compguid='00000000-0000-0000-0000-000000000000'
order by 2,1
FROM dms_ucfg, dms_user
where dms_ucfg.o_userno=dms_user.o_userno
and dms_ucfg.o_paramno = 171
and o_compguid='00000000-0000-0000-0000-000000000000'
order by 2,1