Loading
search-img
Title
Microsoft SQL server editions can't be determined correctly from SCCM

Summary

Microsoft SQL server editions can't be determined correctly if the compliance source is SCCM.

Synopsis

Microsoft SQL server editions (Enterprise, professional, standard) can't be determined correctly if the compliance source is SCCM.

Discussion

This is because SQL server version information is stored as WMI evidence on the servers, SCCM does not collect WMI evidence so this information will not be imported into FNMP.


Workaround

A SQL plugin exists for more recent versions of FNMP (8.4 and later). This plug in will run as part of Flexera Inventory Manager agent (formerly known as Deployment Manager) or part of the remote inventory task.
Customers who primarily use SCCM as compliance source can do the followings to gather correct SQL server edition information:
  • Install Inventory Manager agents on the SQL servers and the Inventory Manager agents will report inventory periodically
  • Run a scheduled remote inventory task (agentless) on the SQL servers and schedule a task to import the inventory periodically
  • Add ManageSoft as a compliance data source on FNMP, and the comprehensive inventories of the SQL servers will be imported to FNMP from Inventory Manager database.

Additional Information

If you have a customised SCCM installation that does collect the edition data for SQL Server then a custom SCCM inventory adapter can be created to import this information (there may be a chargeable service) which is an option if you do not want to install Inventory Manager.
Was this helpful?
Support Hub
Create a case with Support
0/255
Upload Attachment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to cancel the case creation?

Are you sure you want to close this case

Get Hotline support
Products Region Phone Numbers
FlexNet Operations
FlexNet Embedded
FlexNet Publisher
FlexNet Connect
FlexNet Code Insight
InstallAnywhere
InstallShield 		North America  * +1 630-332-2513 (toll)
+1 877-279-2853 (toll-free in North America)
Europe  * +44 1925 944367 (toll)
+44 800 047 8642 (toll-free in Europe)
Japan  * +81 3-4540-5335 (select option 2)
Australia  * +61 3 9895 2177
+61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics)
Compliance Intelligence 		Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.
Book an Appointment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)
+1.800.374.4353
CONTACT US REVENERA.COM FLEXERA.com
© 2026 Flexera Software. All Rights Reserved.
Privacy policy Terms and conditions Flexera Community Contact Us
Loading
Microsoft SQL server editions can't be determined correctly from SCCM