A way to list users and working dirs

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

Created by Rogerio Duarte
When: Wed, Mar 5 2014 2:34 PM
Last revision by Dana Guthrie
When: Mon, Sep 26 2022 2:28 PM
Revisions: 4
Comments: 0

Recommended