|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 9/17/2008
Posts: 16
Location: Kansas City
|
I need to pull a list of computer names that DO NOT have a certain piece of software installed searching by softwarename?
How do I do this. I tried a modified version of the post below mine but was unable to get the proper results.
|
|
Rank: Administration
Groups: Administration
Joined: 2/10/2005
Posts: 1,388
Location: Hamme Belgium
|
Could you post what your tried and what software you were looking for.
|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 9/17/2008
Posts: 16
Location: Kansas City
|
SELECT DISTINCT TOP 100 PERCENT
tblsoftware.computername
FROM
tblsoftware
WHERE
NOT softwarename = 'Trend Micro Client/Server Security Agent'
This just brings back all of the computer names. There should be about 10-15 that don't have this software.
|
|
Rank: Administration
Groups: Administration
Joined: 2/10/2005
Posts: 1,388
Location: Hamme Belgium
|
should be something like Code:SELECT computername FROM tblcomputer where computername not in (select computername from tblsoftware WHERE softwarename
= 'Trend Micro Client/Server Security Agent')
|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 9/17/2008
Posts: 16
Location: Kansas City
|
Thanks. That helped out.. It was just a tad different but nesting the select was key.
|
|
|
Guest |
