Report with a Remediation Script

greg.remer

Hi Guys,

We currently have a report which finds all nodes not responding on SNMP which is created using SQL.

SELECT *, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(N.NodeID as nvarchar(256)) AS DetailsURL

,N.StatusLED AS Status_Icon

FROM NODES AS N

WHERE ObjectSubType<>'ICMP'

AND N.SysName NOT LIKE '%-LK%'

AND DATEDIFF(s, LastSystemUptimePollUtc, GETUTCDATE())>(PollInterval*3)

AND STATUS NOT IN (2,9)

ORDER BY LastSystemUptimePollUtc ASC

We would like to be able to run an automatic script to push some commands via NCM on the nodes found in the report?

Is this possible?

Thanks

Greg

Find more posts tagged with

solarwnds sql

npm reports

sql scripts

Accepted answers

derik.pfeffer

@greg remer,

You could always use the Alert Engine with the Action of running NCM script to do a similar activity.

Best Regards,

Derik Pfeffer

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems

Facebook: Loop1 Systems

Twitter: @Loop1Systems

All comments

derik.pfeffer

@greg remer,

You could always use the Alert Engine with the Action of running NCM script to do a similar activity.

Best Regards,

Derik Pfeffer

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems

Facebook: Loop1 Systems

Twitter: @Loop1Systems

greg.remer

Thanks Derik,

I have created an Alert, but having issues with Insert variaible for the

DATEDIFF(s, LastSystemUptimePollUtc, GETUTCDATE())>(PollInterval*3)

This is what I have done;

Any ideas?

Thanks

greg.remer

Hi Derik,

I have now managed to get this added as an Alert, thanks for the brief advise.

Thanks