Fetching from CSV

Question

Hello.
Im not good at all at powershell.
But im trying to get out "RegistrationState" from a csv file made from "get-brokermachine"

So far its just a simple

$csv = import-csv c:\status.csv

write-host Statistic $csv.registrationstate

From this i get"

Get output failed:

Output: ==============================================

Statistic Registered

So i get the response that i want from the csv.

But Orion says "Test failed with unknown status"

and if i save and submit this monitor i get the error:
PowerShell script error. Scripting Error: Script does not contain the expected parameters or is improperly formatted. 'Statistic' missing.

Anyone know how i can get the statistic ouput not to fail ?

itsmedobby · Accepted Answer

Hi! Yes. I put this as answered because i figured it out.

I was not sure how the statistic portion of orion worked.

But after reading up on the script monitor documentation i got it to work.

I didnt know that the Statistic value had to be a numeral value.

So i had to rearrange some stuff.

Had to convert the answers from the csv to numeral values.

But so far it works pretty flawlessly.

[PowerShell] $csv = import-csv c:\status.csv # Internal variables, change underway to set - Pastebin.com

Fetching from CSV

Top Replies