


V_GS_PC_rialnumber0 AS "PC Bios Serial Number", V_gs_system_enclosure.smbiosassettag0 AS "Asset Tag", V_gs_system_rialnumber0 AS "Serial Number", Here is the example mostly same as peter provided, I have tested in my environment: SELECT DISTINCT

SMS_Class_ID("MICROSOFT|PNP_DEVICE_DRIVER|1.0")]Ĭlass Win32_PnpEntity : SMS_Class_Templateįinally, when new hardware inventory cycle finished, you can build the custom query based on v_GS_PNP_DEVICE_DRIVER class: SMS Driver Catalog - Device drivers information Go to Win32_PnpEntiry class, enable all required properties: //. Then extend hardware inventory of ConfigMgr, open smsdef.mof under ‘%Program Files%\Microsoft Configuration Manager\inboxes\clifiles.src\hinv' be sure The CofigManagerErrorCode = 0 parameter means query out all devices working properly. select * from Win32_PnPEntiry where ConfigManagerErrorCode=0 and DeviceID like "%display%" Use following WQL to test in wbemtest, you will find monitor model information from Caption property and deviceID information from DeviceID property. You can use Win32_PnPEntity WMI class to get the monitor model. Before you run the report SQL command provided by Peter, you should extend the Hardware Inventory first to get the monitor information.
