Customized Availability Report

oskare

Hi all,

Hope someone will be willing to nudge me ( or push) in the right direction.

I want to make an availability report for certain selection of interfaces and hosts

I assume this is easy with good/great SQL query knowledge and in-depth knowledge of Orion.

But sine I´m lacking there I was hoping I could achieve this with what looks to be great wizards.

I need to know if what I want is possible using the wizard. And what steps I might be missing.

I want to pick:

• 10 interfaces
• 12 hosts

The report could me customizable to cover either:

• Summary for each item for the last month
• Summary for each item for the last week
• Summary for each item for the last yesterday

Prefer to split in multiple tables, below are possible layouts (not to be solved here, but visual often helps to understand my need if I am unclear).

I hope I can figure out myself something that will be nice to look at.

Part I

Group 1		Group 2		Group 3
host 1	100%	interface 1	99.995%	interface 6	99,0010%
host 2	100%	interface 2	99.995%	interface 7	99,0010%
host 3	100%	interface 3	99.995%	interface 8	99,0010%
		interface 4	99.995%	interface 9	99,0010%
		host 4	100 %	host 5	100 %

Part II

Group 1		Group 2		Group 3
interface 10	100%	host 9	99.995%	host 14	99,0010%
interface 11	100%	host 10	99.995%	host 15	99,0010%
host 6	100%	host 11	99.995%	host 16	99,0010%
host 7	100 %	host 12	99.995%	host 17	99,0010%
host 8	100 %	host 13	99.995%	host 18	99,0010%

...only read if you're an advanced user :-)

Can you make an availability report based on the summary of two interfaces or two hosts.

i.e. if I have a group of two interfaces or hosts, and I need both to go down to generate un-availability. If only one fails then I still have 100%

example:

host1 = 85%

host2 = 90%

host1 & host2 = 100%

interface1 = 99%

interface2= 95%

interf1 & interf2 = 99,9770%

oskare

...this has been solved. By using custom properties to do all the filtering. A bit teadious, was hoping for a interface and node selector ( drag&drop like in some menus.

So basically, create all the custom properties you need and apply them to interfaces/nodes. Use those properties to limit the report selection.

FYI: I even made a property that was tableorder, to more easily control where they got located in my report tables ( the column is hidden in the report but table is ordered based on it.)

• Create a report, example with custom table.
• Select Objects using:
  • Dynamic query
  • advanced Selector
  • Select field from custom properties
  • Set your criteria...
• Then I selected availability and all the custom properties fieldsI wanted into my table
• Took some tweaking to get the data aggregation and time window aligned.

Now I have a template to make reports for multiple nodes and interfaces.

Nice to look at, broken up with columns for nodes and interfaces separate and new headers for various systems

Easy to adjust the granularity of the data, example

• Report with average for last month
• Report with average for last week, but broken up per day.
• Report on every interval (5min) for the last 2hrs
• etc.. ( possibilities are endless)

....but still waiting for a parallel availability calculation/monitoring.

So if node-1 is down but node-2 is up this does not affect availability.

Only if two nodes are down at the same time I should get unavailability

I will have multiple groups like this, usually only two in a group.

reg.

Oskar