Looking for a SQL script for elements per node

We have deployed four Orion NPM pollers (including the primary one). We want to try to split evenly the number of elements between all our pollers, but are having a very hard time. This is because Orion Report Writer does not seem to contain a search parameter that will allow us to get a count of elements per node. We think that this would need to be done via SQL script but don't know how.

Have any of you figured this out? If so, please share the SQL script if possible. Thanks!!!

Find more posts tagged with

Accepted answers

netlogix

What about these queries?

select Nodes.Caption, IP_Address, Count(*) As Interfaces
from Nodes inner join Interfaces on Interfaces.NodeID = Nodes.NodeID
group by Nodes.Caption, IP_Address

select Nodes.Caption, IP_Address, Count(*) As Volumes
from Nodes inner join Volumes on Volumes.NodeID = Nodes.NodeID
group by Nodes.Caption, IP_Address

All comments

njoylif

Try this on...remove columns as desired.

select
ServerName,
IP,
PollingCompletion,
Elements,
Pollers,
MaxPollsPerSecond,
MaxStatPollsPerSecond
from Engines

mr.e

njoyliff,

Thanks for the SQL script. However, the SQL script did not give us the results that we are looking for. This SQL script gives totals of elements for each of our pollers. We are actually trying to get a report that will tell us how many elements are taken up by each node. So, we are thinking of something that would contain the following information:

a.) Fist column -- Hostname

b.) Second column - IP address

3.) Third column -- Polling Engine where the node resides

4.) Fourth column -- number of interfaces monitored for the device

Does that above explain better what we are seeking? Once we have the above information, we plan to export results to Excel spreadsheet so we can do some analysis. This would help us get a good grasp of how many nodes to put on each poller.

Of course, we know we will not be able to have an even number of elements spread out through our four pollers. We just want for to do perform the load balancing without too much guess work or trial and error, which is what we currently do.

Again, thanks for the feedback.

netlogix

What about these queries?

njoylif

it is clear now what you are looking for.

let me know if netlogix queries don't give you what you are looking for.

thanks

mr.e

These queries gave me exactly what we were looking for. I am already working on the data we got from the exports. Thanks!!!