I am trying to make a query that will tell me the last time someone used a piece of software. I need this so I can uninstall the software from anyone who has not used it in 90+ days. I have found a thing in Lan Desk query that is last used but can not seem to get that to work properly. Can someone help guide me toward the end result I am looking for.
you can use Software License Monitoring functionality.
Under product definition, double click on the concerned software.
If you need to export the data you have to rigth click on the software name and select "View as Report"
Be careful when using data for this from Add/Rem Programs because it is not always accurate. If you look in Add/Rem on your computer, you will probably find that commonly used applications have not updated the entry.
Due to the size of company and the way Lan Desk has been setup we are unable to use SLM.
I have gotten results to come up but I am getting 10-20+ results per computer. I am not able to use SLM at all because of the way it is setup. Also, not able to write a straight SQL command against the database due to the fact I am unable to get access to the database. Any suggestions are helpful. I am probably going to have to look at doing it manually.