Hi All,
I am getting different values in report writer and web based report.
Could some one please explain why ??
e.g : In below snapshot Avg Transmit bps is quite different for test interface.
Thank you.
Prashant
The difference is that the legacy Win32 report writer is rounding up. Web based reporting is showing the five most significant digits.
Thanks aLTeReGo, but why it is showing avg transmit bps as 28.2 kbps in report writer and 63.2 kbps in web based report for test interface, it is different on some other interface as well. Is it some database issue ?
Since all the fields except the average transmit bps show the same values (aside from the rounding) I would expect that the legacy report write is actually pulling values from different places than what was selected for the web based report. Looking at the web UI on my server there are multiple fields called transmit bps or average transmit bps, and we would need to know specifically which ones were checked in both of your reports to verify that they are working with the same value. Also are all of the parameters exactly the same in terms of time of day filters or how far back the report is looking.
As an example, did the person who built the report click on transmit bps from the interfaces table then tell it to average that value (this wouldn't produce the expected results as the interface table is the latest values so it would just tell you what the bps is right now) or did they select the correct one from interface traffic history and then tell it to average those values? Did they do something else like accidentally set it to max or min the values in the historical table?
Both the report writer and web interface are working with exactly the same data set so the difference has to be in how the person building the report has defined the columns or the parameters.
-Marc Netterfield
Loop1 Systems: SolarWinds Training and Professional Services
Hi mesverrum, I am running the same report created in report writer. The output in report writer and web is different.
Just so you know, you're not going crazy. I too have also noticed this, but just recently. I have monthly availability reports being generated via SolarWinds and just so happened to notice that my percentages were off this month.
It turns out that when I run the Out-Of-The-Box "Availability - Last Month" report in Orion Report Writer and the EXACT SAME report from the web (since that option is checked on the report writers OOB report...) I get two completely different values. And they're not close enough count this as a rounding error.
See my screen shot below. This is the same server that shows in the exact same reports. One via the report writer and another via the web. Nothing at all has changed been modified with these reports. The 92.73% is the correct percentage as I know this server was down for a significant amount of time this month, enough to definitely not average 98.99% availability for the month.
I can view the SQL query being executed on the Report Writer report and the table that its referencing is the ResponseTime.Availability table. Unfortunately the web based version of this report does not allow me to view the SQL query being executed, but since its available in the web console specifically because it's made to be available from the report writer, they should both be making queries to the same table, or so I thought.
SELECT CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
Nodes.NodeID AS NodeID,
Nodes.VendorIcon AS Vendor_Icon,
Nodes.Caption AS NodeName,
Nodes.IP_Address AS IP_Address,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability
FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)
WHERE
( DateTime BETWEEN 37954 AND 37983 )
GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.NodeID, Nodes.VendorIcon, Nodes.Caption, Nodes.IP_Address
ORDER BY SummaryMonth ASC, 4 ASC
aLTeReGo
Is it at all possible that the web server you're using to access the web based report writer, or the machine you're using to access the web interface is in a different timezone than the Orion SQL server?
Hi Prashant
can you make sure you don't have any limitation assigned to your account please? You can check this on Settings-> All Settings-> Manage Accounts. Find your account and check if there is any limitation applied.
Raul Gonzalez
Prosperon - UK SolarWinds Partners
Installation | Consultancy | Training | Licenses
That's a really good factor to incorporate, but unfortunately no. Our Orion server, and the SQL server housing the Orion DB, are both housed in the same data center that is located within the same timezone as the browser / machines we are using to run the reports.
Is there any way at all to view the SQL query being executed by the web-based report? The web report seems to be the one calculating the average correctly. I'm curious to see if there is a difference in query structure or calculation between the Report Writer and the Web-based report.
Yes, but it's viewable only in the log files when in debug mode. I recommend that you open a case with support so we can investigate the discrepancy and determine which report is accurate.
