• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 15 subscribers
  • Views 361 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.

Difference between Report Writer Preview and web page

btp

I have made a report to list every interface belonging to a given node type, which has had >80% traffic the last 5 days. In the report writer preview it looks right (900 records right now..), but in the web page I only get two (2) results.

Another difference is that in Preview mode I get all records matching the filter, and on the web I get what it seems to be one per day.

report.PNGrreport1.PNG

Preview mode:

report2.PNG

Web page:

report3.PNG

  • 0

    FWIW - here is the SQL:

    SELECT  TOP 10000 InterfaceTraffic.DateTime AS DateTime,

    Nodes.Caption AS NodeName,

    Interfaces.Caption AS Interface_Caption,

    AVG(Case InBandwidth

                When 0 Then 0

                Else (In_Averagebps/InBandwidth) * 100

                End) AS AVERAGE_of_Recv_Percent_Utilization,

    AVG(Case OutBandwidth

                When 0 Then 0

                Else (Out_Averagebps/OutBandwidth) * 100

                End) AS AVERAGE_of_Xmit_Percent_Utilization


    FROM

    (Nodes INNER JOIN Interfaces ON (Nodes.NodeID = Interfaces.NodeID))  INNER JOIN InterfaceTraffic ON (Interfaces.InterfaceID = InterfaceTraffic.InterfaceID AND InterfaceTraffic.NodeID = Nodes.NodeID)


    WHERE

    ( DateTime BETWEEN 41240 AND 41245 )

    AND

    (

      (Nodes.CustomerName = 'core') AND

      (

       (Case InBandwidth

                When 0 Then 0

                Else (In_Averagebps/InBandwidth) * 100

                End >= 80) OR

       (Case OutBandwidth

                When 0 Then 0

                Else (Out_Averagebps/OutBandwidth) * 100

                End >= 80))

    )

    GROUP BY InterfaceTraffic.DateTime, Nodes.Caption, Interfaces.Caption

    ORDER BY 1 ASC, 2 ASC, 3 ASC
  • 0 in reply to btp

    It turns out that the tick "Group historical data by days" was giving me a hard time.

    Also explained here:

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.