Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Check poller status power shell script

I am trying to check all the poller status and alert is any are down. I can use this in the database manager to see the KeepAlive time

SELECT KeepAlive FROM [dbo].[Engines]

I need to be able to execute it with SWQL or Swiss to assign it to a variable in a power shell script to check it against the current time to alarm if it is not close to the current time. Can anyone give me the syntax to use to do this?

Find more posts tagged with

Accepted answers

All comments

jamison.jennings

SELECT KeepAlive FROM [Orion].[Engines]

jamison.jennings

Or for extra fancy:

SELECT Servername, KeepAlive

,CASE

when SECONDDIFF(KeepAlive,GETUTCDATE())>1440 then round(SECONDDIFF(KeepAlive,GETUTCDATE())/1440.0,1)

when SECONDDIFF(KeepAlive,GETUTCDATE())>60 then round(SECONDDIFF(KeepAlive,GETUTCDATE())/60.0,1)

else SECONDDIFF(KeepAlive,GETUTCDATE())

end as [Time Down]

,CASE

when KeepAlive is null then ''

when SECONDDIFF(KeepAlive,GETUTCDATE())>3600 then 'Hours'

when SECONDDIFF(KeepAlive,GETUTCDATE())>60 then 'Minutes'

else 'Seconds'

end as [ ]

from orion.Engines

leidos

I get this when I do that.

Select-Object : A positional parameter cannot be found that accepts argument 'FROM'.

At C:\users\x_parkerrl\Documents\pollercheck.ps1:41 char:17

+ $plrtim = SELECT <<<< KeepAlive FROM [Orion].[Engines]

+ CategoryInfo : InvalidArgument: (:) [Select-Object], ParameterBindingException

+ FullyQualifiedErrorId : PositionalParameterNotFound,Microsoft.PowerShell.Commands.SelectObjectCommand

leidos

Sorry that was what I got from the first one. This is what I get from the "fancy"

Missing expression after unary operator ','.

At C:\users\x_parkerrl\Documents\pollercheck.ps1:43 char:2

+ , <<<< CASE

+ CategoryInfo : ParserError: (,:String) [], ParseException

+ FullyQualifiedErrorId : MissingExpressionAfterOperator

jamison.jennings

sorry, I'm not so great at powershell.

The queries I gave you run in SWQL studio for me though, or in a custom query resource box.

mesverrum

<#------------- CONNECT TO SWIS -------------#>

# load the snappin if it's not already loaded (step 1)

if (!(Get-PSSnapin | Where-Object { $_.Name -eq "SwisSnapin" })) {

Add-PSSnapin "SwisSnapin"

}

#define target host and credentials

$hostname = 'localhost'

#$user = "admin"

#$password = "password"

# create a connection to the SolarWinds API

#$swis = connect-swis -host $hostname -username $user -password $password -ignoresslerrors

$swis = Connect-Swis -Hostname $hostname -Trusted

<#------------- ACTUAL SCRIPT -------------#>

$pollers = get-swisdata $swis @"

SELECT Servername, KeepAlive

,CASE

when SECONDDIFF(KeepAlive,GETUTCDATE())>1440 then round(SECONDDIFF(KeepAlive,GETUTCDATE())/1440.0,1)

when SECONDDIFF(KeepAlive,GETUTCDATE())>60 then round(SECONDDIFF(KeepAlive,GETUTCDATE())/60.0,1)

else SECONDDIFF(KeepAlive,GETUTCDATE())

end as [Time Down]

,CASE

when KeepAlive is null then ''

when SECONDDIFF(KeepAlive,GETUTCDATE())>3600 then 'Hours'

when SECONDDIFF(KeepAlive,GETUTCDATE())>60 then 'Minutes'

else 'Seconds'

end as [ ]

from orion.Engines

mesverrum

You can do all the date calculation stuff in PoSH if you like but its easy to do directly in the sql by adding a where condition such as "where minutediff(keepalive,getutcdate())>10 --only shows engines that haven't updated in the last 10 minutes"

wluther

leidos I just use the default alerts thing, which has worked great for me.

wluther

I also run one on my interfaces, as I have been seeing various nodes lose polling to interfaces only, while still pulling in node stats.

leidos

Thanks. What is PoSH?