WQL就是WMI中的查询语言,WQL的全称是WMI Query Language,简称为WQL,翻译成中文好像可以成为Windows管理规范查询语言。熟悉SQL语言的朋友会感觉它和SQL非常相似。
具体操作过程参考:http://blog.youkuaiyun.com/zhoufoxcn/archive/2008/01/14/2044246.aspx
WQL其实非常简单,它有如下特点:
1、每个WQL语句必须以SELECT开始;
2、SELECT后跟你需要查询的属性名(我刚才对应SQL将其称之为字段名了),也可以像SQL一样,以*表示返回所有属性值;
3、FROM关键字;
4、你要查询的类的名字;
5、另外,如果你想精确查询结果还可以加上WHERE条件从句。比如某个类有Enable属性,你可以在查询的时候加上WHERE ENABLE=true。
要测试WQL语句,可在winxp系统中运行“wbemtest.exe”程序,在弹出的“windows管理规范测试器”中点击“连接”,将“root/default”改为“root/cimv2”,然后点“连接”,回到windows管理规范测试器中,点击“枚举类别”,点“递归”,然后“超类别名称”处保持空白,点击确定,就能得到所有可以通过WQL语句查询的超类别名词,可以把它们看成是SQL中的“表”。任意选择其中一项,比如Win32_BaseBoard,回到windows管理规范测试器,点击“查询”,输入“Select * From Win32_BaseBoard”,双击查询结果,在“对象编辑器”的“属性”一栏中即是该超类别的所有属性,也就是SQL中表的字段。属性栏中第一项是字段名称,第二项是字段的类型,比如“CIM_STRING”对应c++中的bstrVal类型,“CIM_UINT32”对应c++中的intVal类型。下面是用程序实现的对主板,显卡,CPU,内存,操作系统信息的查询:
- #define _WIN32_DCOM
- #include "stdafx.h"
- #include <iostream>
- #include <comdef.h>
- #include <Wbemidl.h>
- #include <Wbemcli.h>
- #include <conio.h>
- #pragma comment(lib, "wbemuuid.lib")
- using namespace std;
- BOOL ManageWMI();
- int _tmain(int argc, _TCHAR* argv[])
- {
- if(ManageWMI()) printf("%WMI Error!");
- _getch();
- return 0;
- }
- int CollectBaseBoardInfo(IWbemServices *pSvc)
- {
- HRESULT hres;
- // Step 6: --------------------------------------------------
- // Use the IWbemServices pointer to make requests of WMI ----
- // For example, get the name of the operating system
- IEnumWbemClassObject* pEnumerator = NULL;
- hres = pSvc->ExecQuery(bstr_t("WQL"), bstr_t("SELECT * FROM Win32_BaseBoard"), WBEM_FLAG_FORWARD_ONLY | WBEM_FLAG_RETURN_IMMEDIATELY, NULL, &pEnumerator);
- if (FAILED(hres))
- {
- cout << "Query for BaseBoard Configuration failed."
- << " Error code = 0x"
- << hex << hres << endl;
- pSvc->Release();
- return 1; // Program has failed.
- }
- // Step 7: -------------------------------------------------
- // Get the data from the query in step 6 -------------------
- IWbemClassObject *pclsObj;
- ULONG uReturn = 0;
- while (pEnumerator)
- {
- HRESULT hr = pEnumerator->Next(WBEM_INFINITE, 1, &pclsObj, &uReturn);
- if(0 == uReturn)
- {
- break;
- }
- VARIANT vtProp;
- VariantInit(&vtProp);
- //制造商
- hr = pclsObj->Get(L"Manufacturer", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- //主板型号
- hr = pclsObj->Get(L"Product", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- //序列号
- hr = pclsObj->Get(L"SerialNumber", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- VariantClear(&vtProp);
- }
- pEnumerator->Release();
- pclsObj->Release();
- return 0;
- }
- int CollectVideoControllerInfo(IWbemServices *pSvc)
- {
- HRESULT hres;
- // Step 6: --------------------------------------------------
- // Use the IWbemServices pointer to make requests of WMI ----
- // For example, get the name of the operating system
- IEnumWbemClassObject* pEnumerator = NULL;
- hres = pSvc->ExecQuery(bstr_t("WQL"), bstr_t("SELECT * FROM Win32_VideoController"), WBEM_FLAG_FORWARD_ONLY | WBEM_FLAG_RETURN_IMMEDIATELY, NULL, &pEnumerator);
- if (FAILED(hres))
- {
- cout << "Query for VideoController Configuration failed."
- << " Error code = 0x"
- << hex << hres << endl;
- pSvc->Release();
- return 1; // Program has failed.
- }
- // Step 7: -------------------------------------------------
- // Get the data from the query in step 6 -------------------
- IWbemClassObject *pclsObj;
- ULONG uReturn = 0;
- while (pEnumerator)
- {
- HRESULT hr = pEnumerator->Next(WBEM_INFINITE, 1, &pclsObj, &uReturn);
- if(0 == uReturn)
- {
- break;
- }
- VARIANT vtProp;
- VariantInit(&vtProp);
- //型号
- hr = pclsObj->Get(L"Description", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- //显存大小
- hr = pclsObj->Get(L"AdapterRAM", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- VariantClear(&vtProp);
- }
- pEnumerator->Release();
- pclsObj->Release();
- return 0;
- }
- int CollectProcessorInfo(IWbemServices *pSvc)
- {
- HRESULT hres;
- // Step 6: --------------------------------------------------
- // Use the IWbemServices pointer to make requests of WMI ----
- // For example, get the name of the operating system
- IEnumWbemClassObject* pEnumerator = NULL;
- hres = pSvc->ExecQuery(bstr_t("WQL"), bstr_t("SELECT * FROM Win32_Processor"), WBEM_FLAG_FORWARD_ONLY | WBEM_FLAG_RETURN_IMMEDIATELY, NULL, &pEnumerator);
- if (FAILED(hres))
- {
- cout << "Query for Processor Configuration failed."
- << " Error code = 0x"
- << hex << hres << endl;
- pSvc->Release();
- return 1; // Program has failed.
- }
- // Step 7: -------------------------------------------------
- // Get the data from the query in step 6 -------------------
- IWbemClassObject *pclsObj;
- ULONG uReturn = 0;
- while (pEnumerator)
- {
- HRESULT hr = pEnumerator->Next(WBEM_INFINITE, 1, &pclsObj, &uReturn);
- if(0 == uReturn)
- {
- break;
- }
- VARIANT vtProp;
- VariantInit(&vtProp);
- //描述
- hr = pclsObj->Get(L"Description", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- //时钟频率
- hr = pclsObj->Get(L"ExtClock", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- //cpu型号
- hr = pclsObj->Get(L"Name", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- VariantClear(&vtProp);
- }
- pEnumerator->Release();
- pclsObj->Release();
- return 0;
- }
- int CollectLogicalMemoryConfigurationInfo(IWbemServices *pSvc)
- {
- HRESULT hres;
- // Step 6: --------------------------------------------------
- // Use the IWbemServices pointer to make requests of WMI ----
- // For example, get the name of the operating system
- IEnumWbemClassObject* pEnumerator = NULL;
- hres = pSvc->ExecQuery(bstr_t("WQL"), bstr_t("SELECT * FROM Win32_LogicalMemoryConfiguration"), WBEM_FLAG_FORWARD_ONLY | WBEM_FLAG_RETURN_IMMEDIATELY, NULL, &pEnumerator);
- if (FAILED(hres))
- {
- cout << "Query for Processor Configuration failed."
- << " Error code = 0x"
- << hex << hres << endl;
- pSvc->Release();
- return 1; // Program has failed.
- }
- // Step 7: -------------------------------------------------
- // Get the data from the query in step 6 -------------------
- IWbemClassObject *pclsObj;
- ULONG uReturn = 0;
- while (pEnumerator)
- {
- HRESULT hr = pEnumerator->Next(WBEM_INFINITE, 1, &pclsObj, &uReturn);
- if(0 == uReturn)
- {
- break;
- }
- VARIANT vtProp;
- VariantInit(&vtProp);
- //物理内存
- hr = pclsObj->Get(L"TotalPhysicalMemory", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- //虚拟内存
- hr = pclsObj->Get(L"TotalVirtualMemory", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- //页面文件
- hr = pclsObj->Get(L"TotalPageFileSpace", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- VariantClear(&vtProp);
- }
- pEnumerator->Release();
- pclsObj->Release();
- return 0;
- }
- int CollectOperatingSystemInfo(IWbemServices *pSvc)
- {
- HRESULT hres;
- // Step 6: --------------------------------------------------
- // Use the IWbemServices pointer to make requests of WMI ----
- // For example, get the name of the operating system
- IEnumWbemClassObject* pEnumerator = NULL;
- hres = pSvc->ExecQuery(bstr_t("WQL"), bstr_t("SELECT * FROM Win32_OperatingSystem"), WBEM_FLAG_FORWARD_ONLY | WBEM_FLAG_RETURN_IMMEDIATELY, NULL, &pEnumerator);
- if (FAILED(hres))
- {
- cout << "Query for Processor Configuration failed."
- << " Error code = 0x"
- << hex << hres << endl;
- pSvc->Release();
- return 1; // Program has failed.
- }
- // Step 7: -------------------------------------------------
- // Get the data from the query in step 6 -------------------
- IWbemClassObject *pclsObj;
- ULONG uReturn = 0;
- while (pEnumerator)
- {
- HRESULT hr = pEnumerator->Next(WBEM_INFINITE, 1, &pclsObj, &uReturn);
- if(0 == uReturn)
- {
- break;
- }
- VARIANT vtProp;
- VariantInit(&vtProp);
- //操作系统名
- hr = pclsObj->Get(L"Name", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- //系统启动分区
- hr = pclsObj->Get(L"BootDevice", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- //操作系统序列号
- hr = pclsObj->Get(L"SerialNumber", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- //操作系统语言
- hr = pclsObj->Get(L"OSLanguage", 0, &vtProp, 0, 0);
- wcout << vtProp.intVal << endl;
- //制造商名
- hr = pclsObj->Get(L"Manufacturer", 0, &vtProp, 0, 0);
- wcout << vtProp.bstrVal << endl;
- VariantClear(&vtProp);
- }
- pEnumerator->Release();
- pclsObj->Release();
- return 0;
- }
- BOOL ManageWMI()
- {
- HRESULT hres;
- // Step 1: --------------------------------------------------
- // Initialize COM. ------------------------------------------
- hres = CoInitializeEx(0, COINIT_MULTITHREADED);
- if (FAILED(hres))
- {
- cout << "Failed to initialize COM library. Error code = 0x"
- << hex << hres << endl;
- return 1; // Program has failed.
- }
- // Step 2: --------------------------------------------------
- // Set general COM security levels --------------------------
- // Note: If you are using Windows 2000, you need to specify -
- // the default authentication credentials for a user by using
- // a SOLE_AUTHENTICATION_LIST structure in the pAuthList ----
- // parameter of CoInitializeSecurity ------------------------
- hres = CoInitializeSecurity(
- NULL,
- -1, // COM authentication
- NULL, // Authentication services
- NULL, // Reserved
- RPC_C_AUTHN_LEVEL_DEFAULT, // Default authentication
- RPC_C_IMP_LEVEL_IMPERSONATE, // Default Impersonation
- NULL, // Authentication info
- EOAC_NONE, // Additional capabilities
- NULL // Reserved
- );
- if (FAILED(hres))
- {
- cout << "Failed to initialize security. Error code = 0x"
- << hex << hres << endl;
- CoUninitialize();
- return 1; // Program has failed.
- }
- // Step 3: ---------------------------------------------------
- // Obtain the initial locator to WMI -------------------------
- IWbemLocator *pLoc = NULL;
- hres = CoCreateInstance(
- CLSID_WbemLocator,
- 0,
- CLSCTX_INPROC_SERVER,
- IID_IWbemLocator, (LPVOID *) &pLoc);
- if (FAILED(hres))
- {
- cout << "Failed to create IWbemLocator object."
- << " Err code = 0x"
- << hex << hres << endl;
- CoUninitialize();
- return 1; // Program has failed.
- }
- // Step 4: -----------------------------------------------------
- // Connect to WMI through the IWbemLocator::ConnectServer method
- IWbemServices *pSvc = NULL;
- // Connect to the root/cimv2 namespace with
- // the current user and obtain pointer pSvc
- // to make IWbemServices calls.
- hres = pLoc->ConnectServer(
- _bstr_t(L"ROOT//CIMV2"), // Object path of WMI namespace
- NULL, // User name. NULL = current user
- NULL, // User password. NULL = current
- 0, // Locale. NULL indicates current
- NULL, // Security flags.
- 0, // Authority (e.g. Kerberos)
- 0, // Context object
- &pSvc // pointer to IWbemServices proxy
- );
- if (FAILED(hres))
- {
- cout << "Could not connect. Error code = 0x"
- << hex << hres << endl;
- pLoc->Release();
- CoUninitialize();
- return 1; // Program has failed.
- }
- cout << "Connected to ROOT//CIMV2 WMI namespace" << endl;
- // Step 5: --------------------------------------------------
- // Set security levels on the proxy -------------------------
- hres = CoSetProxyBlanket(
- pSvc, // Indicates the proxy to set
- RPC_C_AUTHN_WINNT, // RPC_C_AUTHN_xxx
- RPC_C_AUTHZ_NONE, // RPC_C_AUTHZ_xxx
- NULL, // Server principal name
- RPC_C_AUTHN_LEVEL_CALL, // RPC_C_AUTHN_LEVEL_xxx
- RPC_C_IMP_LEVEL_IMPERSONATE, // RPC_C_IMP_LEVEL_xxx
- NULL, // client identity
- EOAC_NONE // proxy capabilities
- );
- if (FAILED(hres))
- {
- cout << "Could not set proxy blanket. Error code = 0x"
- << hex << hres << endl;
- pSvc->Release();
- pLoc->Release();
- CoUninitialize();
- return 1; // Program has failed.
- }
- if(0 != CollectBaseBoardInfo(pSvc))
- {
- pLoc->Release();
- CoUninitialize();
- return 1;
- }
- if( 0 != CollectVideoControllerInfo(pSvc))
- {
- pLoc->Release();
- CoUninitialize();
- return 1;
- }
- if( 0 != CollectProcessorInfo(pSvc))
- {
- pLoc->Release();
- CoUninitialize();
- return 1;
- }
- if( 0 != CollectLogicalMemoryConfigurationInfo(pSvc))
- {
- pLoc->Release();
- CoUninitialize();
- return 1;
- }
- if( 0 != CollectOperatingSystemInfo(pSvc))
- {
- pLoc->Release();
- CoUninitialize();
- return 1;
- }
- // Cleanup
- // ========
- pSvc->Release();
- pLoc->Release();
- CoUninitialize();
- return 0; // Program successfully completed.
- }