→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
laurentiun
Engaged Sweeper III
Hi!
Please help me to find how to select one or more operating system.
I need to select all windows xp.
i think is something with this: "tblOperatingsystem"

Thank you very much
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Basic report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.OSname, tblOperatingsystem.Description,
tblOperatingsystem.ServicePackMajorVersion As [Current
SP],
tblComputers.Lastseen
From tblOperatingsystem Inner Join
tblComputers On tblOperatingsystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where Web40OSName.OSname Like '%Win XP%'
Order By dbo.tblComputers.Computer

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Basic report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.OSname, tblOperatingsystem.Description,
tblOperatingsystem.ServicePackMajorVersion As [Current
SP],
tblComputers.Lastseen
From tblOperatingsystem Inner Join
tblComputers On tblOperatingsystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername
Where Web40OSName.OSname Like '%Win XP%'
Order By dbo.tblComputers.Computer