Need help with creating a custom report
I'm trying to create report that will return the results of all the software and the count by computer in my domain, however I want to exclude certain programs from this report. I can do this two ways:
1) I have two computers which are my baseline computers (i.e. I've built these machines with the applications I nkow about)
2) I know the file locations of all the applications I want to exclude.
Ideally, I'd like to create a report which will return all software audit results, excluding the software found on my two baseline machines. If that's too complex, I'm willing to write a report that will return all software audit results minus the software file locations I already know about (by manually excluding them in the script).
Does someone have a sample report I can use to build this report?
Thanks!
Comments
This is what I would do...
The way I would do it, would be to subquery the add/remove table for your 2 baseline PC's, then run your COUNT off of add/remove with a WHERE NOT IN. I'll post a query a little bit later today with parameters for the 2 PC names to be filtered.
Edit: The problem you'll run into, though, will be that only exact matches will filter out, so new versions of say, winzip, with a slightly different name will still be returned. I suppose you could then add individual exclusions for the apps that you know are supposed to be there, but still show up in your results.
Would you like to reply?
Login or Register to post your comment.