All Apps Installed + Last Used Date

Anyone have a good SQL query that I could turn into a report that allows a person to enter a computer name and the results would give them all applications installed on that computer plus the last used date of each app. Basically, the report would be identical to the “Software registered in Add Remove Programs on a specific computer” report but I’m thinking I would need to join with the v_MonthlyUsageSummary.LastUsage to include the last time the app was used. Unless that information would be better coming from another view like the v_GS_CCM_RECENTLY_USED_APPS?