# Creates a CSV containing the sizes of the user profile folders on a computer to a CSV named by the computer's hostname
# Run with SCCM or startup script to get data on all computers and then compile results with Power Bi Desktop
$Server = "<FQDN of server>"
$CsvFilePath = "\\$Server\UserProfileSizeReport$\$env:COMPUTERNAME.csv"
$CsvContent = @()
foreach ($folder in (get-childitem C:\Users)) {
$row = New-Object PSObject
$row | Add-Member -type NoteProperty -Name 'User' -Value $folder.Name
$size = [math]::round(((Get-ChildItem $folder.FullName -Recurse | Measure-Object -Property Length -Sum -ErrorAction Silent).Sum / 1MB),2)
# skip the Download folder in the calculation
# [math]::round(((Get-ChildItem C:\Users\aschott -Exclude Documents | Get-ChildItem -Recurse | Measure-Object -Property Length -Sum -ErrorAction Silent).Sum / 1MB),2)
$row | Add-Member -type NoteProperty -Name 'Size-MB' -Value $size
$CsvContent += $row
}
$CsvContent | Export-Csv -noTypeInformation -path $CsvFilePath