Hello team,
Has anyone worked on a report for software language from FNMS data? We have specific requirements to show OS language and Installed Software language for SCCM desktops/laptops.
I cannot see the data for software language in FNMS. I do see raw data in SCCM that would work.
Thanks
Oct 26, 2022 03:13 PM
Hi @rwiltshire
Any chance to attach a screenshot from SCCM of this OS language you mention , curious to confirm whether it appears as Installer Evidence or WMI Evidence during the FNMS Import process.
Cheers
Kev
Oct 26, 2022 09:15 PM
OS language/locale is in FNMS. Inventory.dbo.ComputerOperatingSystem.OSLanguage.
Add/Remove Programs data in SCCM contains a locale for packages where it exists. Data is not always present or points to a multi-user interface which then uses the OS language setting.
In FNMS, I am only seeing locale for files in FNMS and not installed software.
Oct 27, 2022 11:12 AM
All right, this OS Lang code eg:1033 ...interesting, I searched the entire importProcedure doesn't seem the import does anything from this field. I guess FNMS doesn't use this OS language from inventory manager at the moment. Also even the FileEvidence has the field for language code, but as it's not part of the primary key of the File Evidence, so I guess currently the first exe file we receive with the lang code will take the spot and prevent the same file with other language code being created.
Maybe an enhancement request 🙂
Cheers
Kevin
Oct 27, 2022 06:33 PM
Hi Rob,
For Windows devices, SCCM retrieves the Operating System (OS) language as WMI evidence.
In case you are working in an on-prem FNMS environmnt, you can extract the OS language from the [FNMSCompliance] database using SQL, and build a report based on the output of the following statement:
SELECT
iwe.ComplianceComputerID
, cc.ComputerName
, we.PropertyValue AS [LanguageCode]
FROM [ComplianceComputer] cc
JOIN [InstalledWMIEvidence] iwe
ON iwe.ComplianceComputerID = cc.ComplianceComputerID
JOIN [WMIEvidence] we
ON we.WMIEvidenceID = iwe.WMIEvidenceID
WHERE
we.ClassName = 'Win32_OperatingSystem'
AND we.PropertyName = 'OSLanguage'
The [LanguageCode] column contains the decimal LCID value for the language.
As an example, 1033 means 'English (United States,' (en-us).
Oct 28, 2022 05:57 AM
@rwiltshire - Language is not an attribute that Flexera tracks and manages, either for the OS or Installed Applications.
As @erwinlindemann highlighted, some of this data (such as the OS Language) is captured in the raw data but is not exposed in the UI.
Oct 28, 2022 06:17 AM