How to Display Connection Status
Retrieving the status of a connection is a common task that you might want to perform with WMI.
To display the status of a connection
Connect to the namespace using GetObject with a moniker in the parameter.
Enumerate MsSnaStatus_Connections using ExecQuery.
Display error codes if necessary.
The following example shows how to display the status of all the connections defined in Host Integration Server (HIS):
Private Function DisplayConnectionStatus ()
'Variables
Dim objWMIService, colItems, iCounter, objItem, _
strReport
'Connect to the namespace
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\microsofthis")
'Enumerate the Class
Set colItems = objWMIService.ExecQuery("Select * from MSSnaStatus_Connection")
iCounter = colItems.Count
if Err.Number = 0 then
For Each objItem in colItems
strReport = "Connection " & objItem.Name & " status is " & objItem.StatusText
Wscript.Echo strReport
strReport = ""
Next
else
Wscript.Echo "An error occurred enumerating instances for status " & Err.Number & " " & Err.Description
End If
DisplayConnectionStatus = true
End Function