cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Camielvl
Engaged Sweeper
We have a workstation (WinXP) which has not the latest sp installed, which is good for this workstation.

We want to scan this workstation (WinXP) with lansweeper, but exculde the test for latest service pack.....now it says:

---> OS: Not latest Service Pack XP (1) <--

Is it possible to exclude this test on that workstation?
5 REPLIES 5
Hemoco
Lansweeper Alumni
Go to the report builder, right click on "OS not latest service pack XP", choose "edit report"

Use the following SQL and change 'computer to exclude'

Select Top 1000000 dbo.tblComputers.Computername,                
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
dbo.Web40OSName.OSname, dbo.tblComputers.Description, dbo.tblComputers.SP As
[Current SP], dbo.tblComputers.Lastseen, dbo.Web40OSName.Compimage As icon
From dbo.tblComputers Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
dbo.Web40OSName On dbo.Web40OSName.Computername =
dbo.tblComputers.Computername
Where dbo.tblComputers.ComputerUnique Not Like 'computer to exclude' And
dbo.Web40OSName.OSname = 'Win XP' And dbo.tblComputers.SP <> '3' And
dbo.Web40OSName.OScode = '5.1.2600'
Order By dbo.tblComputers.Computer
Lansweeper wrote:
Go to the report builder, right click on "OS not latest service pack XP", choose "edit report"

Use the following SQL and change 'computer to exclude'

Select Top 1000000 dbo.tblComputers.Computername,                
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
dbo.Web40OSName.OSname, dbo.tblComputers.Description, dbo.tblComputers.SP As
[Current SP], dbo.tblComputers.Lastseen, dbo.Web40OSName.Compimage As icon
From dbo.tblComputers Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
dbo.Web40OSName On dbo.Web40OSName.Computername =
dbo.tblComputers.Computername
Where dbo.tblComputers.ComputerUnique Not Like 'computer to exclude' And
dbo.Web40OSName.OSname = 'Win XP' And dbo.tblComputers.SP <> '3' And
dbo.Web40OSName.OScode = '5.1.2600'
Order By dbo.tblComputers.Computer



Thanks this works 😉 but not really easy to do for a nondatabase guy.

Whats the use of filter builder then? because it doesn't save my filter...
Camielvl
Engaged Sweeper
We have a workstation (WinXP) which has not the latest sp installed, which is good for this workstation.

We want to scan this workstation (WinXP) with lansweeper, but exculde the test for latest service pack.....now it says:

---> OS: Not latest Service Pack XP (1) <--

Is it possible to exclude this test on that workstation?
Hemoco
Lansweeper Alumni
You can go into the report builder and change the definition of the report to exclude the machine.
Lansweeper wrote:
You can go into the report builder and change the definition of the report to exclude the machine.


Oke thanks, I created in filter builder a rule which excludes the machine, I see the machine disappear which is good, i saved the file on the server (premium version).

Somehow the filterrule does not stay active and is gone. How can I let the rule stay active..