→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sinky
Engaged Sweeper
Hi,
i need an SQL Query for all Computers, that have not installed .NET Framework 4.
In case i use "Where <table> Not Like '%framework 4 client%'", i get every software that's not .NET Framework 4.
But i need a list of Computers wich have no .NET

Thanks folks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
This is the full sql:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Like '%framework 4 client%')

View solution in original post

4 REPLIES 4
sinky
Engaged Sweeper
Yeah, thank you very much for your help.
Hemoco
Lansweeper Alumni
This is the full sql:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Like '%framework 4 client%')
Hemoco
Lansweeper Alumni
you need to specify the where clause like this

where tblcomputers.computername not in (select computername from tblsoftware where sofwarename like '%framework 4 client%')
sinky
Engaged Sweeper
Lansweeper wrote:
you need to specify the where clause like this

where tblcomputers.computername not in (select computername from tblsoftware where sofwarename like '%framework 4 client%')


Thanks for your Reply. But your Code doesn't work or me.
Im not very good with SQL 😉