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)