Skip to content

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

Latest commit

 

History

History
48 lines (36 loc) · 2.38 KB

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

File metadata and controls

48 lines (36 loc) · 2.38 KB
title Modify SQL Server Service Advanced Properties using VBScript | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology wmi
ms.topic reference
dev_langs
VB
helpviewer_keywords
VBScript [WMI]
modifying SQL Server Service properties
WMI Provider for Configuration Management, VBScript
ms.assetid f3c5d981-eaa3-4d34-9b91-37e42636aa81
author CarlRabeler
ms.author carlrab
manager craigg

Modify SQL Server Service Advanced Properties using VBScript

This section describes how to create a VBScript program that lists the version of installed instances of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] that are running on a computer.

The code example lists the instances of [!INCLUDEssNoVersion] running on the computer and its version.

Listing name and version of installed instances of SQL Server

  1. Open a new document in a text editor, such as [!INCLUDEmsCoName] Notepad. Copy the code that follows this procedure and save the file with a .vbs extension. This example is called test.vbs.

  2. Connect to an instance of the WMI Provider for Computer Management with the VBScript GetObject function. This example connects to a remote computer named mpc, but omit the computer name to connect to the local computer: winmgmts:root\Microsoft\SqlServer\ComputerManagement. For more information about the GetObject function, see the VBScript reference.

  3. Use the InstancesOf method to enumerate a list of the services. The services can also be enumerated by using a simple WQL query and an ExecQuery method instead of the InstancesOf method.

  4. Use the ExecQuery method and a WQL query to retrieve the name and version of the installed instances of [!INCLUDEssNoVersion].

  5. Save the file.

  6. Run the script by typing cscript test.vbs at the command prompt.

Example

set wmi = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement12")  
for each prop in wmi.ExecQuery("select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'VERSION'")  
WScript.Echo prop.ServiceName & " " & prop.PropertyName & ": " & prop.PropertyStrValue  
next