Questions tagged [wql]

The WMI Query Language (WQL) is a subset of the American National Standards Institute Structured Query Language (ANSI SQL)—with minor semantic changes.

Windows Management Instrumentation Query Language (WQL) is Microsoft's implementation of the CIM Query Language (CQL), a query language for the Common Information Model (CIM) standard from the Distributed Management Task Force (DMTF). It is a subset of the standard ANSI SQL with minor semantic changes. A basic WQL query remains fairly understandable for people with basic SQL knowledge.

WQL is dedicated to WMI and is designed to perform queries against the CIM repository to retrieve information or get event notifications

198 questions
0
votes
1 answer

WMI Object with another object as property ( how to pass an object as input parameter)

Hi I have 2 Wmi object with one of them being a property of the other. here is my code. $connections = get-wmiobject -class 'HNet_Connection' -Namespace 'root\Microsoft\HomeNet' ; $connectioName = 'ethernet'; #Write-Host $connections; foreach…
user1088352
  • 401
  • 3
  • 5
  • 11
0
votes
1 answer

Error while fetching null valued array columns in WQL (WMI Query Language)

I'm little new to world of WQL (WMI Query Language). I'm trying to query ConfigMgr 2012 using WQL but I'm facing an error when I try to mention the name of a column in the comma separated select clause. The error happens only when the column being…
RBT
  • 24,161
  • 21
  • 159
  • 240
0
votes
1 answer

Logic for building WQL-query

For a membership rule for collections in System Center Configuration Manager R2 i have to write a WQL-query which is a bit complex and gives me a hard time building the logic for. Let's say there are two tables i need: users, and systems. My goal is…
svdotbe
  • 168
  • 1
  • 3
  • 16
0
votes
1 answer

Unique Identification of a particular device type

Win32_PnPEntity class has so many properties but I want to know that is there any property which identifies the type of device uniquely . For example I have a fingerprint scanner device and its device id is something like this "USB\VID_0A86" but as…
0
votes
1 answer

wbemtest doesn't show certain data after executing a query

I have BitLocker enabled on my machine and I want to use the wbemtest.exe utility to view properties about the Bitlocker data. According to the properties section at MSDN, some of the data that I want to retrieve are DeviceID, DriveLetter,…
Krondorian
  • 616
  • 1
  • 9
  • 21
0
votes
2 answers

Device driver code signing for windows XP 32 bit

I have written a device driver for a device but each time I connect the device in windows XP 32 bit, "found new hardware" wizard appears. I am signing the driver using a Comodo code signing certificate and not using the cross certificate chain to…
itsfrosty
  • 203
  • 2
  • 8
0
votes
1 answer

Count in execquery for wql query

I am trying to connect to lenel and using WQL to fetch result. WQL when runned in WMI explorer returns record. Set objServices = GetObject("winmgmts://./root/onguard") Set cardSet = objServices.ExecQuery("select * from Lnl_Badge where id =11111") if…
user1853803
  • 649
  • 3
  • 8
  • 27
0
votes
1 answer

WQL query Win32_NtLogEvent on WinRM using group by

I need a query that returns the SourceName, Logfile, EventIdentifier, Type, NumberOfEvents from Win32_NTLogEvent where NumberOfEvents is the number of events that share common SourceName, LogFile and EventIdentifier (I am not sure about Type). I…
James Bond
  • 13
  • 1
  • 1
0
votes
3 answers

VBscript conditional for each

I've got to do an assignment for my internship and I cant figure out why the conditional wont work. I'm trying to get all the windowsservices except a few with a VBscript and write it to a textfile. Though I have no programming experiance and I'm at…
0
votes
1 answer

Getting CPU utilisation from WMI client on Linux

I am using the wmi client for linux. Through it you can execute WQL to query windows servers remotely. For Example; Select * from Win32_ComputerSystem What I am trying to do is calculate the CPU percentage used. I've been getting the value of…
user1768233
  • 1,409
  • 3
  • 20
  • 28
0
votes
1 answer

Why does WQL LIKE operator not work on drive c, but works fine on drive d?

I'm learning about File System Monitoring to speed up my 3rd and 4th backups of my mail server. I have a nice VB Script that works flawlessly on drive D, but when I query changes to drive C, nothing is returned if I use a wildcard. Here are my…
alfadog67
  • 831
  • 7
  • 28
0
votes
3 answers

WQL like operator not working for REF property

gwmi -Query "SELECT * FROM Win32_Service WHERE Name LIKE '%Logon%'" (works fine) returns some set of results, But when I run a similar query on some other class REF property ex: Win32_DependentService over Antecedent property the query is…
sri
  • 1,005
  • 1
  • 12
  • 26
0
votes
2 answers

WQL WMI Query to watch for newly created files

The following query should return a set of files that were created to the G drive in the folder test. I am having trouble getting the following WMI query to work: SELECT * FROM __InstanceCreationEvent WITHIN 1 WHERE TargetInstance ISA…
CodeKingPlusPlus
  • 15,383
  • 51
  • 135
  • 216
0
votes
1 answer

WMI Associators of DiskDrive Where Result Class is MSStorageDriver

Trying to link DiskDrives found in Win32_DiskDrive with the data in MSStorageDriver_ATAPISmartData. I've tried the following WQL statement, but it returned nothing each time. (I know that there is relevant data in the MSStorageDrive…
Chris Watts
  • 6,197
  • 7
  • 49
  • 98
0
votes
1 answer

terminating process requires WQL "SELECT *..."?

i'm writing code to terminate specific processes after a specified amount of time. i'm using the below code (simplified for post): ManagementObjectSearcher searcher = new ManagementObjectSearcher("SELECT Name, CreationDate FROM Win32_Process WHERE…
mdelvecchio
  • 567
  • 1
  • 5
  • 25
1 2 3
13
14