Availability by Region > Branch

kiwi

Hello

I grouped my devices by Region then by Branch then by Vendor

Cascaded Grouping Levels Exple:  East > London > Cisco > Router1

I want to have Availability statistics by any of these grouping level, to see how the whole Eastern Region is performing, or what is Cisco devices availabilty just in London ? Something like:

Availability for yesterday : East    95%

Availability for yesterday : East > London > 97%

Availability for yesterday : East > Galsgo  > 92%

Availability for yesterday : East > London > Cisco   > 96%

Availability for yesterday : East > London > Juniper > 97%

Thanks

Miron

Hey mate,

didnt you ask this already or asking for it to be displayed on the webpage as a drill down option and not a report.

If it is a report, then you will have to create a report for each one of those levels you want in report writer it is easy enough without having to use SQL statements.

Report 1

Select Fields. Region sort * function *

Filter Results. where Region is equal to East

Report 2

Select Fields. Region sort * function *

Select Fields. Location sort * function *

Filter Results. where Region is equal to East

Filter Results. where Location is equal to London

 

and so on.

Regards

Miron