Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
WMI
 | |
|
- !Microsofts WMI Object Browser!
- !WMI Reference!
- !WMI Security!
- Add Key Qualifier
- Backup Event Log
- Best Way to Read Event Log via WMI
- Check if WMI is Installed
- Clear Event Log via WMI
- Close All but One Instance
- Detect If monitor is in Standby Mode
- Detect Resume From Standby
- Detect Standby or Hibernation Event
- Detecting Local Network Connectivity and Speed
- Determine Laptop or Destop System Enclosure
- Determine Machine Type
- Determining If a Machine is a Domain Controller
- Directory Watcher
- Display Refresh Rate
- Error 1261 on ConnectServer line
- Extract SN from Bios using WMI
- fileSizeEX returns 0 for the Pagefile.sys file
- Get Asset Tag From Dell Computers
- Get Daylight Savings Time
- Get Default Printer
- Get ipv6 IP Address via Host Name
- Get Owner of a Process
- Get Physical Memory
- Get Process List via WMI
- Get Remote Logged in User
- Get Specific Events
- Get Status of Network Adapter
- Get Win32_DiskDrive Data with DeviceID
- Install MSI apps
- Is Computer WMI Enabled UDF
- Last Reboot Time
- List Active Network Adapters
- List All Monitors
- List Available Screen Resolutions
- List Installed Modems
- List Namespaces
- List Processes on a Remote Computer
- List Scheduled Tasks
- Manufacturer Model and Serial from WMI
- Modify DNS Entries
- Monitor Events
- Obtain the Name of the Domain to which the Computer Belongs
- PCMCIA Card Detection
- Physical Memory Inspection
- Ping Status
- Remote Number of Drives
- Remote Process UDFs
- Run an Application on a Remote Computer
- Search Eventlog Example
- Set Adapter Speed Duplex
- SetDNSSuffixSearchOrder MisMatched Type Error
- System Restore Point
- Total CPU Usage
- Using WMI List Applications
- Win32_EncryptableVolume
- Win32_SerialPort Information via WMI
- Windows NT Schedule Service - AT
- WMI - Processor Info
- WMI and Arrays
- WMI and Get IPAddress Property
- WMI and Remote Interactive Desktop Scripts
- WMI and WinPE
- WMI causing LLSMGR to start
- WMI ExecQuery
- WMI Get Fan Speed
- WMI Get MAC Address and NIC info
- WMI hangs
- WMI ObjectOpen Problem on Windows 95
- WMI Query Paths Need Double Backslashes
- WMI Related Resources
- WMI Scriptomatic
- wntGetCon using WMI
- WQL LIKE Operator
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
WQL LIKE Operator
Question:
Could you look at my code below and make sure that it is correct, I am trying to do a "LIKE" for the name of the service in my ExecQuery and keep receiving errors (Not a valide OLE object):
strComputer = "itportal"
objWMIService = GetObject(StrCat("winmgmts:\\" , strComputer , "\root\cimv2"))
colServiceList = objWMIService.ExecQuery("Select * from Win32_Service where Name LIKE 'TSM%%' ")
ForEach objService in colServiceList
Message("Status", StrCat(objService.DisplayName, " ", objService.State))
Next
colServiceList = 0
objWMIService = 0
exit
I am not sure if I am using the LIKE portion correctly, since a "%" is required after the service name to perform the query.
Appreciate your help.
I am using version 2005C
The error I am receiving is:
3131: OleExecute: Not a valid OLE objectfor the line:
Message("Status", StrCat(objService.DisplayName, " ", objService.State))
There is nothing in the wwwbatch.ini file. I am going against a remote system and am able to receive return information if I have the exact service name in the query.
I did test using my local machine versus different remote systems and ONLY on the remote systems am I receiving the error. It seems that a remote system is not providing the object information back when using the LIKE comparison operator.
I have tried different 3 letter constructs and different remote systems, and always get the same error.
Answer:
What windows platform is this remote computer. Apparently the WMI WQL syntax on pre-XP machines does not support the LIKE operator...http://msdn.microsoft.com/library/en-us/wmisdk/wmi/like_operator.asp?frame=true
The remote machine must be windows XP or 2003 in order to support the use of the LIKE operator.
AS an alternative you could just query all of the services then use StrIndexWild to search each of the returned service string for the value you are looking for...
Article ID: W17326
File Created: 2007:07:03:14:29:30
Last Updated: 2007:07:03:14:29:30