Matching OWNER_ID and MODIFIED_ID from work items to Jazz usernames
I am creating a custom SQL query to display the ownership / modified by history of a work item. (The JRS tool can not display this full history as shown in RTC). Using the JazzDW database, I am able to return the work item ID, Name, Owner_ID, Modified_ID, and Modified Date/ Time from the jazzdw.RICALM.Request_History table. At this point, I need to match the owner_id and modifier_id numbers with actual names. Does anyone know where the in the JazzDW database this information is stored? (This solution was recommended by IBM support, but the information I am requesting was not given)
SELECT REFERENCE_ID, NAME, OWNER_ID, MODIFIER_ID, REC_DATETIME FROM [jazzDW].[RICALM].[REQUEST_HISTORY] WHERE REFERENCE_ID = 'XXXX' AND NAME = 'TASK NAME'
ORDER BY REC_DATETIME DESC;
Accepted answer
Hmm... I can see Modifier Name as an available attribute when doing work item history reports. I see real user names, but sometimes "Resource full name not available"
Here's the info on the quickly thrown together report:
And a snap of the resulting report
Comments
Thank you for this. As a new Jazz user, I was not fully aware of all of the reporting functions in JRS. Kind of surprised IBM support didn't point me to the 'Work Item History' area initially, but in any case, this solves my issue. Just adding to your sample report an 'Owner Name' column gives me exactly the information I need.
I've been doing Jazz things since '09 and I'm always learning something new! Glad I could help.