Old Software Report

1

I'm fairly good at standard reports but terrible at SQL reports. I was told today the latter is needed for this. I have dynamic groups setup for software the same schema stock groups are setup (Latest, Not Installed, Old). I'm looking to generate a report of all computers that are in any group with old in the name but list only the software that is out of date, not all software on said computer. Any help on this would be appreciated.

Cancel
login to comment
0

So I went ahead and did this the hard way. I built a report using the queries used to create the dynmaic groups. I copied and pasted each criteria into the report so it looks like this:

enter image description here

The report is showing the correct computers but instead of listing the application that is out of date, it is reporting all the installed applications. Any ideas?

Cancel
login to comment

0

I am actually ashamed seeing how easy this turned out to be. Thanks Shane and Lex!

https://youtu.be/PUpf0oJeOYg?t=2278

Cancel
login to comment

Reply