Directory Size and File Count with long file names

I want to preface this with I am fairly new to powershell.

We are trying to monitor a DFS share size across multiple end points and I have a powershell script using robocopy working locally. We cannot use the native get-childitem due to longfile names.

Below is the script, when testing against a node it is returning the message portion properly, but it is not returning the statistic (folder size). I have broken the script down into multiple steps to identify where it is failing and discovered it is not populating the $size variable. Again, it works perfectly when running locally from the Orion server (adding the ip manually), but returns null when running from SW template. When testing with "Get Script Output" it just returns 0 for the statistic.

Any ideas on what I am missing? Is this beyond the solarwinds powershell monitor capabilities or am I going about this incorrectly?

[string] $hostname = "${IP}"
[string] $strDir = "\\$hostname\share_name\tools"
$size = (robocopy $strDir 'NULL' /L /E /NP /NFL /NDL /bytes /njh | find "Bytes :")
$sizeb = $size.trim().split(" ")[2]
$sizec = $sizeb/1MB
$sized = [math]::round(${sizec},2)

write-host "Message.Size: ${strDir}"
write-host "Statistic.Size: ${sized}"
exit 0

This is the error I am getting when testing

Output: ==============================================
Message.Size: \\ip_address\share_name\tools
Statistic.Size: 0

Errors: ==============================================
You cannot call a method on a null-valued expression.
At line:5 char:1
+ $sizeb = $size.trim().split(" ")[2]
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

Find more posts tagged with

Accepted answers

All comments

christopher.t.jones123

@curtisr, the first thing that comes to mind would be credentials. Are you using the same credentials when running it locally on the SolarWinds server and when attempting to do the Get Script Output in the UI? If not, perhaps you try that, it could be that the credentials you are using in the web UI does not have the correct permissions to execute $size so it returns a NULL value instead of erroring out.

curtisr

Sorry for the delay and thank you for the response. My post got flagged as spam for some reason before the long weekend.

Your inquiry to the issue being rights related got me thinking and when i expanded my logging i found it was in fact a rights issue. Even though I was using the 'run the script under specified account' option. below is the script that 3ended up working, leveraging 'net use' to establish access.

Using this to compare DFS shares as an additional check on completeness.

$Dir = "\\${IP}\Share_name"

$c = Get-Credential -credential ${CREDENTIAL};
[string] $user = $c.Username;
[string] $password = $c.GetNetworkCredential().password;
net use ${Dir} /user:${user} ${password}

#/XD "${Dir}\DfsrPrivate" skips the dfs staging folders for more accurate counts and values
$RC_Results = robocopy $Dir 'NULL' /L /E /NP /NFL /NDL /BYTES /XD "${Dir}\DfsrPrivate"

# the summary table is the first 5 of the last 7 lines
$RC_Summary = $RC_Results |
Select-Object -Last 7 |
Select-Object -First 5

# add a 'Type' column header to the 1st line
$RC_Summary[0] = 'Type' + $RC_Summary[0]

# add placeholders for the blank 'Times' [last line] columns
$RC_Summary[-1] = $RC_Summary[-1].
Insert(39, 'N/A').
Insert(49, 'N/A')

$NewRC_Summary = @()

# line cleanup
foreach ($Line in $RC_Summary)
{
# remove leading and trailing spaces
$NewLine = $Line.Trim()
# remove ':' that are NOT in time spans
$NewLine = $NewLine.Replace(' :', '')
# replace multi-spaces with singletons
$NewLine = $NewLine -replace '\s{2,}', ' '
# remove space between number and unit letter [bytes, kilobytes, etc.]
# 1.22 m >> 1.22m
#$NewLine = $NewLine -replace '(\d)\s([bkmg])', '$1$2'
# replace remaining spaces with a comma
$NewLine = $NewLine.Replace(' ', ',')
# add to the new summary collection
$NewRC_Summary += $NewLine
}

$RC_SummaryTable = @{}
foreach ($Item in ($NewRC_Summary | ConvertFrom-Csv))
{
$RC_SummaryTable.Add($Item.Type, $Item.Total)
}

#use [long] to get around size limitations of int32 for large directories
$bigsize = [long]$RC_SummaryTable['Bytes']
$biggb = $bigsize/1GB
$bigmbround = [math]::round($biggb,3)

$fnumber = $RC_SummaryTable['Dirs']
$fsize = $RC_SummaryTable['Files']
$dsize =$bigmbround

write-host "Message.Size: ${Dir}"
write-host "Statistic.Size: ${dsize}"
write-host "Message.Files: ${Dir}"
write-host "Statistic.Files: ${fsize}"
write-host "Message.Directories: ${Dir}"
write-host "Statistic.Directories: ${fnumber}"
exit 0