Software View - Computers with software installed - Last Used Install Date
I am trying to build an automtic removal process for software which is not used for a certain amout of days.
I have found some queries on connect (for example the one here) which I was trying out but it seemed like they do not match what i can see in the Software View. For example here in can see that none of the computers have an Install Date.
But running the query mentioned above I do get the Install Date.
For the Visio Standard 2003 it looks different. Here I have many which have an install Date but not all.
So my question is which Tables are queried in this Software View. Is it "inv_addremoveprogram" and "vammonthlysummary"? Once I know that I can go and check if the inventory is missing for example if it is related inv_addremoveprogram. Or maybe it is some configuration error with the usage tracking...
If it is only a problem of the "Software View" I would not be concerned and would go ahead with automatic removal process but if I cannot trust the Inventory / Metering it will be difficult to have an automated removal process. I do not want users complaining that they have lost the programs which they use daily.