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.
