Hi All,
I saw this thread: VBSCRIPT
call WMI Method on array. I originally asked on the SCCM forum
here, but it was suggested I might get a better answer in a scripting forum. So here I am ;-)
It was an attempt to convert a short PowerShell script to VBScript, so it can be used in specific use cases (these are for me older servers and clients without PowerShell installed / enabled).
For sure I can see why the original script was failing, because when I look at the Powershell it is based upon there is a missing step:
PowerShell
# This is a simpple get of all instances of CCM_SoftwareUpdate from root\CCM\ClientSDK
$MissingUpdates = Get-WmiObject -Class CCM_SoftwareUpdate -Filter ComplianceState=0 -Namespace root\CCM\ClientSDK
# The following is done to do 2 things: Get the missing updates (ComplianceState=0)
# and take the PowerShell object and turn it into an array of WMI objects
$MissingUpdatesReformatted = @($MissingUpdates | ForEach-Object {if($_.ComplianceState -eq 0){[WMI]$_.__PATH}})
# The following is the invoke of the CCM_SoftwareUpdatesManager.InstallUpdates with our found updates
# NOTE: the command in the ArgumentList is intentional, as it flattens the Object into a System.Array for us
# The WMI method requires it in this format.
$InstallReturn = Invoke-WmiMethod -Class CCM_SoftwareUpdatesManager -Name InstallUpdates -ArgumentList (,$MissingUpdatesReformatted) -Namespace root\ccm\clientsdk
VBScript
Set objWMIService = GetObject("winmgmts:\\.\root\ccm\ClientSDK")
Set objInstall = GetObject("winmgmts:\\.\root\ccm\ClientSDK:CCM_SoftwareUpdatesManager")
Set colItems = objWMIService.ExecQuery("SELECT * FROM CCM_SoftwareUpdate WHERE ComplianceState=0")
objInstall.InstallUpdates colItems
The problem is the missing step, before you can execute the objInstall.InstallUpdates you have to convert the Collection into an Array (error returned is "SWbemObjectEx: Generic Failure"),.
The way it is done in PowerShell is to create a new array of WMI objects using:
{[WMI]$_.__PATH}
But I have no idea if this is even possible in VBScript.
So my question -> does anyone know if creating an array of WMI objects within VBScript is possible?
Kind regards,
drH
