Windows Server 2022

What version are you on? I was hoping this would be addressed in a newer release than I am running (2020.2.6) I had hoped the 2022.x version would be fixed. In March I did open a ticket with support, Case # 01025186 and they said that they would log a bug log. If they did, I don't think I have that number. 

It's annoying that it is not available by default, but I do solve the products limitation with custom SWQL. I know you didn't ask but in case some future forum searcher needs it, here are some examples. 

This is the case statement that pulls out Server 2022, and then uses the MachineType for everything else. N is equal to Orion.Nodes 

Case 
    When N.AssetInventory.ServerInformation.OSVersion like '10.0 (Build 20348 Multiprocessor Free)' Then 'Windows 2022 Server' 
    Else N.MachineType
End as OS

This is a full query that pulls Server Counts, I have it used in a table and a Pie chart on a modern dash. 

Select Sum(ServerList.Amount) as Amount, ServerList.OS,
Case 
   When ServerList.OS like 'Windows 2008 Server' Then 'January 13, 2015'
   When ServerList.OS like 'Windows 2008 R2 Server' Then 'January 13, 2015'
   When ServerList.OS like 'Windows 2012 Server' Then 'October 9, 2018'
   When ServerList.OS like 'Windows 2012 R2 Server' Then 'October 9, 2018'
   When ServerList.OS like 'Windows 2016 Server' Then 'January 11, 2022'
   When ServerList.OS like 'Windows 2019 Server' Then 'January 9, 2024'
   When ServerList.OS like 'Windows 2022 Server' Then 'October 13, 2026'
End as [Mainstream Support End Date],

Case 
   When ServerList.OS like 'Windows 2008 Server' Then 'Red'
   When ServerList.OS like 'Windows 2008 R2 Server' Then 'Red'
   When ServerList.OS like 'Windows 2012 Server' Then 'Red'
   When ServerList.OS like 'Windows 2012 R2 Server' Then 'Red'
   When ServerList.OS like 'Windows 2016 Server' Then 'Orange'
   When ServerList.OS like 'Windows 2019 Server' Then 'Green'
   When ServerList.OS like 'Windows 2022 Server' Then 'Green'
End as [Color],

Case 
   When ServerList.OS like 'Windows 2008 Server' Then 1
   When ServerList.OS like 'Windows 2008 R2 Server' Then 2
   When ServerList.OS like 'Windows 2012 Server' Then 3
   When ServerList.OS like 'Windows 2012 R2 Server' Then 4
   When ServerList.OS like 'Windows 2016 Server' Then 5
   When ServerList.OS like 'Windows 2019 Server' Then 6
   When ServerList.OS like 'Windows 2022 Server' Then 7
End as [Order]

From (
SELECT  Count (N.NodeID) as [Amount],
 N.MachineType,
 N.AssetInventory.ServerInformation.OSVersion, 
Case 
    When N.AssetInventory.ServerInformation.OSVersion like '10.0 (Build 20348 Multiprocessor Free)' Then 'Windows 2022 Server' 
    Else N.MachineType
End as OS
FROM Orion.Nodes N 
Where N.IsServer = true and n.MachineType like 'Windows%'
Group By 
N.MachineType,
N.AssetInventory.ServerInformation.OSVersion
) as ServerList
Group By Serverlist.OS
Order by [Order]

Hey jm_sysadmin, I am on the same version. Interesting that they respond as windows 10 - given the direction of Microsoft with server and workstation development, this is not entirely a surprise. Thank you for the swql, I may have to use that as a workaround until an internal update is released. 

Let's hope the newer version has it fixed, 2022.4 is out now and I hope it's there. 

Let's hope the newer version has it fixed, 2022.4 is out now and I hope it's there.