{"id":70063,"date":"2005-04-08T19:29:00","date_gmt":"2005-04-08T19:29:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2005\/04\/08\/how-can-i-get-a-list-of-all-the-pst-files-on-a-computer\/"},"modified":"2005-04-08T19:29:00","modified_gmt":"2005-04-08T19:29:00","slug":"how-can-i-get-a-list-of-all-the-pst-files-on-a-computer","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-get-a-list-of-all-the-pst-files-on-a-computer\/","title":{"rendered":"How Can I Get a List of All the .PST Files on a Computer?"},"content":{"rendered":"

 <\/P>\"Hey, \n

Hey, Scripting Guy! How can I get a list of all the .pst files on a computer – along with their size and their location – and then save that information to a comma-separated values file?

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

Hey, DC. If you hang around baseball fields long enough sooner or later you\u2019ll hear someone use the expression \u201ctailor-made.\u201d Typically what they are referring to is not some player\u2019s uniform but a ground ball that is doomed to be turned into a double play. Something that\u2019s tailor-made can\u2019t be anything but<\/I> a double-play; for better or worse (depending on the team you\u2019re rooting for) the grounder was perfectly designed to be turned into two quick outs.<\/P>\n

Why do we mention this? (We mean besides the fact that at least one of the Scripting Guys spends far more time thinking about baseball than he does thinking about scripting.) Well, it turns out that this question is tailor-made for WMI: not only can WMI search any entire file system for any files that have a .pst<\/B> file extension, but WMI can also retrieve folder information and file size as well. Tailor-made!<\/P>\n

Just to prove it, here\u2019s a script that retrieves information about all the .pst files on a computer. Note that this particular script displays information to the screen; we\u2019ll show you how to save this data to a comma-separated values (CSV) file a little later on:<\/P>

strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_DataFile Where Extension = ‘pst'”)<\/p>\n
For Each objFile in colFiles\n    Wscript.Echo objFile.Drive & objFile.Path\n    Wscript.Echo objFile.FileName & “.” & objFile.Extension\n    Wscript.Echo objFile.FileSize\n    Wscript.Echo\nNext\n<\/PRE>\n
Just a few things to point out here. After connecting to the WMI service we use ExecQuery<\/B> to return a collection of all the files that have an Extension<\/B> of pst<\/B>. Note that we don\u2019t include the period in the file extension: it\u2019s pst<\/B> rather than the .pst<\/B>. That\u2019s just the way WMI does things.<\/P>\n
After retrieving this collection we create a For Each loop and echo the desired property values. This is a little bit tricky because of the way WMI stores naming information for a file. For example, suppose we have this file:<\/P>
c:\\documents and settings\\kmyer\\local settings\\application data\\microsoft\\outlook\\archive.pst\n<\/PRE>\n
The naming information is stored like this in WMI:<\/P>\n\n<\/THEAD>\n\n\n\n\n\n\n
\n
WMI Property<\/B><\/P><\/TD>\n
\n
Value<\/B><\/P><\/TD><\/TR>\n
\n
Drive<\/P><\/TD>\n
\n
C:<\/P><\/TD><\/TR>\n
\n
Path<\/P><\/TD>\n
\n
\\documents and settings\\kenmyer\\local settings\\application data\\microsoft\\outlook\\<\/P><\/TD><\/TR>\n
\n
FileName<\/P><\/TD>\n
\n
archive<\/P><\/TD><\/TR>\n
\n
Extension<\/P><\/TD>\n
\n
pst<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
What does this mean? Well, it means that to display folder and files names the way we\u2019re used to seeing them we have to combine these property values before echoing them to the screen. To echo the folder name we combine the Drive<\/B> and Path<\/B> properties, like so:<\/P>
Wscript.Echo objFile.Drive & objFile.Path\n<\/PRE>\n
To display the file name we combine the FileName<\/B> and Extension<\/B> properties:<\/P>
Wscript.Echo objFile.FileName & “.” & objFile.Extension\n<\/PRE>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. Yes, we could have done this instead:<\/P>
Wscript.Echo objFile.FileName & “.pst”\n<\/PRE>\n
We took a more generic approach simply to show you how to construct file names in WMI.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
To display the file size we – oh, well, we just echo the value of the FileSize<\/B> property. Hurray for FileSize, huh?<\/P>\n
Now, what about saving this data to a CSV file? We\u2019ll show you a script that does that; if you need more information about saving data to a CSV file take a look at this portion of the Microsoft Windows 2000 Scripting Guide<\/B><\/A>.<\/P>\n
Here\u2019s a script that retrieves information about .pst files and then saves that data to C:\\Scripts\\PST_Data.txt:<\/P>
strComputer = “.”\nSet objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_DataFile Where Extension = ‘pst'”)<\/p>\n
If colFiles.Count = 0 Then\n    Wscript.Quit\nEnd If<\/p>\n
Set objFSO = CreateObject(“Scripting.FileSystemObject”)\nSet objTextFile = objFSO.CreateTextFile(“C:\\Scripts\\PST_Data.txt”)<\/p>\n
For Each objFile in colFiles\n    objTextFile.Write(objFile.Drive & objFile.Path & “,”)\n    objTextFile.Write(objFile.FileName & “.” & objFile.Extension & “,”)\n    objTextFile.Write(objFile.FileSize & vbCrLf)\nNext<\/p>\n
objTextFile.Close\n<\/PRE>\n
Notice how we write to the text file. We begin by writing the folder information followed by a comma. That gives us this:<\/P>
c:\\documents and settings\\kmyer\\local settings\\application data\\microsoft\\outlook\\,\n<\/PRE>\n
Next we add the file name, followed by another comma. Our text file will thus look like this:<\/P>
c:\\documents and settings\\kmyer\\local settings\\application data\\microsoft\\outlook\\,archive.pst,\n<\/PRE>\n
Finally we tack on the file size followed by a carriage-return linefeed (equivalent to pressing ENTER on the keyboard). We use the carriage return linefeed because we\u2019re done with the first .pst file and we want information for the next .pst file to be shown on a separate line. Our text file now looks like this:<\/P>
c:\\documents and settings\\kmyer\\local settings\\application data\\microsoft\\outlook\\,archive.pst,68741\n<\/PRE>\n
What\u2019d we tell you: tailor-made.<\/P>\n
Note that – depending on the size of your file system – this script might take 30 seconds or so to complete. If you know that your .pst files are likely to be found only on a particular drive or in a particular folder you might be able to speed that up a bit by modifying your WQL query. For example, this query searches only drive C: for .pst files:<\/P>
Set colFiles = objWMIService.ExecQuery _\n    (“Select * from CIM_DataFile Where Extension = ‘pst’ AND Drive = ‘C:'”)\n<\/PRE>
\n
\n\n\n\n
\"Top<\/A>Top of page<\/A><\/TD><\/TR><\/TBODY><\/TABLE><\/DIV><\/p>\n","protected":false},"excerpt":{"rendered":"
  Hey, Scripting Guy! How can I get a list of all the .pst files on a computer – along with their size and their location – and then save that information to a comma-separated values file?— DC Hey, DC. If you hang around baseball fields long enough sooner or later you\u2019ll hear someone use […]<\/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,4,12,5,6],"class_list":["post-70063","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-scripting-guy","tag-scripting-techniques","tag-storage","tag-vbscript","tag-wmi"],"acf":[],"blog_post_summary":"
  Hey, Scripting Guy! How can I get a list of all the .pst files on a computer – along with their size and their location – and then save that information to a comma-separated values file?— DC Hey, DC. If you hang around baseball fields long enough sooner or later you\u2019ll hear someone use […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/70063","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=70063"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/70063\/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=70063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=70063"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=70063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}