WQL DataProvider for ADO.NET

• Download demo - 110 Kb
• Download source - 44 Kb

Introduction

WQL DataProvider is an ADO.Net data provider, so you can use it just like usual MS SQL DataProvider, but for WQL (WMI + SQL = WQL). This DataProvider supports SELECT, ASSOCIATORS and REFERENCES queries. Doesn't support event queries.

How to use it..

using WQLData;
//.............

//.............

WQLConnection connection = new WQLConnection(
    String.Format(@"Server:{0};User:{1\2};Password:{3}", 
    server, doamin, user, password));
DataSet dataSet = new DataSet("WQLDataSet");
WQLDataAdapter adapter = new WQLDataAdapter(
    "SELECT * FROM Win32_LogicalDisk", WQLContext.Connection);
adapter.Fill(dataSet, "LogicalDisks");
//.............

//.............

        

Demo application - WQL Analyzer

Using "WQL Analyzer" you can :

• browse classes, properties, qualifiers;
• run WQL queries (locally or remotely);
• save results as XML or HTML;
• connect to remote computer;
• export class description to XML or HTML;
• automatically generate the "SELECT" query (double click on class name);

Some WQL Examples :

Query :

SELECT __CLASS, __SUPERCLASS, __DYNASTY
FROM Meta_Class 
WHERE __DYNASTY = "CIM_PhysicalCapacity" 

Result :

__CLASS	__SUPERCLASS	__DYNASTY
CIM_PhysicalCapacity		CIM_PhysicalCapacity
CIM_MemoryCapacity	CIM_PhysicalCapacity	CIM_PhysicalCapacity

Query :

SELECT DeviceID, FileSystem, Size, FreeSpace, 
    Compressed, Description, MediaType
FROM Win32_LogicalDisk
WHERE MediaType = 12

Result :

DeviceID	FileSystem	Size	FreeSpace	Compressed	Description	MediaType
C:	NTFS	12068872192	185409536	False	Local Fixed Disk	12
D:	NTFS	12068872192	185409536	False	Local Fixed Disk	12
O:	NTFS	12068872192	185409536	False	Local Fixed Disk	12

Analyzer also supports ASSOCIATORS and REFERENCES queries. For example :

ASSOCIATORS OF {Win32_LogicalDisk.DeviceID="C:"}
WHERE ClassDefsOnly

REFERENCES OF {Win32_NetworkAdapter.DeviceID="0"} 
WHERE resultclass = Win32_NetworkAdapterSetting requiredQualifier = Dynamic

Note : Analyzer doesn't support Event queries

Current version support some extension (not supported in stantart WQL)

Invoke method :
      
CALL [\\server\root\cimv2:Win32_Process.Handle="2236"].Terminate(Reason=0)
 
   
Update property :
      
UPDATE Win32_Environment      
SET VariableValue = 'Hi2'      
WHERE __PATH='\\EPNL007\root\cimv2:Win32_Environment.Name="Test",
  UserName="server\\user"'
   

SELECT TOP :
      
SELECT TOP 50 __PATH, Logfile, RecordNumber, EventType,InsertionStrings, 
  Message, SourceName, TimeGenerated
FROM Win32_NTLogEvent     
WHERE  Logfile = 'Application'

Order By :
    
SELECT __PATH, Caption, ExecutablePath, CreationDate,KernelModeTime, 
  ProcessId, ParentProcessId, Priority, ThreadCount, VirtualSize
FROM Win32_Process      
ORDER BY Caption ASC

Run Query on remote computer

Export Classes descriptions to XML or HTML

Logging

You can configure the error logging in WQLAnalyzer.exe.config. Application uses log4net library for logging in.

You must Sign In to use this message board.

FAQ    Noise Tolerance Very HighHighMediumLowVery Low   Layout Expand Posts & RepliesThread ViewNo JavascriptNo JS + Preview   Per page 102550

Msgs 1 to 3 of 3 (Total in Forum: 3) (Refresh) FirstPrevNext

Limitations with WQL query syntax daluu 21:04 30 Jun '09   It's too bad WQL doesn't support SQL joins, unions, and complex stuff. Would be nice to be able to query for performance data across two different counter objects classes using a common parameter like process ID. But great work with this analyzer. Can be useful for us. "A good scientist is a person with original ideas. A good engineer is a person who makes a design that works with as few original ideas as possible." - Freeman Dyson Sign In·View Thread·PermaLink __PATH In Query billz@edpi.com 6:54 13 Sep '08   I normally don't include the __PATH field in my queries, but I noticed that an exception will be thrown in the WQLDataBase class (WQLDataBase.cs). Line 260 (log.Debug(oObject["__PATH"].ToString())) is looking for the __PATH field. I found that changing it to: "log.Debug(oSearcher.Scope.Path);" allows it to get the value from the scope, and it doesn't care what fields are in the WQL query. Sign In·View Thread·PermaLink Help me dharani 0:36 24 Nov '04   Hi maxim good article . I am trying to retrive all the classes from a given namespace say root/cimv2 . I am executing a query "select * from meta_class " but I am getting only null values from all remote systems ..2000 or XP or NT . Why so ? I am desperate to find the answer and at loss of idea ... pls instruct me regds Dharani Babu S Sign In·View Thread·PermaLink 1.33/5 (3 votes)

Last Visit: 16:13 9 Jul '09     Last Update: 16:13 9 Jul '09 1