SCCM Database - OS Family Names

[ldoodle]

Hi,

 

Does the SCCM database have a VIEW, FUNCTION or TABLE I can get the 'family' names from? I.e.:

 

Microsoft Windows Server 2019 Datacenter = Windows Server 2019

Microsoft Windows Server 2019 Standard = Windows Server 2019

Microsoft Windows Server 2016 Datacenter = Windows Server 2016

Microsoft Windows Server 2016 Standard = Windows Server 2016

Microsoft Windows 10 Pro Datacenter = Windows 10

Microsoft Windows 10 Enterprise = Windows 10

 

etc.?

 

I'm currently do this with a CTE but means manual upkeep for additional versions in the future.

 

Thanks