A new Flexera Community experience is coming on November 18th, click here for more information.
Is there a way to see what version of OS is installed on windows based devices?
Apr 13, 2020 09:38 AM
Look at the "Operating System" property on inventory device records to see the OS version and edition:
Apr 15, 2020 12:20 AM
I could have worded my question a little better. I am looking for the release/update version. Is it windows 1809 or 1903. Does Flexera store that data anywhere as I know it cane be obtained from SCCM?
Apr 15, 2020 06:56 AM
The Windows 10 subversion (1809, 1903, etc.) may be imported from SCCM (or other inventory sources discovering it) and stored in the inventory database but as it's not relevant for software licensing it doesn't seem to be imported into the compliance database.
Maybe you want to elaborate on your use case(s) where you need it as then the community members may be able to provide better guidance?
Thanks,
Apr 21, 2020 01:29 AM
We use FNMS for hardware asset management as well. We have teams that use this data to find devices and are currently working on a refresh project. The Subversion is one metric they are looking at and it would be nice if they had one source to get all the information instead of having to use both FNMS and SCCM.
Apr 27, 2020 02:52 PM
Please raise an enhancement request for it and please make sure to supply your specific use case(s) and associated business value for this feature to be evaluated and prioritized.
Thanks,
Apr 28, 2020 05:45 AM
Hi,
Assuming FNMS on prem.
USE FNMSInventory
SELECT
c.ComputerCN
,hc.Class
,hp.Property
,hv.Value
FROM Computer c
JOIN HardwareObject ho
ON c.ComputerID = ho.ComputerID
JOIN HardwareClass hc
ON ho.HardwareClassID = hc.HardwareClassID
JOIN HardwareValue hv
ON ho.HardwareObjectID = hv.HardwareObjectID
JOIN HardwareProperty hp
ON hv.HardwarePropertyID = hp.HardwarePropertyID
WHERE hc.Class = 'Win32_OperatingSystem'
AND hp.Property = 'Version'
You'll still have to do a translation from the build version (e.g. 18363) to the main version (e.g. 1909).
Here is a list https://en.wikipedia.org/wiki/Windows_10_version_history
You could populate a custom field with this data using a business import.
Best regards,
Markward
Apr 28, 2020 06:59 AM
On the contrary, there are licensing implications. Once a specific release goes end of life, Microsoft ends support for combinations. They ended Windows 7 support of O365 at EOL for Windows 7. We actually have a Windows 10 release coming up on end of life and it will impact licensing.
Apr 28, 2020 08:56 AM
User | Count |
---|---|
8 | |
7 | |
3 | |
3 |