Folder and Disk Space utilization report

squeekie — Wed, 20 Apr 2011 05:00:00 GMT

I have a portion of a script that creates an excel spreadsheet and populates the drives for remote servers, their size as well as used and percentage. (Found it here I believe) What I need to add to this spreadsheet are all of the directories that are listed under the drives by using the get-content pointing to my .txt file.

I.E. list only directories for each of the logical drives for the server

here is what I have found thus far, I am able to create the new column, I am not able to populate the information into it.

$strComputer = Get-Content <path to file>

$Excel = New-Object -Com Excel.Application
$Excel.visible = $True
$Excel = $Excel.Workbooks.Add()

$Sheet = $Excel.WorkSheets.Item(1)
$Sheet.Cells.Item(1,1) = “Computer”
$Sheet.Cells.Item(1,2) = “Drive Letter”
$Sheet.Cells.Item(1,3) = “Description”
$Sheet.Cells.Item(1,4) = “FileSystem”
$Sheet.Cells.Item(1,5) = “Size in GB”
$Sheet.Cells.Item(1,6) = “Free Space in GB”
$Sheet.Cells.Item(1,7) = "Free Space in %"
$Sheet.Cells.Item(1,8) = "Directories"

$WorkBook = $Sheet.UsedRange
$WorkBook.Interior.ColorIndex = 8
$WorkBook.Font.ColorIndex = 11
$WorkBook.Font.Bold = $True

$intRow = 2
$wmi1 = Get-wmiObject -class “Win32_LogicalDisk” -filter "DriveType = 3" -namespace “root\CIMV2" -computername $strComputer

foreach ($objItem in $wmi1) {
$Sheet.Cells.Item($intRow,1) = $objItem.SystemName
$Sheet.Cells.Item($intRow,2) = $objItem.DeviceID
$Sheet.Cells.Item($intRow,3) = $objItem.Description
$Sheet.Cells.Item($intRow,4) = $objItem.FileSystem
$Sheet.Cells.Item($intRow,5) = $objItem.Size / 1GB
$Sheet.Cells.Item($intRow,6) = $objItem.FreeSpace / 1GB
$Sheet.Cells.Item($IntRow,7) = ($objItem.FreeSpace / 1GB) / (($objItem.Size / 1GB))*100

<the next line of code would go here to populate the fields for each server>

$intRow = $intRow + 1
}

$WorkBook.EntireColumn.AutoFit()
Clear

------------what I am trying to do now----------------------------

What I have done to retrieve the folders, I run this after I created a psdrive for u:\

get-childitem u:\ -recurse | where-object {$_.psIscontainer} | Where-Object {$_.fullname.Count -ne 0 }

Only because I have not been able to query the servers in my .txt file. My thought is to have a nested foreach and take the output of the variable and add it to the cell. Once the query is complete for that server, it begins to query the next server on the list and populate the next row in excel.

Search results for 'app:forums' matching tags 'windows', 'powershell', and 'get-wmiobject Win32_Product MSI Windows Installer'

Folder and Disk Space utilization report