I have four reports showing windows: 10 21H2, 10 22H2, 11 21H2, 11 22H2.
To total asset counts for all four reports is less than expected.
Here is a copy of one of the reports I am using and wonder if there is a way to improve the accuracy. Suggestions?
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 10 Enterprise' And
tblassets.Version = '21H2' And tsysassettypes.AssetTypename = 'Windows' And
tblassetcustom.State = 1
Order By OS
