I an trying to generate a report for all PCs without a particular software. The problem is that when i generate the report for all PCs with the software, i get the correct report, but for report for all the PCs without the software, the report generator is giving duplicate entries...(the report shows entries upto 35000 records - most of them duplicate)

Just change the name of the app in the sql to whatever you need. The best way would be to find a machine in the inventory that has that app installed and copy the name and paste it into the sql in order to make sure the name you use is spelled exactly as it should be.

3 Replies

Just change the name of the app in the sql to whatever you need. The best way would be to find a machine in the inventory that has that app installed and copy the name and paste it into the sql in order to make sure the name you use is spelled exactly as it should be.