{"id":68033,"date":"2006-02-03T14:36:00","date_gmt":"2006-02-03T14:36:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2006\/02\/03\/how-can-i-search-for-multiple-file-extensions-in-a-single-wql-query\/"},"modified":"2006-02-03T14:36:00","modified_gmt":"2006-02-03T14:36:00","slug":"how-can-i-search-for-multiple-file-extensions-in-a-single-wql-query","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-search-for-multiple-file-extensions-in-a-single-wql-query\/","title":{"rendered":"How Can I Search for Multiple File Extensions in a Single WQL Query?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I search for multiple file extensions in a single WQL query?

— AH<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, AH. If we understand your question correctly, you want to know if it\u2019s true that the Seattle Seahawks are playing in the Super Bowl this Sunday. Yes, it is<\/I> true: our very own Seahawks will be taking on \u2026 well, some second-place team. This is actually a great time for sports fans to be living in Seattle: the Seahawks are in the Super Bowl; the University of Washington men\u2019s basketball team is ranked 15th<\/SUP> in the country; the UW\u2019s women\u2019s volleyball team won the national championship; the Seattle Sonics –<\/P>\n

Um, did we mention that the women\u2019s volleyball team won the national championship?<\/P>\n

Actually, upon further review we suspect that maybe you\u2019d like to know how to search for multiple file extensions in a single WQL query. Well, then why didn\u2019t you say so:<\/P>

strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_Datafile Where Extension = ‘mp3’ OR Extension = ‘wma'”)<\/p>\n
For Each objFile in colFiles\n    Wscript.Echo “Name: ” & objFile.Name\nNext\n<\/PRE>\n
As you can see, this is about as simple a WMI script as you can get. We start out by connecting to the WMI service on the local computer. We then issue a query that looks for files of two types: those with the file extension mp3<\/B> and those with the file extension wma<\/B>. After retrieving the files we then set up a For Each loop to walk through the collection and echo back the name of each file.<\/P>\n
There are two important things to note here. First, the name of the WMI property is Extension<\/B> (and no, we don\u2019t know why they didn\u2019t call it FileExtension). Second, keep in mind that we are searching for files with the extension mp3<\/B>; we are not<\/I> searching for files with the extension .mp3<\/B>. Make sure you leave the dot out; otherwise your script won\u2019t return any data.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. One other thing: running queries against the entire file system can take a long time, something that depends on the number of files on your machine. That doesn\u2019t mean you can\u2019t or shouldn\u2019t do it; we just wanted to remind everyone that a script like this could easily take several minutes (or more) to complete. (Editor\u2019s Note: <\/I>Now he tells us.)<\/I><\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
So what\u2019s the secret to searching for multiple file extensions? Well, think about your task: you want a list of files that have the file extension mp3 or<\/I> that have the file extension wma. When you write the task out like this the key word is the word or<\/I>; that\u2019s also true when you write out the WQL query. Let\u2019s take a look at the query again:<\/P>
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_Datafile Where Extension = ‘mp3’ OR Extension = ‘wma'”)\n<\/PRE>\n
There you have it: Where Extension = ‘mp3’ <\/B>OR<\/I><\/B> Extension = ‘wma’<\/B>. The key is remembering that you want file extension mp3 or you want file extension wma. Often-times people make the mistake of thinking, \u201cI want all the files that have the file extension mp3 and I want all the files that have the file extension wma.\u201d As a result, they end up writing a query like this:<\/P>
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_Datafile Where Extension = ‘mp3’ AND Extension = ‘wma'”)\n<\/PRE>\n
We don\u2019t have any idea what files you have stored on your computer, but we already know how many files this query will find: 0. Why? Because what we\u2019re saying here is this: find all the files that have the file extension mp3 and that also have<\/I> the file extension wma. Needless to say, there aren\u2019t going to be many files with two file extensions. Don\u2019t get AND and OR mixed-up. Use OR when you want to expand the search, AND when you want to contract the search.<\/P>\n
Note, too that you need to specify the property each time: Extension = ‘mp3’ OR Extension = ‘wma’<\/B>. If you try to take shortcuts your script won\u2019t work: Extension = ‘mp3’ OR ‘wma’<\/B>.<\/P>\n
Finally, we should point out that you can use the OR operator with things other than file extensions. For example, here\u2019s a query that returns a list of all the services that are either stopped or paused:<\/P>
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from Win32_Service Where State = ‘Stopped’ OR State = ‘Paused'”)\n<\/PRE>\n
Likewise you can include more than just two OR clauses. Also interested in files with the extension wav? Then just add it to the query:<\/P>
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_Datafile Where Extension = ‘mp3’ OR Extension = ‘wma’ OR Extension = ‘wav'”)\n<\/PRE>\n
Oh, and one other thing: Go Seahawks!<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I search for multiple file extensions in a single WQL query?— AH Hey, AH. If we understand your question correctly, you want to know if it\u2019s true that the Seattle Seahawks are playing in the Super Bowl this Sunday. Yes, it is true: our very own Seahawks will be taking […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[38,3,12,5],"class_list":["post-68033","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-scripting-guy","tag-storage","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I search for multiple file extensions in a single WQL query?— AH Hey, AH. If we understand your question correctly, you want to know if it\u2019s true that the Seattle Seahawks are playing in the Super Bowl this Sunday. Yes, it is true: our very own Seahawks will be taking […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68033","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\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=68033"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68033\/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=68033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=68033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=68033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}