When we search for runtime data by utilizing the View Submitted Tasks (VST) task, there are queries ran directly against the Task Persistence or Archive databases.
For troubleshooting purpose, we could ran the same queries directly against the relevant database ourselves, as seeing the raw data is sometimes easier for analysing reason for unexpected / missing data to be seen in VST.
Attached is a document with the different queries used by Identity Manager against the database, in the raw syntax which can be used with any database tools (SQL Development Studio etc). These queries are for the different categories available in the original VST screen
Rinat Matityahu
Principal Support Engineer
CA Technical Support - EMEA