Help for query report in Servicedesk Plus 8.0

Help for query report in Servicedesk Plus 8.0

Hi,
 
I need to be able to draw a report showing all installed software titles in PC's sorted by WorkstationID - as well as info on "last logged user".
 
Format like this:
 
Workstation ID - Software titles - Last logged user.
 
How would this query be, when using mysql?
 
/Erling

                  New to ADSelfService Plus?