→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
googoo
Engaged Sweeper III
I'm sure this exists somewhere and I'm just overlooking it...

is there a report that provides each workstation/OS but also includes what version of the OS? Such as Windows 7 Enterprise or Windows 7 Professional? I know you can find Enterprise/Professional within the details for individual pcs...
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
change into this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, RTrim(tblOperatingsystem.Caption + ' ' +
tblOperatingsystem.OtherTypeDescription) as OS, tblOperatingsystem.OSType
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername

View solution in original post

4 REPLIES 4
googoo
Engaged Sweeper III
that did it. Thanks for the quick response.
Hemoco
Lansweeper Alumni
change into this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, RTrim(tblOperatingsystem.Caption + ' ' +
tblOperatingsystem.OtherTypeDescription) as OS, tblOperatingsystem.OSType
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
googoo
Engaged Sweeper III
That's the info I need, but when I try to save the report, I get the attached error.
Hemoco
Lansweeper Alumni
try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, RTrim(tblOperatingsystem.Caption + ' ' +
tblOperatingsystem.OtherTypeDescription), tblOperatingsystem.OSType
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername