contact@activexperts.com +31748507807

ActiveXperts.com » Administration » Scripts » WMI » vbscript sample

Win32_ODBCSourceAttribute vbscript sample code | ActiveXperts Network Monitor

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_ODBCSourceAttribute WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

Description

The Win32_ODBCSourceAttribute class represents the information regarding an ODBC source and the attributes that must be set for installation.

Sample Code

On Error Resume Next
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_ODBCSourceAttribute",,48)
For Each objItem in colItems
    Wscript.Echo "Attribute: " & objItem.Attribute
    Wscript.Echo "Caption: " & objItem.Caption
    Wscript.Echo "DataSource: " & objItem.DataSource
    Wscript.Echo "Description: " & objItem.Description
    Wscript.Echo "SettingID: " & objItem.SettingID
    Wscript.Echo "Value: " & objItem.Value
Next
M