I'm not sure I know which default AM reports to use. I can use the Underutalized report, but it has drill downs, and i'm not sure how to specifically use it as a target for a policy without exporting it as a filter.
For instance, I'd like to have a filter that allowed me to provide a software GUID and an integer in a number of days and have it show me all machines that have that software installed but not used within the amount of time identified by that integer. I'm really not sure how to accomplish with SQL or which tables to even look at. I can do it maually, mostly, by exporting the data from underutalized software report, stripping out all the computer IDs that have a NO in the used column and feeding them back into a static filter. I'd rather something more automated so that our lisence and install count automatically is adjusted with reclaimed installs.
Is that possible without having someone that really knows SQL and the CMDB table structures?