‎11-30-2010 07:15 PM
Solved! Go to Solution.
‎12-05-2010 01:04 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%acrobat%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software2%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software3%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software4%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software5%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software6%')
‎01-19-2011 11:42 PM
‎01-20-2011 09:38 AM
gravity5 wrote:
That last piece of code is something I am looking for, but I don't understand where to enter that code into the interface.
Can you tell me?
Or is there a guide or manual for creating custom reports?
‎12-05-2010 01:04 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%acrobat%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software2%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software3%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software4%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software5%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%software6%')
‎12-03-2010 05:19 PM
‎12-01-2010 11:40 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Not Like '%acrobat%')
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblUsers.Caption, tblUsers.Name
From tblComputers Inner Join
tblUsers On tblComputers.Computername = tblUsers.Computername
‎11-30-2010 10:06 PM
‎11-30-2010 08:47 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now