XX_Rider and I worked out this query on the #altiris freenode channel and we thought it might be useful for the community at large:
A use case from XX_Rider:
"The SQL shows all the jobs in the database that were run by the user. Our need was to find out if our staff was using the deployment console. They claimed they were using it but we couldn't find any jobs pushed by them. Other uses would be if an employee leaves, maybe done something they shouldn't have before they left, or to find out what users are making use of the console efficiently, i.e., using jobs instead of doing things manually."
FROM Computer c,
WHERE c.computer_id = es.computer_id