Team
Is there any option in FNMS report , where can find Windows OS build details like below
ComputerName Windows Edition Version OS Build
------------ --------------- ------- --------
Windows 10 Enterprise 2004 19041.1083
‎Jul 15, 2021 04:10 AM - edited ‎Jul 15, 2021 04:39 AM
Hi,
Here is an example:
USE FNMSInventory
SELECT
c.ComputerCN
,ho.HardwareName
,hc.Class
,hv.Value
,REVERSE(LEFT(REVERSE(hv.Value),CHARINDEX('.', REVERSE(hv.Value))-1)) Build
,hp.Property
FROM Computer c
JOIN HardwareObject ho
ON c.ComputerID = ho.ComputerID
JOIN HardwareClass hc
ON ho.HardwareClassID = hc.HardwareClassID
AND hc.Class = 'Win32_OperatingSystem'
JOIN HardwareValue hv
ON ho.HardwareObjectID = hv.HardwareObjectID
JOIN HardwareProperty hp
ON hv.HardwarePropertyID = hp.HardwarePropertyID
AND hp.Property = 'Version'
I only tested this with Windows data. You might need to change the class and property filter for Linux/Unix data.
Best regards,
Markward
‎Jul 19, 2021 02:31 AM
Windows OS build information like this isn't reported through the FlexNet Manager Suite UI.
However if you are using the FlexNet inventory agent to gather inventory into FlexNet Manager Suite On-premises and are comfortable working in the SQL Server database, it would be feasible to write a SQL query to get this information from the inventory database. Would that kind of approach be helpful to you?
‎Jul 18, 2021 10:56 PM
‎Jul 19, 2021 12:24 AM
Hi,
Here is an example:
USE FNMSInventory
SELECT
c.ComputerCN
,ho.HardwareName
,hc.Class
,hv.Value
,REVERSE(LEFT(REVERSE(hv.Value),CHARINDEX('.', REVERSE(hv.Value))-1)) Build
,hp.Property
FROM Computer c
JOIN HardwareObject ho
ON c.ComputerID = ho.ComputerID
JOIN HardwareClass hc
ON ho.HardwareClassID = hc.HardwareClassID
AND hc.Class = 'Win32_OperatingSystem'
JOIN HardwareValue hv
ON ho.HardwareObjectID = hv.HardwareObjectID
JOIN HardwareProperty hp
ON hv.HardwarePropertyID = hp.HardwarePropertyID
AND hp.Property = 'Version'
I only tested this with Windows data. You might need to change the class and property filter for Linux/Unix data.
Best regards,
Markward
‎Jul 19, 2021 02:31 AM
‎Jul 19, 2021 02:49 AM
@durgeshsingh - The SQL provided by @mfranz only works against the FNMSInventory database, where the raw data captured by the FlexNet Agent resides. The Corporate Unit assigned to an Inventory device is in the FNMSCompliance database. You will need to run the one query to get the Build Number from the raw FNMSInventory database and join that together with a separate query from the FNMSCompliance database and match on the Computer Name.
‎Jul 19, 2021 07:32 AM
‎Jul 19, 2021 09:56 AM