cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
feffrey
Engaged Sweeper
I have an all computer report that lists all of our computers. It also picks up our virtual computers for thin clients and lists those. Is there a way I can remove certain rows in the table if the model matches "Virtual Machine"?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
An example of how to do this can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Model
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Model Not Like '%Virtual Machine%'
Order By tblComputers.ComputerUnique

View solution in original post

2 REPLIES 2
feffrey
Engaged Sweeper
Thank you! That works great.
Hemoco
Lansweeper Alumni
An example of how to do this can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Model
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Model Not Like '%Virtual Machine%'
Order By tblComputers.ComputerUnique