Joining Installed Software to Monthly Summary Data
I'm struggling to create a report that links information in the Inv_InstalledSoftware table to usage data in the Inv_Monthly_summary table. My goal is to create a report that shows the installed software on a computer and, if the application is metered, to show the last used date. The columns would look like this...
Software Name | Computer Name | Installed Date | Date Last Used
It would seem like this would be easy because the console shows similar data when you navigate to Software > Usage Tracking and click on a metered application. That said, I just can't figure out how pull it off. I believe the tables/views involved are:
- ResourceAssociation (links Inv_InstalledSoftware to vSoftwareProduct)
If there is already built-in report for this, let me know (I admittedly could have missed it), but if not, any suggestions on building it would be appreciated.