SQL Server build/release details in Inventory DB and Compliance DB

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

SoftwareDetails.png

 

• 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'

Query result.png

Labels (2)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
2 of 2
Last update:
‎Dec 24, 2020 02:43 AM
Updated by:
 
Contributors