0 Replies Latest reply on Mar 8, 2017 4:46 PM by wlipford

    Event Type Node Added - NCM vs NPM


      It appears Node Added event does not distinguish which module generated the message. I am trying to do a report that shows node growth stats from NPM only and it has NCM numbers included?


      How do I only show Node Added for NPM exclusively ?


      Here is my base query.


      select month(e.EventTime) as MonthAdded, count(n.NodeID)

      from nodes n

      inner join Events e on n.NodeID = e.NetworkNode

      where e.EventType = 9 and DATEDIFF(DAY,e.EventTime, GetDate()) < 180

      group by month(e.EventTime)

      order by month(e.EventTime)