Need customized postgresql query to get the list of user with there associated group with details like whether the assocaiated group is AD/Local.
Please help to get the list.
Look in the cwd_ tables. cwd_user will tell you about the users and which directory they are in, and cwd_membership will give you the membership of their groups.
I'm not 100% sure I would give you the right "join" for the question you are probably asking, but cwd_membership alone may well be able to answer it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.