![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
\n <\/P> \n
Hey, Scripting Guy! The examples produced from the “Scriptomatic Version 2.0 by The Microsoft Scripting Guys” for the entries Win32_ServiceSpecification<\/B> and Win32_ServiceControl<\/B> both return error 0x80041002 under Windows Server 2003. I can’t find another WMI class that exposes the recovery options for services, which is something I need to be able to scrape off 100+ servers for auditing. Is that WMI class missing or broken possibly? I can run WMI scripts using just about any other WMI class except those two. What\u2019s up?<\/P>\n
– MP<\/P>![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
\n
Hi MP,<\/P>\n
Both of the Win32_ServiceSpecification<\/B> and Win32_ServiceControl<\/B> WMI classes are supplied by the MSI provider. We just tested it on our Windows XP computer, and they work fine. There is nothing magic about Scriptomatic. If the class does not work via a script generated by Scriptomatic, you probably have a problem with WMI on your computer. You will find some resources<\/A> on the Script Center to assist you in troubleshooting this issue. <\/P>\n Because you are talking about Windows Server 2003, you need to realize that the MSI provider is not installed by default. To install the MSI provider on your Windows Server 2003 machine, you go into Add or Remove Programs<\/B>, and click Add\/Remove Windows Components<\/B>. The Windows Components Wizard appears. Scroll down the list of components until you see Management and Monitoring Tools<\/B>, and then click Details<\/B>. In the Management and Monitoring Tools dialog box, choose WMI Windows Installer Provider<\/B>. It is a very small installation. Because you say you have over 100 servers, you can use sysocmgr and script the installation. This KB article<\/A> talks about using sysocmgr to install optional components. If you follow the article, you will need to know the component to add. This line of code placed in your file will do the trick:<\/P> This script will tell you if the MSI provider is installed:<\/P>\n FindMSIProvider.vbs<\/B><\/P>\n For Each objItem In colItems\nWith objItem\nIf InStr(1,.name, strProv,1) then\n WScript.echo .Name, .clsid _\n & vbcrlf & “hostingModel: ” & .hostingModel<\/p>\n End If\nEnd with\nNext\n<\/PRE><\/DIV>\n <\/P> Hey, Scripting Guy! I am try to create a script that will ask for a new IP address and Subnet mask, and then assign those values to statically configure the IP settings for the Local Area Network. I have looked at this article<\/A> for changing the IP address and subnet mask. But this script attempts to change all network adapters. Any ideas?<\/P>\n – DD<\/P> Hi DD,<\/P>\n We have lots of ideas about this. You first need to identify which network adapter you wish to change. The problem is that a “normal” computer can have as many as a dozen network adapters\u2014a pptp adapter, a ppoe adapter, a connection manager adapter, a Bluetooth adapter\u2014as well as the standard ethernet card and wireless network adapter. The problem comes into play when attempting to find the real network card. As seen in the following image, there are multiple network adapters:<\/P> <\/P>\n In the script you mentioned<\/A>, it uses Where IPEnabled=True<\/B> to attempt to limit the network cards that are only enabled with an IP address. On many computers this approach will work. In fact, this works on my laptop as seen here (using Windows ):<\/P> DHCPEnabled : True\nIPAddress : {192.168.1.97, fe80::e9db:821c:506c:7e24}\nDefaultIPGateway : {192.168.1.254}\nDNSDomain : nwtraders.com\nServiceName : e1express\nDescription : Intel(R) 82566MM Gigabit Network Connection\nIndex : 4\n<\/PRE>\n Why, you may ask, does this query work? Well it is because I disable all network adapters I am not using for security reasons. I had a scary experience a long time ago in an airplane when I was working and suddenly an icon popped up that said, “Now connected to Dave\u2019s laptop.” I opened the connection, and sure enough I could browse Dave\u2019s laptop. At that point in life, I started disabling all network adapters I was not using. Plus it simplifies things like we are trying to do today!<\/P>\n All we really need to do is to find some property that will allow us to differentiate one specific network adapter from all the other possible network adapters. To do this, let\u2019s take a look at the properties of the WIN32_NetworkAdapterConfiguration<\/B> WMI class. They are seen here:<\/P> As you can see, there is a lot to choose from. Obviously, the MACAddress<\/B> property would not be good to use, unless you had a listing of all the MACaddresses on your network. The DHCPServer<\/B> property would be an interesting property to use if for instance you were getting ready to decommission a particular server. I have used the index<\/B> property and the caption<\/B> property for this purpose as well. For instance, if all your computers have the same kind of network card, the use of the caption<\/B> property makes sense because you can filter on the maker\u2019s<\/B> name. <\/P>\n The WIN32_NetworkAdapter<\/B> class has a netConnectionID<\/B> property. This property is the same as the name<\/B> property that displays “Local Area Connection.” You can use the netConnectionID<\/B> property to find the index or the DeviceID<\/B> property of your network adapter. You can then use this to allow you to connect back to your specific network adapter. You can do this via two separate WMI queries, or you can use the association class: WIN32_NetworkAdapterSetting<\/B>. This WMI class relates the WIN32_NetworkAdapter<\/B> class with the WIN32_NetworkAdapterConfiguration<\/B> class. The GetLocalAreaConnectionIP.ps1<\/B> script illustrates this technique. <\/P>\n GetLocalAreaConnectionIP.ps1<\/B><\/P> This article<\/A> is part of a nine-part series about the above concepts, using VBScript in the examples.<\/P> <\/P> Hey, Scripting Guy! Is it possible to write a script that will show the version of Office on my computer?<\/P>\n – LM<\/P> Hi LM,<\/P>\n Of course. We can use the WIN32_Product<\/B> WMI class, which is provided by the MSI provider. Using Windows PowerShell, your script might look something like this:<\/P>\n GetOfficeVersion.ps1<\/P> Using VBScript, the script would be a bit longer:<\/P>\n GetOfficeVersion.vbs<\/B><\/P>\n <\/P> Hey, Scripting Guy! Sorry to bother you. I hope you can help me. I am following your instructions about reading text files via ADO. I am working in a tab-delimited file in Visual Basic 2008. I modified the text format in my registry to tab delimited. I also created a schema.ini file in the same folder of my txt files.The schema defines the datatype of each column, but one column that is supposed to be considered as text, the ADO column, is not importing the data. (When I check the column 3 value, there is nothing). This is the schema:<\/P> Col3 is a mix. It can be numeric or text or alphanumeric. So in the schema its datatype is text, but it seems that ADO does not care. I am a little frustrated after an hour of trying different approaches. Any help will be really appreciated.<\/P>\n – JM<\/P> Hi JM,<\/P>\nWbemMSI = On<\/PRE>\n
strComputer = “.”\nwmiNS = “\\root\\cimv2”\nstrProv = “MSI”\nSet objWMIService = _\n GetObject (“winmgmts:\\\\” & strComputer & wmiNS) Set colItems = \nobjWMIService.InstancesOf(“__Win32Provider”)<\/p>\n
<\/DIV>\n![\"Top](\"http:\/\/www.microsoft.com\/library\/gallery\/templates\/MNP2.Common\/images\/arrow_px_up.gif\"){kind=icon}
<\/A>Top of page<\/A><\/DIV><\/A>\nHow Can I Create and Assign a New IP Address and Subnet Mask to Statically Configure the IP Settings for the Local Area Network?<\/H2>\n
\n \n![\"Image](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/hsg\/2009\/april\/hey0403\/hsg-04-03-09-01.jpg\")
\nPS C:\\> Get-WmiObject win32_networkadapterconfiguration -filter “ipenabled = $true”<\/p>\n
ArpAlwaysSourceRoute\nArpUseEtherSNAP\nCaption\nDatabasePath\nDeadGWDetectEnabled\nDefaultIPGateway\nDefaultTOS\nDefaultTTL\nDescription\nDHCPEnabled\nDHCPLeaseExpires\nDHCPLeaseObtained\nDHCPServer\nDNSDomain\nDNSDomainSuffixSearchOrder\nDNSEnabledForWINSResolution\nDNSHostName\nDNSServerSearchOrder\nDomainDNSRegistrationEnabled\nForwardBufferMemory\nFullDNSRegistrationEnabled\nGatewayCostMetric\nIGMPLevel\nIndex\nInterfaceIndex\nIPAddress\nIPConnectionMetric\nIPEnabled\nIPFilterSecurityEnabled\nIPPortSecurityEnabled\nIPSecPermitIPProtocols\nIPSecPermitTCPPorts\nIPSecPermitUDPPorts\nIPSubnet\nIPUseZeroBroadcast\nIPXAddress\nIPXEnabled\nIPXFrameType\nIPXMediaType\nIPXNetworkNumber\nIPXVirtualNetNumber\nKeepAliveInterval\nKeepAliveTime\nMACAddress\nMTU\nNumForwardPackets\nPMTUBHDetectEnabled\nPMTUDiscoveryEnabled\nServiceName\nSettingID\nTcpipNetbiosOptions\nTcpMaxConnectRetransmissions\nTcpMaxDataRetransmissions\nTcpNumConnections\nTcpUseRFC1122UrgentPointer\nTcpWindowSize\nWINSEnableLMHostsLookup\nWINSHostLookupFile\nWINSPrimaryServer\nWINSScopeID\nWINSSecondaryServer\n<\/PRE>\n
\nGet-WmiObject -Class win32_NetworkAdapterSetting | \nForeach-object {\n If( ([wmi]$_.element).netConnectionID -eq “local area connection”)\n {\n “Adapter: $($_.setting)”\n [wmi]$_.setting\n [wmi]$_.element\n } #end if\n } #end foreach\n<\/PRE>\n<\/A>Top of page<\/A><\/DIV><\/A>\nHow Can I Tell Which Version of Microsoft Office Is on My Computer?<\/H2>\n
\n \nGet-WmiObject -class win32_product -filter “name like ‘%office%'”<\/PRE>\n
wmiquery = “Select * from Win32_Product where name like ‘%office%'”\nSet objWmi = GetObject(“Winmgmts:”)\nSet colItems = objWmi.execquery(wmiQuery) \nFor Each item In colItems \nWScript.Echo item.name \nNext\n<\/PRE><\/DIV>\n
<\/A>Top of page<\/A><\/DIV><\/A>\nHow Can I Read Text Files Via ADO?<\/H2>\n
\n[HCSR879C_092_20081103.txt]\nFormat=TabDelimited\nCol1 = ProgramName text\nCol2 = ProgramCode text\nCol3 = LocationCode text\nCol4 = SmstrHrsCrdt double\nCol5 = WrkFrcContEdu double\nCol6 = NonFundContEdu double\nCol7 = AdultLitcy double\nCol8 = UndupEnroll double\n<\/PRE>\n
\n