Query Report on Specific Software Installed Systems

Query Report on Specific Software Installed Systems

I have tried hacking together a few of the queries listed on here, but I can't seem to get it to work. I am needing a report to show the computer name, assigned user, and asset state (preferably grouped by that) for all workstations that have the software title "Microsoft Office Professional" installed on them. I can seem to find one that includes some of the info, but not one with all of them. And I'm having trouble trying to use those LEFT JOINs.  The pre-built reports in SD show some of the info we're looking for, but none of them have all that (specifically the asset state (In Use, Spare, In Store, etc) and the currently assigned user.

                  New to ADSelfService Plus?