ICT-Hotlist Topic

Back to the ICT-Hotlist...
Don't miss latest updates Follow @WebHalla

Used-DiskSpace by vanSoest.it

Current version

Main feature overview

• Fixed drive letter
• Volume Label
• File System (FAT/NTFS/ReFS)
• Available space to current user: This is the available free disk space for the currently logged on user.
• Total available space: This can be larger than the previous value when using user quota.
• Total size of drive.
• Total Used size of drive

• Used-DiskSpace is agentless and requires no installation and configuration on every computer monitored
• The program can run over the network using a logon server
• Standard Unicode based data files can be stored on a file server instead of using complex to configure databases and client server applications.
• Well known Microsoft Excel features such as AutoFilter and conditional formatting can be used to quickly analyse the data.

Contents

• History
• Features
• License
• Manual
  • Examples
  • Previous releases
• Installation
• System Requirements
• Download
• Frequently Asked Questions (FAQ)

History

Features

License

Manual

• /Help or short /H
• /File of short /F

Run Used-DiskSpace with no parameters

C:\>Used-DiskSpace.exe
Drive C:\
  File type: Fixed
  Volume label: Windows
  File system: NTFS
    C:\ "Available space to current user":   45,630,607,360 bytes
    C:\ "Total available space":             45,630,607,360 bytes
    C:\ "Total size of drive":              237,555,937,280 bytes
    C:\ "Total Used size of drive":         191,925,329,920 bytes
Drive D:\
  File type: Fixed
  Volume label: HP_TOOLS
  File system: FAT32
    D:\ "Available space to current user":    2,060,242,944 bytes
    D:\ "Total available space":              2,060,242,944 bytes
    D:\ "Total size of drive":                2,139,095,040 bytes
    D:\ "Total Used size of drive":              78,852,096 bytes

Getting Quick help on Used-DiskSpace

Used-DiskSpace help screen. The .Net 4 version can be recognised by the 6^th line being: "This .Net 4 program has two parameters"

Using Used-DiskSpace with the file save option

Examples

1. Show current disk status:
   Simply run the program in a command prompt window to see the current status of the disks in a computer:
   The program Used-DiskSpace can be run from a disk, network share, logon share or even an USB stick.
   Starting the program from a harddisk:
   C:\batch\Used-DiskSpace
   Starting the program from the netlogon share:
   \\vansoest.it\netlogon\Used-DiskSpace
2. Write an output file:
   Writing the output file to a network disk on the file server nlaalfs1 in the hidden PublicData share:
   C:\batch\Used-DiskSpace /File \\nlaalfs1\PublicData$\%computername%_%username%.txt
   Here the file name is constructed with the system parameters of the current computer name and user name of the currently logged on user.
   The file option can also be used in upper case, lower case or you can even use the first letter only. So the following options are equal: /FILE, /file, /File, /F and /f.
3. Merge the files for analysis:
   If you want to analyse all the disks in your enterprise network with Excel, you can use the tool Merge1File to combine all the files in the hidden PublicData share in a new file. This file can be opened in Excel.
   c:\batch\Merge1File /s \\nlaalfs1\PublicData$\*.txt /d MergedData.txt
   Merge1File is a tool that has some great options used default here. Read more on the product page.
4. Process the data in Excel:
   The merged file can easily be opened in Excel. Using conditional formatting and AutoFilter, disk analysis of hundreds of computers can be done in minutes. See the demonstration movie created with LICEcap.
   The following example shows how easy it is to import the merged file in Excel, format the data the way you want it, highlight the disks that contain less than 20GB free disk space and show only the operating system disks (C:\)
   
   Animation showing how quickly disk spaces can be analysed.
5. The Excel Macro that automates it all:
   Sub UsedDiskSpace() ' ' UsedDiskSpace Macro ' This macro is an example included with the product Used-DiskSpace by vanSoest.it ' (C)Copyrights 2017 - 2021 vanSoest.it by Johan van Soest ' Version 1.0 to be used with Used-DiskSpace version 1.2 ' Dim sMinimalFreeDiskSpace As String sMinimalFreeDiskSpace = "20000000000" ' Convert text to columns (text is in column A) Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _ Array(7, 1), Array(8, 1)), TrailingMinusNumbers:=True ' Set numerical formatting to thousand digit "," and no decimal places Columns("E:H").Select Selection.NumberFormat = "#,##0" ' Configure header Rows("1:1").Select Selection.Font.Bold = True ' Set auto filter Columns("A:H").Select Selection.AutoFilter ' Set column width so all data can be read Columns("A:H").EntireColumn.AutoFit ' Select available space to current user column Columns("E:E").Select ' Set Conditional formatting: highlight every ' "Available space to current user" less than sMinimalFreeDiskSpace Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, _ Formula1:="=" + sMinimalFreeDiskSpace Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority With Selection.FormatConditions(1).Font .Color = -16383844 .TintAndShade = 0 End With With Selection.FormatConditions(1).Interior .PatternColorIndex = xlAutomatic .Color = 13551615 .TintAndShade = 0 End With ' Set autofilter of "Available space to current user" column to Less than ' sMinimalFreeDiskSpace Selection.FormatConditions(1).StopIfTrue = False ActiveSheet.Range("A:H").AutoFilter Field:=5, Criteria1:= _ "<" + sMinimalFreeDiskSpace, Operator:=xlAnd ' Select C:\ drive only ActiveSheet.Range("A:H").AutoFilter Field:=2, Criteria1:="C:\" End Sub

Previous Releases

Version	Features
1.2	Added support for an unicode output file. By using the option /File or /F the unicode output of Used-DiskSpace can be analysed very easy in Excel without any data transforms. No regional setting based commas or dots are used as 1000 separator in the file. Programmed in Microsoft Visual c#. The unicode output file now contains: The unicode output file of Used-DiskSpace Using tab separators, quoted column labels and unformatted disk sizes allow for easy but powerful Excel data analysis. For Examples, see the Examples section.
1.1	Minimal formatting changes to make the redirected output even easier to analyse in Excel. Programmed in Microsoft Visual c#. The example of version 1.0 produces the following output with the same data: Drive C:\ File type: Fixed Volume label: Windows File system: NTFS C:\ "Available space to current user": 42,011,025,408 bytes C:\ "Total available space": 42,011,025,408 bytes C:\ "Total size of drive": 119,926,681,600 bytes C:\ "Total Used size of drive": 77,915,656,192 bytes The files can then be processed in to one large file using the command: FindSTR /c bytes \\nlaalfs1\Disk-Usage$\*.txt >> AllData.txt This file AllData.txt can be imported in Excel as it stores the data in the following format: PC0001_John C:\ "Available space to current user": 42,011,025,408 bytes PC0001_John C:\ "Total available space": 42,011,025,408 bytes PC0001_John C:\ "Total size of drive": 119,926,681,600 bytes PC0001_John C:\ "Total Used size of drive": 77,915,656,192 bytes Adding the spaces in front of the drive letter compared to version 1.0, allows easier separation of PC and disk data in an Excel sheet. And allows for easier filtering on drive characters.
1.0	The great program Used-DiskSpace can be used in a batch file, logon script or on the command prompt to simply but clearly show the relevant data of the fixed disks in a Windows Desktop or Notebook PC. Output of the program can be redirected to a file on a file share for central analysis. The standard command line tool FindStr can be used to process the data. Programmed in Microsoft Visual Studio c# The following example can be used in a logon script and creates a file on the hidden file server share \\nlaalfs1\Disk-Usage$ By using the command shell system variables ComputerName and UserName, an unique file is created on the file server nlaalfs1 Used-DiskSpace > \\nlaalfs1\Disk-Usage$\%computername%_%username%.txt This produces a file in the format: Drive C:\ File type: Fixed Volume label: Windows File system: NTFS C:\ "Available space to current user": 42,011,025,408 bytes C:\ "Total available space": 42,011,025,408 bytes C:\ "Total size of drive": 119,926,681,600 bytes C:\ "Total Used size of drive": 77,915,656,192 bytes The files can then be processed in to one large file using the command: FindSTR /c bytes \\nlaalfs1\Disk-Usage$\*.txt >> AllData.txt This file AllData.txt can be imported in Excel as it stores the data in the following format: PC0001_JohnC:\ "Available space to current user": 42,011,025,408 bytes PC0001_JohnC:\ "Total available space": 42,011,025,408 bytes PC0001_JohnC:\ "Total size of drive": 119,926,681,600 bytes PC0001_JohnC:\ "Total Used size of drive": 77,915,656,192 bytes This data can be analysed in Excel when using the space as column separator.

Installation

System requirements

Windows Version	Runs .Net 2.0	Tested
Windows XP	Yes	No
Windows Vista	Yes	No
Windows 7	Yes	Yes
Windows 8.1	Yes	No
Windows 10	Yes	Yes
Windows Server 2008 SP2	Yes	No
Windows Server 2008 R2 SP1	Yes	Yes
Windows Server 2012	Yes	No
Windows Server 2012 R2	Yes	No
Windows Server 2016	Yes	Yes

Support matrix

Download

Frequently Asked Questions (FAQ)

You may vote your opinion about this article:

---

Please leave an optional comment or you can ask a question.
(Will not be published)

HTML tags are not allowed.

---

Do you want to receive an answer?
Fill in your e-mail address.(Optional)

Data you enter here, will be processed according to the Privacy Statement.
Send

Scripts and programming examples disclaimer