The editions of MS SQL server 2012,2016 are not captured and available in Snow License Manager (SLM)
SLM version 9.18 with Snow Agent version 6.7.1
Powershell script for SQL editon is also included within the Snow Agent package and confirmed to be available on the machines where SQL edition is expected.
Ran the Scan command manually and checked the logs and found below error:
Info; snowagent; win32\scanner.cpp; CScanner::scan_via_powershell; Extracted default powershell key!!
ERROR; snowagent; powershell\powershellmanager.cpp; snow::win32::PowerShellManager::ExecuteScripts; PowerShell process timed out. Terminating PowerShell process...
This indicates that the powershell is timing out and the scripts are not been run to capture the editions.
In the snowagent config file the default timeout value for powershell is:
<Setting key="env.powershell_timeout" value="300000"/>
We increased this value to fix the timeout error. In this scenario doubling the value fixed the issue, but this can be changed depending on the environment:
<Setting key="env.powershell_timeout" value="600000"/>
Powershell timeout value not set high enough.
Related Articles
SQL Server edition not recognized if SQL Server WMI provider is inaccessible 114Number of Views Microsoft SQL server editions can't be determined correctly from SCCM 17Number of Views Specify SQL Server Port During Installation 3Number of Views Importing inventory from SCCM when SCCM has been customized to gather SQL Server edition information may cause temp databa… 4Number of Views SendSoftwareBundle inventory import step reading from ILMT SQL Server database may fail with error: "The given value of ty… 4Number 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. | |
Case id: 00001065
Activity: Status change: 2 hours ago