→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
poweld1
Champion Sweeper
Can I have some help adding in the operating system version for the following report.

Select Top 1000000 upgrade_tblComputers.Computername,
upgrade_tblComputers.ComputerUnique,
upgrade_web40AllIPLocations.IPLocation,
upgrade_tblComputers.Username,
upgrade_tblComputers.LastknownIP,
upgrade_tblSoftware.Lastchanged
From upgrade_tblSoftware
Inner Join upgrade_tblComputers On upgrade_tblSoftware.ComputerName =
upgrade_tblComputers.Computername
Left Join upgrade_web40AllIPLocations
On upgrade_web40AllIPLocations.Computername =
upgrade_tblComputers.Computername
Where (upgrade_tblSoftware.softwareName = 'BDE 5.11 for SIMS Workstation Setup')
Or
(upgrade_tblSoftware.softwareName = 'SIMS Infrastructure')
Group By upgrade_tblComputers.Computername,
upgrade_tblComputers.ComputerUnique,
upgrade_web40AllIPLocations.IPLocation,
upgrade_tblComputers.Username,
upgrade_tblComputers.LastknownIP,
upgrade_tblSoftware.Lastchanged,
upgrade_tblSoftware.softwareVersion,
upgrade_tblSoftware.SoftwarePublisher
Order By upgrade_web40AllIPLocations.IPLocation,
upgrade_tblComputers.ComputerUnique,
Count(upgrade_tblSoftware.ComputerName) Desc
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You need to add upgrade_tblOperatingsystem.Caption to your report. Link upgrade_tblOperatingsystem to upgrade_tblComputers on the Computername field.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
You need to add upgrade_tblOperatingsystem.Caption to your report. Link upgrade_tblOperatingsystem to upgrade_tblComputers on the Computername field.