durgeshsing
Frequent contributor

Report to get Windows OS Build detail

Jump to solution

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

0 Kudos
1 Solution

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

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

6 Replies
ChrisG
Community Manager Community Manager
Community Manager

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?

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
durgeshsing
Frequent contributor
Please share sql query. We are using onprem version & we can run sql query.
0 Kudos

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

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

durgeshsing
Frequent contributor
can you join corporate unit & domain data as well.
0 Kudos

@durgeshsing - 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.

durgeshsing
Frequent contributor
i will try & confirm back if get success.
0 Kudos