• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 38 subscribers
  • Views 144 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Combined Report - Availability and Statisics in 1 place

deverts

All,

Before this network engineer spends countless hours trying to learn SQL, has anyone already built something similar to this that I can plagiarize, and modify to fit my own needs.  I need a report, very similar to the 10.2 version of "Interface Availabilty" that shows node or group availability and interface statistics.

Example:

"Group"  "Availability"  "Node"  "Availability"  "Interface"  "Availability"  "Peak util"  "Avg util"  "Business hours util"

Site1          99.9%      Router1        98%          s0/0/0:0         98%           100%          50%                75%

Site1          99.9%      Switch1        100%         g0/0               100%         25%            5%                  20%

Site2 - same as above

Many thanks in advance...

D

  • 0

    Hi deverts--

    You have some options here.  The Content Exchange and Report Lab forum would be a good place to search through for the specific type of report you are looking for.  Also, there is a recent discussion here on combining two reports (similar to what you're looking for).  The people on that thread might be of some assistance as well.

    Hope this helps,
    DH

  • FormerMember
    0 FormerMember

    @Deverts

    I have used ugly SQL syntax to achieve my requirement.

    I have wrote two SQL query and UNION results.

    1. Create SQL query for host availability.

    2. Create SQL query for application availability

    3. UNION both Query result to display them in single report.

     

    I know its sounds ugly but it works! for me. also if you know some sql stuff then you can store result in temp table and later call them to represent on one page.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.