SQL Server build/release details in Inventory DB and Compliance DB
If you want to know the details about what build version/release of SQL is on each device with SQL installed, you can confirm it from Inventory DB (if the inventory source is Flexera) or Compliance DB
• Inventory DB: the RawVersion field in the SoftwareDetails table
• Compliance DB: FNMS does import RAW version for evidence from SQL server components. You can get the information with the below query
– Use ComplianaceDatabase select * from ImportedInstalledInstallerEvidence as iiie JOIN ImportedInstallerEvidence as ie ON iiie.ComplianceConnectionID= ie.ComplianceConnectionID and iiie.ExternalInstallerEvidenceID=ie.ExternalInstallerID where ie.DisplayName like '%SQL%' and ie.Evidence='MSI'