Help Desk and PC Inventory Software by Gritware   Gritware Support Forums
Gritware Support Forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Canadianmade

Member
Registered:
Posts: 65
Reply with quote  #1 
Hey, I'm trying to create a report that will show computers that DON'T have a specific piece of software installed but I can get my head wrapped around how to do it?

Specifically I would create the report so it will show the computers that don't have Trend installed.
thoese

Moderator
Registered:
Posts: 486
Reply with quote  #2 
Create a new report in Web Tracks and choose the custom SQL option.  Then paste in the following for the SQL...

SELECT compTag, compUserID, compIPAddr FROM Computer WHERE compTag NOT IN (SELECT compTag FROM SftLicense WHERE SftProduct LIKE '%Trend%')

Thanks,

__________________
Todd @ Gritware
Other resources
Gritware.com
Knowledge Base
Web Tracks Help
Canadianmade

Member
Registered:
Posts: 65
Reply with quote  #3 
Awesome! works great, thanks so much.............again!
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.