{"id":67073,"date":"2006-06-20T09:09:00","date_gmt":"2006-06-20T09:09:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2006\/06\/20\/how-can-i-retrieve-a-list-of-all-the-files-that-have-no-file-extension\/"},"modified":"2006-06-20T09:09:00","modified_gmt":"2006-06-20T09:09:00","slug":"how-can-i-retrieve-a-list-of-all-the-files-that-have-no-file-extension","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-retrieve-a-list-of-all-the-files-that-have-no-file-extension\/","title":{"rendered":"How Can I Retrieve a List of All the Files That Have No File Extension?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I retrieve a list of all the files that have no file extension?

— JB<\/P>\"Spacer\"\"Hey,\"TechNet<\/A> \n

Hey, JB. Funny you should ask about no-hitters. Yes, it\u2019s true: the Scripting Son was robbed of a no-hitter this past Saturday. With one out in the top of the seventh (you play just seven innings in Colt League baseball), the Scripting Son had a no-hitter going. The next batter dribbled a ball down the third base line. It was clearly a foul ball; at first the batter didn\u2019t even run but just stood there and watched. Unfortunately, though, the home plate umpire didn\u2019t see it that way. He called the ball fair and, after a mad scramble, the batter managed to get safely to first. Officially, it was a base hit and, officially, the no-hitter was over.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. Uh, no, it\u2019s probably best if we don\u2019t relate the opinions of the Scripting Son regarding this call. Let\u2019s just say that he was happy the team won, and leave it at that.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

What\u2019s that? Yes, we noticed that the question said \u201cno file extension\u201d rather than \u201cno-hitter.\u201d We just assumed that was a typo. Surely no one could be thinking about work<\/I> at a time like this. (The time, of course, being baseball season.)<\/P>\n

On the other hand, it\u2019s theoretically possible that someone might be more interested in a scripting than they are in hearing about the pitching exploits of the Scripting Son. (Unlikely, but still possible.) Just in case JB really did<\/I> mean \u201cno file extension,\u201d here\u2019s a script that will take care of that:<\/P>

strComputer = “.”<\/p>\n
Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_DataFile where Extension = ””)<\/p>\n
For Each objFile in colFiles\n    Wscript.Echo objFile.Name\nNext\n<\/PRE>\n
Yes, it\u2019s very easy. (After all, we\u2019re entering the home stretch of the baseball season; we don\u2019t have time<\/I> to write long and complicated scripts!) As you can see, we begin by connecting to the WMI service on the local computer. Is it possible to connect to a remote<\/I> computer and find all the files that don\u2019t have file extensions? Of course it is: just assign the variable strComputer the name of the remote machine. For example, this modified line of code will cause the script to search the computer atl-fs-01 for files without file extensions (not to be confused with Doctors Without Borders, Parents Without Partners, or A Day Without Sunshine):<\/P>
strComputer = “atl-fs-01”\n<\/PRE>\n
After making the connection we then issue the following query:<\/P>
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_DataFile where Extension = ””)\n<\/PRE>\n
What we\u2019re doing here is querying the CIM_DataFile class, the WMI class used for managing files. Of course, we don\u2019t want a list of all<\/I> the files on the computer, just those that don\u2019t have a file extension. To do that, we simply tack on a Where clause that limits returned data to files where the Extension<\/B> property is equal to nothing (that is, an empty string: \u2018\u2019). <\/P>\n
Our query returns a collection of all the files that don\u2019t have a file extension. To review that list we set up a For Each loop to walk through the collection, and then echo back the Name<\/B> (path) for each file found there. It\u2019s that easy.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. Could we echo back other file properties besides Name? Sure; see the Microsoft Windows 2000 Scripting Guide<\/B><\/A> for details.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
Here\u2019s an equally sad story for you. Last Thursday one of our pitchers had a no-hitter after four innings. In the top of the fifth, the leadoff batter hit a ground ball right to the shortstop. Our shortstop took a little too much time, and then kind of lobbed the ball over to first. The batter beat it out for an infield single, the first – and only – hit the other team had all night. In other words, that\u2019s twice in the span of just three days that we could have – and probably should have – had no-hitters. But we ended up with nothing at all. <\/P>\n
Maybe we\u2019ll give our pitchers a copy of the script that finds files that don\u2019t have file extensions. That<\/I> should cheer them up!<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I retrieve a list of all the files that have no file extension?— JB Hey, JB. Funny you should ask about no-hitters. Yes, it\u2019s true: the Scripting Son was robbed of a no-hitter this past Saturday. With one out in the top of the seventh (you play just seven innings […]<\/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-67073","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 retrieve a list of all the files that have no file extension?— JB Hey, JB. Funny you should ask about no-hitters. Yes, it\u2019s true: the Scripting Son was robbed of a no-hitter this past Saturday. With one out in the top of the seventh (you play just seven innings […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/67073","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=67073"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/67073\/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=67073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=67073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=67073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}