Powershell Monitor runs as version 1.0

Question

Hello!

I'm working on a monitor to execute a multiple SQL queries and manipulate the data. To do so, I am using the Invoke-Sqlcmd cmdlet to run the query. The script works just fine when saved as a ps1 file and run manually on the server.

BUT, in SAM, it gives the following error:

So after some research, I decided to check the Powershell version, and it shows as 1.0 in the application monitor.

Any ideas on why this is happening? I'm running the script as Local and impersonating credentials:

thulsey · Accepted Answer

Solution for those desperately trying to google it:

Powershell WAS running as v5, but the command I was running was showing v1 for some reason. The problem with my script is that I did not have the SqlServer module installed on the server I was polling against. To fix this, run the following command:

Install-Module -Name SqlServer

Once it's installed, the Invoke-Sqlcmd function will work just fine.

Powershell Monitor runs as version 1.0

Top Replies