Wolfgangs query delivers a different result set than your query.
On our Testsystem 1249 Rows vs 42k Rows on one of our Testsystems, so i am not sure if it is what you have been looking for, at least it does notquery what you have queried.
I created one that matches yours and just adds the username
SELECT a.AH_NAME as 'Name', a.AH_Idnr as 'RunID', o1.OH_Otype as 'Type', a.AH_Timestamp1 as 'Activation time', a.AH_USR_idnr, o2.oh_name, a.AH_Timestamp4 as 'End time',
CASE AH_Status
WHEN '1300' THEN 'Preparing'
WHEN '1301' THEN 'Waiting for user-input/a prompt is displayed for the user'
WHEN '1510' THEN 'Transferred'
WHEN '1520' THEN 'Ready for transfer (before connect)'
WHEN '1521' THEN 'Ready to be transferred'
WHEN '1529' THEN 'Ready for generation'
WHEN '1530' THEN 'Ready for start'
WHEN '1531' THEN 'To be called'
WHEN '1540' THEN 'Start initiated'
WHEN '1541' THEN 'Checking'
WHEN '1542' THEN 'Calling'
WHEN '1543' THEN 'Unknown'
WHEN '1544' THEN 'Inconsistent'
WHEN '1545' THEN 'Started'
WHEN '1546' THEN 'Connecting'
WHEN '1547' THEN 'Inconsistent RemoteTaskManager'
WHEN '1550' THEN 'Active'
WHEN '1551' THEN 'Transferring'
WHEN '1552' THEN 'Called'
WHEN '1553' THEN 'Accepted'
WHEN '1554' THEN 'Sampling Files'
WHEN '1556' THEN 'Escalated'
WHEN '1557' THEN 'Custom backup'
WHEN '1800' then 'ENDED_NOT_OK - Aborted'
WHEN '1900' then 'ENDED_OK - ended normally'
END
FROM AH a, oh o1, oh o2
WHERE
a.ah_oh_idnr = o1.oh_idnr
and a.AH_USR_idnr = o2.oh_idnr
and o1.oh_otype NOT IN ('SERV','HOST','CLNT', 'QUEUE', 'USER')
ORDER BY AH_STATUS
I have no idea what this statement shall be used for, but i wanted to show how to get the user name. :-)