{"id":68773,"date":"2005-10-11T09:42:00","date_gmt":"2005-10-11T09:42:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2005\/10\/11\/how-can-i-determine-which-users-are-using-the-most-disk-space-on-a-drive\/"},"modified":"2005-10-11T09:42:00","modified_gmt":"2005-10-11T09:42:00","slug":"how-can-i-determine-which-users-are-using-the-most-disk-space-on-a-drive","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-determine-which-users-are-using-the-most-disk-space-on-a-drive\/","title":{"rendered":"How Can I Determine Which Users are Using the Most Disk Space on a Drive?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I determine which users are using the most disk space on a drive?

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

Hey, PW. Interesting question. In theory<\/I>, you could probably do this by retrieving a collection of all the files on a drive, checking the owner, determining the file size, and then keeping a running tally of the amount of disk space charged to each user. Like we said, in theory that would work, but it would be a complicated little script, and, depending on the number of files on the drive, you might bring your computer to its knees while the script performs all its machinations.<\/P>\n

Therefore, we decided to go with an approach that is much easier, much faster, and much less resource-intensive. The catch? (Oh, come on: you knew there had<\/I> to be a catch here.) You\u2019ll have to enable disk quotas on the drive in question in order for this to work.<\/P>\n

We won\u2019t spend much time talking about enabling and disabling disk quotas in today\u2019s column. If you\u2019re running Windows XP or Windows Server 2003, you can find a fairly extensive article on disk quotas in our Scripting for Windows Server 2003<\/B><\/A> center. If you\u2019re running Windows 2000, the Microsoft Windows 2000 Scripting Guide<\/B><\/A> includes information on using scripts to enable and disable disk quotas. Keep in mind that when we say you have to enable disk quotas on the drive, that doesn\u2019t mean you have to enforce<\/I> those quotas: you can enable disk quotas and allow the operating system to tally up the amount of disk space charged to each user without restricting access to the drive in any way. And, of course, you can always enable disk quotas, run your script, and then disable disk quotas again.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. If you decide to do the old enable\/disable trick, keep in mind that it will likely take several minutes – at least – for the operating system to tally up disk space use after quotas have been enabled. In other words, don\u2019t enable disk quotas and then immediately run the script to determine disk space usage; that\u2019s probably not going to work.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

Assuming you have enabled disk quotas on drive C of a computer, and assuming you\u2019re running Windows XP or Windows Server 2003, here\u2019s a script that will return the amount of disk space currently charged to each user:<\/P>

strComputer = “.”<\/p>\n
Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n
strDrive = “Win32_LogicalDisk.DeviceID=” & chr(34) & “C:” & chr(34)<\/p>\n
Set colQuotas = objWMIService.ExecQuery _\n    (“Select * from Win32_DiskQuota Where QuotaVolume = ‘” & strDrive & “‘”)<\/p>\n
For Each objQuota in colQuotas\n    Wscript.Echo “User: “& objQuota.User      \n    Wscript.Echo “Disk Space Used: “& objQuota.DiskSpaceUsed\nNext\n<\/PRE>\n
As you can see, the script begins simply enough, setting a variable named strComputer to a dot (WMI notation for the local computer) and then connecting to the WMI service. (Although this example connects to the WMI service on the local computer, you can retrieve disk quota information for a remote computer simply by assigning the name of that computer to the variable strComputer.) We then have this interesting line of code:<\/P>
strDrive = “Win32_LogicalDisk.DeviceID=” & chr(34) & “C:” & chr(34)\n<\/PRE>\n
As it turns out, the Win32_DiskQuota<\/B> class – the class we\u2019ll be working with to retrieve information about disk space usage – is a bit different than most WMI classes. For one thing, the QuotaVolume<\/B> property – which indicates the drive we\u2019re working with – isn\u2019t a typical WMI property; instead, it\u2019s actually an embedded instance of the Win32_LogicalDisk<\/B> class. That\u2019s fine, but it does make it a bit awkward to include QuotaVolume in a Where clause; that\u2019s because the value of QuotaVolume will look something like this:<\/P>
Win32_LogicalDisk.DeviceID=”C:”\n<\/PRE>\n
Inside a Where clause, it\u2019s tricky to deal with the double quote marks around the drive letter. Because of that, we use the preceding line of code to create a string value equivalent to Win32_LogicalDisk.DeviceID=”C:”<\/B>, using Chr(34) as a way to add in the double quotes. It\u2019s an extra line of code, but it\u2019s much easier to put the variable strDrive into the Where clause than it is to put Win32_LogicalDisk.DeviceID=”C:”<\/B>.<\/P>\n
Trust us; it is.<\/P>\n
Speaking of which, the next thing we do is call the ExecQuery<\/B> method to return a collection of all the disk quota entries for drive C:<\/P>
Set colQuotas = objWMIService.ExecQuery _\n    (“Select * from Win32_DiskQuota Where QuotaVolume = ‘” & strDrive & “‘”)\n<\/PRE>\n
From there we set up a For Each loop to walk through the collection, echoing back the user name and the amount of disk space (for drive C) currently charged to the user.<\/P>\n
Now, that works great on Windows XP or Windows Server 2003, but it won\u2019t do you much good on Windows 2000; that\u2019s because Windows 2000 doesn\u2019t support the Win32_DiskQuota class. So are you out of luck if you\u2019re running Windows 2000? Of course not; you can just use the DiskQuota<\/B> object instead:<\/P>
Set colDiskQuotas = CreateObject(“Microsoft.DiskQuota.1”)\ncolDiskQuotas.Initialize “C:\\”, True<\/p>\n
For Each objUser in colDiskQuotas\n    Wscript.Echo “Logon name: ” & objUser.LogonName\n    Wscript.Echo “Quota used: ” & objUser.QuotaUsed\nNext\n<\/PRE>\n
As you can see, here we create an instance of the Microsoft.DiskQuota.1<\/B> object, then use the Initialize<\/B> method to return the collection of disk quota entries for C:\\<\/B>. (Don\u2019t leave off the \\<\/B>; it\u2019s required.) We then set up a For Each loop and, for each quota entry, echo the values of the LogonName<\/B> and the QuotaUsed<\/B> properties.<\/P>\n
And you\u2019re right: this script is<\/I> a lot easier than the one we showed you for Windows XP and Windows Server 2003. So why didn\u2019t we just show you this script and call it good? Well, the catch here – oh, come on: you knew there had to be a catch here, too – is that the DiskQuota object can\u2019t be created remotely; that means the latter script can run only on the local computer. The WMI script might be a tad bit more complicated, but it has the advantage of working against remote computers as well.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I determine which users are using the most disk space on a drive?— PW Hey, PW. Interesting question. In theory, you could probably do this by retrieving a collection of all the files on a drive, checking the owner, determining the file size, and then keeping a running tally of […]<\/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":[216,3,12,5],"class_list":["post-68773","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-disk-drives-and-volumes","tag-scripting-guy","tag-storage","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I determine which users are using the most disk space on a drive?— PW Hey, PW. Interesting question. In theory, you could probably do this by retrieving a collection of all the files on a drive, checking the owner, determining the file size, and then keeping a running tally of […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68773","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=68773"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68773\/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=68773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=68773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=68773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}