‎01-14-2011 03:07 PM
‎01-15-2011 01:44 PM
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
‎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
‎01-14-2011 03:10 PM
‎01-14-2011 03:09 PM
‎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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now