Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-14-2011 03:07 PM
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?
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?
Labels:
- Labels:
-
Archive
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2011 01:44 PM
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'
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-17-2011 01:05 PM
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...
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-14-2011 03:10 PM
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?
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?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-14-2011 03:09 PM
You can go into the report builder and change the definition of the report to exclude the machine.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-14-2011 03:54 PM
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..