Using Lansweeper Classic: Server Report Suggestions Needed

[PapaTuck]

I need suggestions for a server report showing all Windows Server 2022 v21H2.

I thought I could modify the OS string in this desktop report (that works great) but the modification yielded no results,

Here's the working report:

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypeIcon10 As icon,
tblOperatingsystem.Caption As OS,
tblassets.Version,
tblassets.BuildNumber As Build,
tblassets.Firstseen,
tblassets.Lastseen,
tblassets.Lasttried
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblOperatingsystem On
tblassets.AssetID = tblOperatingsystem.AssetID
Where tblOperatingsystem.Caption = 'Microsoft Windows 11 Enterprise' And
tblassets.Version = '23H2' And tsysassettypes.AssetTypename = 'Windows' And
tblassetcustom.State = 1
Order By OS

By changing this code from Where tblOperatingsystem.Caption = 'Microsoft Windows 11 Enterprise' And
tblassets.Version = '23H2' to Where tblOperatingsystem.Caption = 'Windows Sever 2022 Standard' And
tblassets.Version = '21H2' does not work.

Suggestions?

[PapaTuck · Accepted solution]

After posting this request for suggestions, I was able to find a solution. This post should be considered resolved.