Get output failed error in PS script

Getting get output error while running below script

# Set the path to the directory containing the Excel files
$directoryPath = "\\njioilmssqlq01\VendorExport\CovertSheetWindSchExport"

# Get the current date
$currentDate = Get-Date -Format "ddMMyyyy"

# Construct the file pattern for today's Excel files
$filePattern = "*_$currentDate.xlsx"

# Get the Excel files matching the file pattern in the specified directory
$excelFiles = Get-ChildItem -Path $directoryPath -Filter $filePattern -File

# Get the count of Excel files
$fileCount = $excelFiles.Count

# Output the date and file count
Write-Host "Today's date: $currentDate"
Write-Host "Excel file count: $fileCount"

# Output the path and file names of the Excel files
if ($fileCount -gt 0) {
Write-Host "Excel files found today:"
foreach ($file in $excelFiles) {
Write-Host "Path: $($file.DirectoryName)"
Write-Host "File Name: $($file.Name)"
}
} else {
Write-Host "No Excel files found today."
}

Find more posts tagged with

sam

Get output failed error in PS script

Accepted answers

All comments

bucweat

I think you need to add "exit" to your powershell script. From the link I reference at end of post:

When Exit 0; (status of Up) is reported, the message and statistic are displayed and the monitor shows a status of Up.
When Exit 1; (status of Down) is reported, the message and statistic are not displayed and a status of Down is reported.

For example, if you want a script to inform SAM that a PowerShell script reports an Up status, exit the script using Exit 0.

Note that these exit codes override any status info generated by data you are passing back. In other words, if you set a critical alert if Excel file count is greater than 3, this alert will be overridden if you exit 1 or 2 or 3 from script.

https://documentation.solarwinds.com/en/success_center/sam/content/sam-script-report-status-through-exit-codes.htm

adam.beedell

In addition to an exit code as Bucweat mentioned, also you need to change the write-host to:

Write-host "Statistic: $statistic"
Write-host "Message: $message"

Where statistic is a int or a string that looks like an int, and message is a string. You can do up to 10 pairs of "Statistic.thing: $thing" too.

I've wrote similar file monitors and I'll say do test these a lot. I think the script as written exposes your servername, and will fail to monitor correctly when run with an agent or when the server or path or permissions are otherwise unavailable

mapujece

Hi, Do you know how to fetch the output from powershell script and convert it to string ? I was able to find anything that could help me with that issue. Now when I am trying to run script and get the output and display it or store as a string I receive the error like: “Check Outlook Failed, Reason: Object reference not set to an instance of an object.” Any help appreciated. Thanks, https://payplcalculadora.com/paypal-cost-calculator/

Sumit12

Howdy,

Check Option -

Run the script under specified account: should be mark true

adam.beedell

Write-host $error[0]
Or whatever sotherthing/things you want to output

(you're getting into something kinda deep here)

Sometimes I find it useful to sake a generic output block -
(
Write-host "Statistic: $statistic"
Write-host "Message: $message"
Exit 0
)

-and move it up and down the script to help debug. You dont need to though.

Generally if you've got a scripting environment somewhere configured to be about the same as what you're asking solarwinds to do, it should read out about the same but with more easy options to output and handle variables. Then switch into solarwinds once problems are solved