{"id":85947,"date":"2004-09-28T05:44:17","date_gmt":"2004-09-28T13:44:17","guid":{"rendered":"http:\/\/devblogs.microsoft.com\/scripting\/?p=85947"},"modified":"2019-06-05T05:52:11","modified_gmt":"2019-06-05T13:52:11","slug":"how-can-i-get-a-list-of-the-devices-that-arent-working","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-get-a-list-of-the-devices-that-arent-working\/","title":{"rendered":"How Can I Get a List of the Devices That Aren’t Working?"},"content":{"rendered":"

\"Hey,<\/p>\n

Hey, Scripting Guy! In Device Manager, any time a device isn\u2019t working that device is marked with a yellow exclamation mark. How can I use a script to get a list of the devices that aren\u2019t working?<\/p>\n

— OL<\/p>\n

\"Spacer\"\"Hey,\"Script<\/a><\/p>\n

Hey, OL. Sometimes in baseball a batter absolutely hammers one, but the ball takes a lucky bounce and lands right in your glove. That\u2019s often referred to as a \u201ccandy hop.\u201d Turns out that this question is the scripting equivalent of a candy hop: it looks like it might be a tough one to answer, but it turns out to be pretty easy.<\/p>\n

WMI actually has a class – Win32_PNPEntity – that returns information about the devices found in Device Manager. Meanwhile, Win32_PNPEntity has a property – ConfigManagerErrorCode – that tells you whether or not the device is working properly. If the value of ConfigManagerErrorCode is 0, then the device appears to be working. If ConfigManagerErrorCode is anything but <\/i>0, then something must be wrong. And here\u2019s the good part: any device with a ConfigManagerErrorCode value other than 0 will also have a little yellow exclamation mark next to it in Device Manager.<\/p>\n

In other words, to write a script that returns a list of the devices that aren\u2019t working properly we just need to connect to the Win32_PNPEntity class and query for all devices with a ConfigManagerErrrorCode other than 0:<\/p>\n

strComputer = \".\"<\/pre>\n
Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colItems = objWMIService.ExecQuery _\n(“Select * from Win32_PNPEntity Where ConfigManagerErrorCode <> 0”)<\/p>\n
For Each objItem in colItems\nWscript.Echo “Name: ” & objItem.Name\nNext<\/p>\n
And what if you\u2019d like more detailed information about all the devices installed on a computer? Well, because this question turned out to be an easy one to answer, we\u2019re feeling generous: here\u2019s a bonus script that returns all sorts of data about installed devices:<\/p>\n
strComputer = \".\"\r\nSet objWMIService = GetObject(\"winmgmts:\\\\\" & strComputer & \"\\root\\cimv2\")\r\nSet colItems = objWMIService.ExecQuery(\"Select * from Win32_PnPEntity\")\r\nFor Each objItem in colItems\r\n    Wscript.Echo \"Class GUID: \" & objItem.ClassGuid\r\n    Wscript.Echo \"Device is Working: \" & objItem.ConfigManagerErrorCode\r\n    Wscript.Echo \"Description: \" & objItem.Description\r\n    Wscript.Echo \"Device ID: \" & objItem.DeviceID\r\n    Wscript.Echo \"Manufacturer: \" & objItem.Manufacturer\r\n    Wscript.Echo \"Name: \" & objItem.Name\r\n    Wscript.Echo \"PNP Device ID: \" & objItem.PNPDeviceID\r\n    Wscript.Echo \"Service: \" & objItem.Service\r\nNext\r\n<\/pre>\n
No, no charge for the bonus script. That one is on us!<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! In Device Manager, any time a device isn\u2019t working that device is marked with a yellow exclamation mark. How can I use a script to get a list of the devices that aren\u2019t working? — OL Hey, OL. Sometimes in baseball a batter absolutely hammers one, but the ball takes a lucky […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-85947","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! In Device Manager, any time a device isn\u2019t working that device is marked with a yellow exclamation mark. How can I use a script to get a list of the devices that aren\u2019t working? — OL Hey, OL. Sometimes in baseball a batter absolutely hammers one, but the ball takes a lucky […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/85947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=85947"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/85947\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=85947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=85947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=85947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}