Powershell Question

This isn't the whole script. Where's the rest?

Sorry my bad edited it

You're trying to round a string ...
And there's no need to manually construct a csv; that's what Export-Csv is for.
Try it like this:

$File = 'C:\Data.csv'

$Exclusions = 'Administrator', 'Default', 'Public'
Get-ChildItem -Path "$($env:SystemDrive)\Users" -Directory | Where-Object {$Exclusions -notcontains $_.Name} | ForEach-Object {
	Try {
		$out = [PSCustomObject]([ordered]@{
			'ComputerName' = $env:COMPUTERNAME
			'Profile' = $_.Name
			'Size (MB)' = $null
			'Error' = $null
		})
		$folderSize = (Get-ChildItem -Path "$($_.FullName)\Documents", "$($_.FullName)\Desktop" -File -Recurse | Measure-Object -Property Length -Sum -ErrorAction Stop).Sum
		$out.'Size (MB)' = '{0:N2}' -f ($folderSize / 1MB)
	} Catch {
		$out.Error = $_.Exception.Message
	}
	$out
} | Export-Csv -NoTypeInformation -Path $File

Select allOpen in new window

Edit: Fixed issue with "Documents" path.

Thanks for the reply

I ran the script and the data is not correct

on my PC, I ran i got the below result in the csv
Size (MB)
16,116.03
1.26
0

But actual size are
21.0 GB
787 MB
154 MB

Any suggestions?

Sorry, that was a single quote that somehow sneaked into the "Documents" path
It's fixed above, so download again, or just remove the single quote directly after "Documents" in line 12:

... "$($_.FullName)\Documents'"
                             ^

Select allOpen in new window

Thanks alot,

Also, what to include to add another column to add total size of user profile? Total size if it is in GB or MB

ComputerName      Profile      Size (MB)      Total Size

Sorry I came back with other requirement, is there any way I can include profile created date

$File = 'C:\Data.csv'  

$Exclusions = 'Administrator', 'Default', 'Public'
Get-ChildItem -Path "$($env:SystemDrive)\Users" -Directory | Where-Object {$Exclusions -notcontains $_.Name} | ForEach-Object {
	Write-Host "Processing $($_.Name) ..."
	Try {
		$out = [PSCustomObject]([ordered]@{
			'ComputerName' = $env:COMPUTERNAME
			'Profile' = $_.Name
			'Total Size (MB)' = $null
			'Documents Size (MB)' = $null
			'Created' = (Get-Item -Path $_.FullName).CreationTime.ToString('yyyy-MM-dd HH:mm:ss')
			'Error' = $null
		})
		$totalSize = (Get-ChildItem -Path $_.FullName -File -Recurse -ErrorAction SilentlyContinue | Measure-Object -Property Length -Sum).Sum
		$documentsSize = (Get-ChildItem -Path "$($_.FullName)\Documents", "$($_.FullName)\Desktop" -File -Recurse -ErrorAction Stop | Measure-Object -Property Length -Sum).Sum
		$out.'Total Size (MB)' = '{0:N2}' -f ($totalSize / 1MB)
		$out.'Documents Size (MB)' = '{0:N2}' -f ($documentsSize / 1MB)
	} Catch {
		$out.Error = $_.Exception.Message
	}
	$out
} | Export-Csv -NoTypeInformation -Path $File

Select allOpen in new window

Thanks,
this can be used on remote machine as well right if we change 'ComputerName' = $env:COMPUTERNAME

No. That's just a string taken from an environment variable, it has nothing to do with remote access.
You'd need to set the initial path in line 4 to "\\remotemachine\c$\Users" and adjust the computer name in line 8 accordingly.

Thanks,

I changed the script it didnt work

$File = 'C:\data.csv'  

$Exclusions = 'Administrator', 'Default', 'Public'
#Get-ChildItem -Path "$($env:SystemDrive)\Users" -Directory | Where-Object {$Exclusions -notcontains $_.Name} | ForEach-Object {
Get-ChildItem -Path "\\remotemachine\c$\Users" -Directory | Where-Object {$Exclusions -notcontains $_.Name} | ForEach-Object {

	Write-Host "Processing $($_.Name) ..."
	Try {
		$out = [PSCustomObject]([ordered]@{
			'ComputerName' = remote machine
			'Profile' = $_.Name
			'Total Size (MB)' = $null
			'Documents Size (MB)' = $null
			'Created' = (Get-Item -Path $_.FullName).CreationTime.ToString('yyyy-MM-dd HH:mm:ss')
			'Error' = $null
            'Total User folder size' = "{0:N2} MB" -f ((Get-ChildItem C:\users\ -Recurse | Measure-Object -Property Length -Sum -ErrorAction Stop).Sum / 1MB)
		})
		$totalSize = (Get-ChildItem -Path $_.FullName -File -Recurse -ErrorAction SilentlyContinue | Measure-Object -Property Length -Sum).Sum
		$documentsSize = (Get-ChildItem -Path "$($_.FullName)\Documents", "$($_.FullName)\Desktop" -File -Recurse -ErrorAction Stop | Measure-Object -Property Length -Sum).Sum
		$out.'Total Size (MB)' = '{0:N2}' -f ($totalSize / 1MB)
		$out.'Documents Size (MB)' = '{0:N2}' -f ($documentsSize / 1MB)
	} Catch {
		$out.Error = $_.Exception.Message
	}
	$out
} | Export-Csv -NoTypeInformation -Path $File

Select allOpen in new window

In the script, i gave machine name in place of the remote machine, in the excel it has the user account which does not exist and the machine name is not correct as well, it has the machine name on which I am currently working on
PFA screen shot

error column in excel: The term 'aafwscpknxg2' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
Regards
AJ

You did not put quotes around the remote computer name in line 10.

Ya i saw that after posting the before comment, Thanks oBdA