OS version report

[googoo]

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...

[googoo]

that did it. Thanks for the quick response.

[Hemoco · Accepted solution]

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]

That's the info I need, but when I try to save the report, I get the attached error.

[Hemoco]

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