3 Replies Latest reply on Jan 25, 2018 10:41 AM by Greg Remer

    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