This will be a difficult report to pull, because the ARP data is just that, ARP data. The usage data is based off .exe name. Also, I wouldn't recommend the Software Metering views, use the default AI view, v_gs_ccm_recently_used_software.
Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Beardsley, James Sent: Friday, June 16, 2017 1:51 PM To: [email protected] Subject: [mssms] 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/table? Thanks, James ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
