Home > wmi > WMIC mystery - why is this query invalid?

WMIC mystery - why is this query invalid?

December 21Hits:1
Advertisement

Why is this an invalid query?

wmic service where 'caption like "%documentum%"' get name, caption    Node - PE95AOECM   ERROR:   Description = Invalid query   

This is the expected output:

Caption                                 Name   EMC Documentum Thumbnail Server         DctmThumbnailServer   Documentum Docbroker Service Docbroker  DmDocbroker   Documentum Java Method Server           DmMethodServer   Documentum Docbase Service KxKDOC_DEV   DmServerKxKDOC_DEV   Documentum Docbase Service KxKTAX_DEV   DmServerKxKTAX_DEV   Documentum Docbase Service KxK_Dev      DmServerKxK_Dev   Documentum Docbase Service KxK_Dev_HRP  DmServerKxK_Dev_HRP   Documentum Docbase Service KxK_Dev_TAX  DmServerKxK_Dev_TAX   

If I modify the query slightly I do in fact get a valid response similar to the above:

removed the first %

wmic service where 'caption like "documentum%"' get name, caption   

added a space after documentum

wmic service where 'caption like "%documentum %"' get name, caption   

removed the last m of documentum

wmic service where 'caption like "%documentu%"' get name, caption   

and as an example of a similar case where I query for the first word of a multi-word caption is successful

wmic service where 'caption like "%group%"' get name, caption    Caption              Name   Group Policy Client  gpsvc   

Answers

Try an echo wmic service where 'caption like "%documentum%"' get name, caption and you can see what's going on. You can also do echo %documentum%.

(It should echo the exact command back, including the %documentum%)

Maybe you have an environment variable named documentum.
(environment variables have precedence over the command parameters. So if they are present, they get substituted.)

You can do set documentum= and then execute the line to empty the variable (if set).

Tags:wmi

Related Articles

  • WMIC mystery - why is this query invalid?December 21

    Why is this an invalid query? wmic service where 'caption like "%documentum%"' get name, caption Node - PE95AOECM ERROR: Description = Invalid query This is the expected output: Caption Name EMC Documentum Thumbnail Server DctmThumbnailServer Do

  • SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?April 17

    I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint

  • How to make a query with Google Spreadsheet, that checks for a dateFebruary 28

    I have a range that goes from B4:H124. All the cells in column B are dates. I would like to retrieve the data from a row (B:H), where the DATE equals to the content of a specific cell, lets say Q4. How do I construct a proper query? So far, what I ha

  • How do you list all processes on the command line in Windows?September 10

    Is there a command equivalent to 'ps' on Unix that can list all processes on a Windows machine? --------------Solutions------------- Working with cmd.exe: tasklist If you have Powershell: get-process Via WMI: wmic process (you can query remote machin

  • Finding the physical local path associated with a Share UNC folderAugust 22

    Let's say I am Admin on a server named "Server1" and a share exists using the following UNC path \\Server1\Share1 If I remote to Server 1 and log in as Admin, how do I find the physical drive location without scanning millions of folders given t

  • Why is MariaDB 10 refusing to use my index on a date field?May 28

    I have the following table definition: CREATE TABLE `bets` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `id_mp` bigint(20) NOT NULL DEFAULT '0', `coin` char(3) COLLATE utf8_unicode_ci NOT NULL, `game_id` tinyint(4) NOT NULL DEFAULT '1', `group_turn_id`

  • OpsCenter 5.2 still views a keyspace after DROP via cqlshAugust 6

    After dropping a keyspace via cqlsh we can still see it on OpsCenter. The following error was seen in the log: Error deleting keyspace: ErrorMessage code=2300 [Query invalid because of configuration issue] message="Cannot drop non existing keyspace '

  • WMIC returns error when querying productFebruary 25

    I'm trying to automate the installation of an MSI on my server, however before the installation can go ahead I need to uninstall the previous version from the server. Searching on the internet I've found that WMIC is the tool required but there seems

  • why is a gdb query WHERE clause invalid according to the ArcGIS REST API?October 1

    Update: This only occurs when the layer being queried has a join. It doesn't matter if it has a join to a different database or not. And the query that fails is not trying to access columns in the joined table. In order to more accurately express the

  • How do I avoid that the search engines index URLs that contain invalid query strings?April 20

    It appears that Google Search has indexed my website, and it shows URLs that contain invalid query strings. For example, the URLs are similar to the following: www.mysite.com/page-name www.mysite.com/page-name?page=1 www.mysite.com/page-name?page=898

  • reposman.rb fails querying projects : "invalid character at ?xml"September 5

    I try to update the projects to the SVN repos using reposman, here is the command I use : ruby /home/redmine/redmine-1.2.1/extra/svn/reposman.rb --redmine redmine.mywebsite.com --svn-dir /var/svn --owner redmine --group www-data --url http://svn.mywe

  • Mysterious MapInfo query syntax errorsSeptember 19

    I'm struggling to get what seems like a perfectly normal query to execute in MapInfo v10. In SQLite Manager (an excellent firefox plugin), this works as expected: SELECT area_name, street_name, address, disp_lon, disp_lat FROM mtdArea, pointAddress,

  • getting warning messages "avahi-daemon[3201]: Invalid query packet." on suse 10.1 server with raid 1June 23

    I had recently replaced a failing hard drive on my software raid 1 system with suse 10.1 , and i am checking for any warning messages on " var/log/warn " and i found this message "avahi-daemon[3201]: Invalid query packet." more than 12

  • Is the overhead of frequent query cache invalidation ever worth it?September 5

    I'm currently working on a MySQL database where we are seeing a large number of invalidations from the query cache, primarily because of the high number of INSERT, DELETE and UPDATE statements that are being executed on many of the tables. What I'm t

  • invalidating query cache entries(key) September 5

    I'm currently working on a MySQL database where we are seeing a large number of invalidations from the query cache, primarily because of the high number of INSERT, DELETE and UPDATE statements that are being executed on many of the tables. What I'm t

  • Postfixadmin Invalid QuerySeptember 20

    This is my first time running a postfixadmin, so in my setup.php, I'm getting this error DEBUG INFORMATION: Invalid query: Unknown column 'create_date' in 'mailbox' I'm running it with MySQL. So if i'm right, my guess is that i need to create a colum

  • Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?October 2

    In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong... Points are in Oracle stored under SDO_GEOMETRY, 2001 type (2D point), 4326 SR

  • Batch Issues Invalid Query Locator When Accessing Sub QueryMarch 19

    I'm rolling out a new batch process and started getting Invalid Query Locator error messages on certain batches (4 out of 85). Am I doing something wrong? Feels like a bug and will be submitting to support, but wanted to make sure I'm not doing anyth

  • ArcGIS Android Reverse geocoding, Cannot perform query. Invalid query parametersAugust 2

    I'm trying to write reverse geocoding. And i copied code given here... Here is my code sample.. public class MagProActivity extends Activity { private MapView mMapView; private GraphicsLayer locationLayer; /** Called when the activity is first create

  • Query: CREATE "Sent", Reason Given: Invalid mailbox name.

    Query: CREATE "Sent", Reason Given: Invalid mailbox name.August 13

    Hi, I have Fedora 7 installed and followed Virtual Users And Domains With Postfix, Courier And MySQL (Fedora Core 5) with some adjustments for 7. I can send and recieve with Eudora without a problem. But I want to be able to use webmail as well, so I

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.668 s.