User information from History Table using RRDI/insight
![](http://jazz.net/_images/myphoto/770c710a7a8bf1684d49489a92685a9f.jpg)
Hi,
I am generating report using Rational Insight form Request History and Request State History table. to show the detail of State transition. I am able to get required information expect who (user) did the transition. Is there any way to get this information? If user information is not exposed in DW, Is there any way to fetch it from RTC database by writing own ETL using Rational insight data manager? This is very important report needed for audit purpose. Requesting urgent response.
Thanks,
Sachin Chitrakoti
I am generating report using Rational Insight form Request History and Request State History table. to show the detail of State transition. I am able to get required information expect who (user) did the transition. Is there any way to get this information? If user information is not exposed in DW, Is there any way to fetch it from RTC database by writing own ETL using Rational insight data manager? This is very important report needed for audit purpose. Requesting urgent response.
Thanks,
Sachin Chitrakoti
Accepted answer
![](http://jazz.net/_images/myphoto/770c710a7a8bf1684d49489a92685a9f.jpg)
I created an Enhancement requesting this same function, however it's not available to use yet. I'll try to find the workitem number and share with you so you can subscribe also.
(Updated 4/22): I found the Plan Item that covers this request: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=242806. The summary includes the 'Modified By' capability.
(Updated 4/22): I found the Plan Item that covers this request: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=242806. The summary includes the 'Modified By' capability.