This is based on the the SWQL 95th Percentile Traffic Rate – Last Month report and now using SQL. I would like to be able to group the data by month summarizing all historical data. SELECT n.Caption as NodeName, format(DateTime,'MM/yyyy') as Report_Date, Max(In_Averagebps) as maxInMaxbps, Max(Out_Averagebps) as…
I am trying to write an SWQL query that uses a CTE WITH clause. I know it should be possible as I've found many examples on Thwack showing that it's possible. For the life of me, I cannot get any of the examples to work in either SWQL Studio or the web-based Report Writer. When I run an example I get the errors "mismatched…
I would like to create a report to show a list of nodes and how long each has been down in a certain time period. I've seen some reports like this in THWACK, but they were created in the report writer, which has been deprecated and will be going away in the next release. I have tried creating one in the web-based version,…
Hi Please help in generating report. Solarwinds reporting system is not generating report for hardware status. Its only showing if the status is up or critical but not displaying actual issue or details of the issue.
I have found a few threads on a similar subject, but nothing that is exactly what I want. I need a report that shows the following in a single query, or in 2 separate queries if necessary: 1. Nodes CURRENTLY Unmanaged showing when they were unmanaged, when they will be re-managed if available, and WHO did it. 2. List nodes…
Hi All I am looking to create a Monthly report which is to be sent out every month. There are over 600 devices and the requirements are Node and Interface Availability, CPU,Memory, Interface Utilization, All of them in excel format. All of them in a single report. Can this be done? TIA
I just found out that data in Orion.ResponseTime has 2 minutes interval per records and it only shows up to 5 days worth of data. Is there any other table where I could get historical data? I am looking into getting the average availability per node of Last Month.
Hi guys, I am trying my best to avoid using SWQL or SQL when creating this report but I'm not sure its possible. What I am trying to achieve is having a list of specific nodes (custom property based) show up if they don't have ANY UnDP/Custom Poller assigned. So far I've tried doing this by specifying either Custom Node…
Hi, I'm trying to find in Solarwinds Orion how to generate a historical report for only 1 device in our inventory. I only want to look at one day this week, and I want to the switch stacks utilization, cpu, any errors, etc. Any suggestions?
Does anyone have a report template which would allow me to compare the running config of two Cisco routers?
It looks like you're new here. Sign in or register to get started.