Skip to content

access-wmi-provider-for-configuration-management-using-wql.md

Latest commit

 

History

History
36 lines (27 loc) · 1.52 KB

access-wmi-provider-for-configuration-management-using-wql.md

File metadata and controls

36 lines (27 loc) · 1.52 KB
title Access WMI Provider for Configuration Management using WQL | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology wmi
ms.topic reference
helpviewer_keywords
query language [WMI]
WMI Query Language [WMI]
WQL [WMI]
WMI Provider for Configuration Management, WQL
ms.assetid 26499530-d93b-452b-bbe4-217ef1d11e68
author CarlRabeler
ms.author carlrab
manager craigg

Access WMI Provider for Configuration Management using WQL

This section describes how to execute [!INCLUDEmsCoName] 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 [!INCLUDEssNoVersion] services, network protocols, and aliases.

Querying services using WBEMtest

  1. From the Start menu, click Run, and then enter WBEMtest.

  2. The WBEMtest.exe dialog appears. Click Connect.

  3. In the first text field, type the WMI Provider for Computer Management namespace: root\Microsoft\SqlServer\ComputerManagement11. Click Connect.

  4. Click Query. Type a query that returns the current services running on the local computer: SELECT * FROM SqlService. Click Apply.

  5. Further refine the query by adding WHERE ServiceName = "MSSQLSERVER".