Powershell Invoke-sqlcmd not working in Monitor Template Powershell Module - Forum - Server & Application Monitor (SAM) - THWACK

Server & Application Monitor (SAM)

Forum Powershell Invoke-sqlcmd not working in Monitor Template Powershell Module

State Not Answered
Replies 3 replies
Subscribers 17 subscribers
Views 179 views
Users 0 members are here

Options

jonathanlippe 19 days ago

if i run from Powershell command line on server i get results.

if i run from script body i get "not defined"

i've added invoke sqlcmd on all of our Solarwinds Servers.

Parents

0 bobmarley 15 days ago

I format mine a little different but they run.

Invoke-Sqlcmd -Query "MyQuery From @Results" -ServerInstance "SQLServerName" -Database "DatabaseName"
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 bobmarley 15 days ago

I format mine a little different but they run.

Invoke-Sqlcmd -Query "MyQuery From @Results" -ServerInstance "SQLServerName" -Database "DatabaseName"
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK^© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.