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 FNMS/ITAM
Workaround
Customers who primarily use Microsoft SCCM as their inventory and compliance data source can use one of the following methods to collect accurate SQL Server edition information:
-
Deploy the FlexNet Inventory Agent
- Install the FlexNet Inventory Agent on the SQL Server hosts.
- The agent will periodically collect and report detailed inventory information, including SQL Server edition data, to FNMS/ITAM.
-
Schedule Remote Inventory Collection
- Configure and run a scheduled FlexNet Inventory Scanner task against the SQL Server hosts.
- Schedule regular inventory collection and import processes to ensure SQL Server edition information remains up to date.
-
Use Agentless (Zero-Footprint) Inventory Collection
- Leverage the Zero-Footprint (Agentless) Inventory capability through the FlexNet Inventory Beacon.
- This method enables inventory collection without installing software agents directly on the target SQL Servers.
Note: SCCM inventory alone may not provide all the SQL Server edition details required for accurate license compliance calculations. Flexera recommends using one of the inventory collection methods above to ensure complete and reliable SQL Server edition discovery.
Related Articles
SQL Server edition not recognized if SQL Server WMI provider is inaccessible 137Number of Views Manage Microsoft SQL Server licenses in Snow License Manager 20Number of Views Importing inventory from SCCM when SCCM has been customized to gather SQL Server edition information may cause temp databa… 7Number of Views Consumption for Microsoft SQL Server licenses with type "Microsoft Server Core" and "Azure Hybrid Benefit / license mobil… 18Number of Views Error 27502.Could Not Connect to Microsoft SQL Server '(local) Using MSOLEDBSQL 19.0 32Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| 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. | |
Revenera Assistant
Case id: 00001065
Activity: Status change: 2 hours ago