Windows Server 2022

Is anyone noticing that Server 2022 is detected as 2019? I suspected it was from a 2019 server that was upgraded but was told that should not be the case. I will dig deeper if no one else has seen this behavior and verify the upgrade status. 

Parents
  • 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 , 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. 

Reply Children
No Data