The most recent content from our members.
Can anyone help me with custom SQL reports? When I create custom reports, I usually start with one of the canned as a template and I have not been able to find/figure out the datetime (where between) stuff and get it working successfully. SELECT Convert(DateTime,Floor(Cast(DateTime as Float)),0) AS SummaryDate <.......>…
Orion 10.1 I have created a report to show all nodes that are or going to be unmanaged by using a advanced SQL report. I would now like to link the report to the nodes and have it only display if the current node is scheduled to be unmanaged. I was able to link the report but it shows all the nodes that are scheduled to be…
No matter which start date I begin with, the return value is always the same number. I tried one beginning in 2009 until today and it was the same number (100%). I call shenanigans on this custom SQL statement. Any ideas? SET DATEFIRST 6; SELECT 'Whatever Servers' AS Servers, AVG(ResponseTime.Availability) AS…
What are the limitations and pitfalls of showing SQL Reports from Orion Report Writer in Views where Limitations are applied? ---------- I have several different Views that I used for reporting weekly performance for different groups in our network. The views would include a Custom Network Wide Graph for the Last 7 Days…
I am looking to create a report that gives the following information per Interface for a given set of devices over a two week period. MaxAvgRecbps, MaxAvgTXbps, PeakRecbps. PeakTXbps. MaxRec%Util, MaxTX%Util and the time when the peaks and Maxs were reached. I am having trouble wrapping my head around the best way to do…
Help, I need to build an advanced SQL query report on a custom poller and I have no clue about sql queries. I have a custom poller for OID 1.3.6.1.4.1.9.9.23.1.2.1.1.6. It is pulling the CDP neighbors table, and it is working great. I now have a need to run a report that will list each host device and in a seperate column…
Hi everyone. I am trying to create a custom report to give me a list of sites with availability less than 95% over a period of 1 week.I have selected node name, IP address and availability under fields. The challenge comes when I try to filter fields specifying records that contain only records where availability is less…
OK I think I must have the folks at SolarWinds stumped with this one. I have opened a ticket for this issue but I haven't heard from them yet. Highly unusual for the SolarWinds tech support folks because they usually return calls within an hour..... So here it goes I will toss this question to the Forum and see what…
Hello All, I'm fairly new to Orion. Just wondering if theres a way to create a report depending on my cisco interfaces. ex. all serial 0/0/0. I've also been searching through posts and found a few custom reports. How do i import those, so i can use them myself? Ive tried going to file->new report-> advanced SQL and copying…
Well, i've beat up google and the documents and the forums and I'm either not finding it (most likely) or nobody has talked about it. We are running the latest version of Orion. I'm trying to figure out how to do either a custom report or custom view that would allow me to display the packets per second GRAPHs of multiple…
It looks like you're new here. Sign in or register to get started.