DQL to list queue user membership

What would be the DQL/SQL query to find the user names of users in a particular queue? Or, if put the other way around - what would be the query to find the queues that a user is a member of? Thanks in advance!

Find more posts tagged with

Documentum

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

JorgKrause

Hi,

work queue member are stored in a group named exactly the same as your workqueue, and group_class = 'queue'.

This query gives you the associate groups for all defined work queues.

select * from dm_group where group_name in (select wq_name from dmc_workqueue)

To find all workqueues a specific user is member of, you could run

select * from dm_group where group_class = 'queue' and any i_all_users_names = '<user_name>'

Regards

Jørg

All comments

JorgKrause

Hi,

work queue member are stored in a group named exactly the same as your workqueue, and group_class = 'queue'.

This query gives you the associate groups for all defined work queues.

select * from dm_group where group_name in (select wq_name from dmc_workqueue)

To find all workqueues a specific user is member of, you could run

select * from dm_group where group_class = 'queue' and any i_all_users_names = '<user_name>'

Regards

Jørg

jsabh

Thanks Jørg!

JorgKrause

You're welcome