4 Replies Latest reply on Mar 31, 2009 10:20 AM by kiwi

    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

        • Re: Availability by Region > Branch
          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

            • Re: Availability by Region > Branch
              kiwi

              Hi Miron, Thanks again for your reply.

              I assigned the Regions/Branches to Nodes in Custom Property and getting them listed, cascaded as I need Orion GUI console, fine.

              - Now the Fileds: Region & Branch are not available to choose from in a New report when I clikc on Node Details.

              -Second, I need to average on all interfaces of all Nodes of the Region = East for Yesterday for example.

                • Re: Availability by Region > Branch
                  Miron

                  Mate,

                  They wont be under Node Details go to > Network Nodes> Custom Properties

                  this is where you will find your custom properties.

                  Under Select Fields Tab.

                  Add Field: Availablity sort * Function AVERAGE

                  Under Time Frame Tab.  Selct the Yesterday under the named Time Frame option drop down.

                  Regards

                  Miron

                    • Re: Availability by Region > Branch
                      kiwi

                      Thanks Miron. Great, I got it now.

                      Any idea on how to be specifc about time range of the day, like 8AM to 6PM ?

                      or may be this can only be done from "Advanced SQL" in thi scase wher can I find the SQL code I generated from my last report so I may edit it and add the time frame ?

                       

                      Rgrds.