6 Replies Latest reply on Apr 21, 2010 8:08 AM by pstewart726

    95th percentile report / combined total

    pstewart726

      Hi there...

       

      If you look at 95th Percentile Aggregation  this is pretty much exactly what I'm after but haven't found a reply anywhere.

       

      I'm not a SQL guy and looking for help on how to build a report comprised of serveral interfaces from several routes - display all of them graphically and then at the bottom of the report have all those graphs "added together" for a cumulative total   Each graph (including cumulative) must have 95th percentile.

      Is this possible with the current system?

       

      Paul

        • Re: 95th percentile report / combined total
          Questionario

          you cant graph custom reports... not with solarwinds products

            • Re: 95th percentile report / combined total
              pstewart726


              you cant graph custom reports... not with solarwinds products

               



               

              Really?  We when went through the purchasing cycle with Solarwinds we were told it was no problem to create custom reports - so we used this particular example and were told it was no problem to do.  I'm liking the product overall but this reporting/graphing issue is pretty major to us...

               

              Thanks for your response.

                • Re: 95th percentile report / combined total
                  byrona

                  Questionario is correct in that you can't create graphical custom reports from within SolarWinds.  In order to accomplish this you will need some external program that captures the data from the database with SQL queries and then graphs it for you.  SSRS (SQL Server Reporting Services) is one of the tools that can make this possible.

                  Also, it's possible to connect Excel to a database to pull data out with queries and then you could create a set of graphs from within Excel.

                  No matter how you do this it's going to require you pulling data from the database.  There have been a lot of requests for feature enhancements to allow you to create graphs using the custom reporting tools in Orion; you should find those feature requests and sign up for them.

                    • Re: 95th percentile report / combined total
                      pstewart726

                      Thank you for the responses.  We were told by our sales rep that this was specifically possible and it was a "heavy" part of our requirements when purchasing.  The direct response after our sales rep checked with engineers was "this is quite possible with the report writer to generate 95th percentile reports including graphs, along with a cumulative 95th percentile graph"

                      As it sounds like it's *not* possible that is disappointing - sounds like we won't have a choice but to use 3rd party to query the database and produce reports.... do you know how we find these feature requests and try to add some traction on this matter?

                      Cheers,

                      Paul

                        • Re: 95th percentile report / combined total
                          denny.lecompte

                          nexicom,

                          There's nothing you need to do to make PM aware of the feature request.  Graphs in reports is a key item for us.  

                          Given the way you describe it, everyone is right that it can't be done.  But it may still be that Orion can solve your problem.  Can you provide more detail on what you're trying to do?  What's the business problem you are trying to solve?  

                            • Re: 95th percentile report / combined total
                              pstewart726

                              Sorry for the delay in getting back to this post...

                               

                              We graph all IP Transit and IP Peering connections.  Our business costing model is based entirely on this data - also, we will our customers based on this information.  Looking up dozens of individual graphs and doing custom timeframe consumes a LOT of time.

                              We are also used to a "total bandwidth at a glance" type reports - we use the total aggregated bandwidth totals in 95th for trending analysis and planning etc.

                              Thanks,

                              Paul