User Assigned Tasks table in the Database

Products

• CA Process Automation Base

Issue/Introduction

Where are User Assigned Tasks located in the Database and is it possible to review task ownership outside of a Process?

Environment

Release:  4.3 or higher
Component:  CA IT PAM

Resolution

Tasks are held in the c2opromptuser table, PAM database

The Task id is the ROID column and the Title is the PromptTitle in the above table.

The Assignee is a bit more difficult to get to. You will need to parse it out of the UserInfoXML column:

(page)userInfo(/page)(/display)
(cstring)(value)pamadmin(/value)