Network availability report and event correlation

Good day,

Is there any easy way to tie event correlation with node availability in a report? In example, if you are running daily network availability reports and need to manually report on any node that is less than 100.00% average availability is there a way to automatically pull in details pertaining to the reasoning as to why the node was less than 100% available?

I have attached a sample of the way the current report is generated.

Report example.xlsx

Find more posts tagged with

Reports

network_monitoring

npm

Accepted answers

All comments

Prineel

Hi, have the same requirement, did you manage to get the report?

adam.beedell

I dont think there's really an "Easy" way, but perhaps something like:

3 part report (pseudocode)

1st part - main availability report:

Select [whatever details you want] from orion.nodes n where [device scope] and

(

n.availabilitydetails.timestamp > adddays(getutcdate(), -30)

and

n.availabilitydetails.timestamp < getutcdate() [or end-of-report-date]

)

Probably with a window function of some sort like ORDER and PARTITION, i'll call that last bit [date scope]

2nd part - Node events matching those on availability report with downs:

Select top x [Event details] from

(

[1st part]

AND

[availability] < '100'

)

left join Orion.events e on a.nodeID = e.netobjectID

where

[date scope]

and

e.netobjecttype like 'N'

ORDER by NodeID, Timestamp

3rd part

[something like 2nd part but bringing in other objectypes, out of time to think about how that'd work today]