smross

So I i found another query on the forums here Re: Include downtime in current node down report I removed some of the custom stuff from that and ended up with this SELECT * N.StatusLED as Status,N.Caption AS Device,MAX(E.EventTime) AS DownTime, Cast(DateDiff(day,MAX(E.EventTime),getdate()) as varchar) + ' Day(s) ' +…

in Current Outage Duration for Down Nodes SQL query stopped working after upgrading to NPM 11.5.2 Comment by smross December 2015

3 nodes down When i execute the SQL query it doesn't find anything. I'm wondering if a table or something got changed? Am i looking for some data in the wrong place now?

in Current Outage Duration for Down Nodes SQL query stopped working after upgrading to NPM 11.5.2 Comment by smross December 2015

So i've installed hotfix 6 and still the same behavior. Can anyone tell me if the SQL query is still legit after the upgrade to 11.5.2? Im no SQL expert by any means.

in Current Outage Duration for Down Nodes SQL query stopped working after upgrading to NPM 11.5.2 Comment by smross December 2015

Changing the root directory from NCM fixed it. Thanks!

in SFTP Server keeps resetting root directory Comment by smross May 2013

Thanks for the reply - I did not - does the hotfix fix sql related things?

in Current Outage Duration for Down Nodes SQL query stopped working after upgrading to NPM 11.5.2 Comment by smross December 2015

smross

Comments