Access WMI Provider for Configuration Management using WQL
Applies to: SQL Server
This section describes how to execute Microsoft Windows Management Instrumentation Query Language (WQL) statements against the WMI Provider for Computer Management.
The example uses a WQL editor, WBEMtest.exe, to run WQL queries against the WMI Provider to enumerate SQL Server services, network protocols, and aliases.
Querying services using WBEMtest
From the Start menu, click Run, and then enter WBEMtest.
The WBEMtest.exe dialog appears. Click Connect.
In the first text field, type the WMI Provider for Computer Management namespace: root\Microsoft\SqlServer\ComputerManagement11. Click Connect.
Click Query. Type a query that returns the current services running on the local computer: SELECT * FROM SqlService. Click Apply.
Further refine the query by adding WHERE ServiceName = "MSSQLSERVER".
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for