Hi,
Is there a way to determine the build number or version number of the Operating systems?
Thanks
Tom
‎Oct 30, 2019 06:04 PM
This level of detail about the OS is not maintained in FlexNet Manager at the present time. FNMS is focused on License Management, so from an OS level, information will be normalized to the level of how it is licensed. For example, we will show that "Windows 10 Enterprise" is installed.
Flexera has a complementary "Data Platform" product that can normalize software at a more detailed level than FNMS does to provide additional information such as End of Life information and Software Vulnerability information.
‎Oct 31, 2019 09:25 AM
Thanks for your Post, we also miss this information about the build version and it would be good if there is a field for it??
beste Regards
Roman
‎Oct 31, 2019 07:27 AM
If you are On Prem, you can query the database directly. looking at the ImportedInstallerEvidencee
you can link to imported computers to know which machine is which.
SELECT distinct
IC.[ComplianceConnectionID]
,IC.[ExternalID]
,IC.[ComputerName]
,IC.[OperatingSystem]
,IC.[IPAddress]
,IC.[InventoryDate]
,IC.[HardwareInventoryDate]
,IC.[ServicesInventoryDate]
,IIE.*
/* ,IFE.FileName
,IFE.FilePath
,IFE.FileSize
*/
FROM [FNMP].[dbo].[ImportedComputer_MT] IC
join ImportedInstalledInstallerEvidence_MT IIIE
on (IIIE.ComplianceConnectionID = IC.ComplianceConnectionID) and (IIIE.ExternalComputerID = IC.ExternalID)
join ImportedInstallerEvidence_MT IIE
on (IIE.ComplianceConnectionID = IIIE.ComplianceConnectionID) and (IIE.ExternalInstallerID = IIIE.ExternalInstallerEvidenceID)
where IIE.DisplayName like '%Windows 10%'
‎Oct 31, 2019 09:40 AM
‎Oct 31, 2019 09:33 PM
Hi,
If your DB team has access, I assume you're running FNMS on prem. What you are looking for, requires some effort, but is possible:
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 = 'BuildNumber'
From there you should be able to include the custom field in your normal WebUI filtering, reports and management views.
The integration process can scale and you might not want to start all over again in a month or so. So if you're planning on going that route, I suggest you think about any other data you want to add as well.
Best regards,
Markward
‎Nov 01, 2019 04:39 AM
@romanmensch - If you read the prior post from @mfranz on this post, FlexNet Manager does not capture the OS Build Number. We do not extract this with our adapters when reading from SCCM and the FlexNet Manager Agent does not capture this either.
However, mfranz has posted a suggestion on how FNMS can be customized to capture this attribute from the Windows WMI and bring it into FlexNet Manager.
Kirk
‎Nov 20, 2019 06:12 AM
‎Nov 20, 2019 10:18 AM
where can I configure the wmitrack.ini ?
‎Nov 20, 2019 10:23 AM
Hi,
wmitrack.ini is a component of the Flexera agent that are installed on servers/workstation.
You can find them under the following path:
c:\program files (x86)\managesoft\tracker
This is the standard installation, if you installed the agent on other drive please go there.
After you modify the ini file, you should run again the inventory for that server.
‎Nov 21, 2019 02:27 AM
Thanks for this Information. I see the correct Value "Version" in the wmitrack.ini File. So it is there and I do not have to complete it.
And the NDI File ist correctly send to the Server with the Value "Version" in the File.
Do you know where i can find this in the Database FNMS Compliance?
<Hardware Class="Win32_OperatingSystem" Name="Microsoft Windows 10 Education|C:\WINDOWS|\Device\Harddisk0\Partition3" Evidence="WMI">
<Property Name="Version" Value="10.0.18362"/>
Thanks for Reply. Best Regards Roman
‎Nov 21, 2019 07:06 AM
I don't think you will find this value in the FNMS compliance database, but you would find it in the inventory database. Here is a SQL query that can be run against the inventory database to get you started:
SELECT c.ComputerCN, Version = hv.Value
FROM dbo.Computer c
JOIN dbo.HardwareObject AS ho ON ho.ComputerID = c.ComputerID
JOIN dbo.HardwareClass AS hc ON hc.HardwareClassID = ho.HardwareClassID AND hc.Class = 'Win32_OperatingSystem'
JOIN dbo.HardwareValue AS hv ON hv.HardwareObjectID = ho.HardwareObjectID
JOIN dbo.HardwareProperty AS hp ON hp.HardwarePropertyID = hv.HardwarePropertyID AND hp.Property = 'Version'
‎Nov 21, 2019 09:31 PM
Thank you so I receive the desired VIEW and can implement this in the Beacon / BA
That's great an thank you very much.
‎Nov 26, 2019 09:23 AM
This level of detail about the OS is not maintained in FlexNet Manager at the present time. FNMS is focused on License Management, so from an OS level, information will be normalized to the level of how it is licensed. For example, we will show that "Windows 10 Enterprise" is installed.
Flexera has a complementary "Data Platform" product that can normalize software at a more detailed level than FNMS does to provide additional information such as End of Life information and Software Vulnerability information.
‎Oct 31, 2019 09:25 AM