Documentum User Inbox Query

Hello readers,

A really simple yet effective DQL query is the following:

EXECUTE get_inbox WITH name='{user}';

It gives you information about the task but also the workflow and the included packages.

Kind regards, Marcus

Taskspace users not available

Hello readers,

As you may all know Taskspace is the workflow client from EMC.
Taskspace is working with an user inbox where the tasks for the user will appear.
If you ever wonder why another user gets an inbox task, please keep in mind that users can set them-selfs to not available and delegate there tasks to someone else.

Here are some screenshots where you can see this feature.

So be careful when you start analyzing your process templates.
To quickly see what users are not available, this DQL query can come in handy.

select r_object_id, user_state, user_name, user_os_name, user_address, user_source, user_login_name, workflow_disabled, user_delegation, last_login_utc_time from dm_user where user_state = 0 and workflow_disabled = true;