Hi, So I'm totally lost with SQL in the first place but with some issues with our product (upgrade in process) Im also unable to go onto the DB to try work out the SQL entry I need to query. Anyone able to help add Interface configured bandwidth to the below report? Need the none network teams to be able to register what…
We've recenly begun to use SolarWinds / Orion and have noticed something odd when we use scheduled reports. When we design and preview a report, any date columns are formatted correctly (UK date and time format). However, when those reports run on a schedule and are output as a pdf via email, the date is displayed in US…
As many folks have found, there is not currently a native method in the web report writer to allow for business hours reporting. This does not mean however that it cannot be done. In order to achieve a custom table with business hours filters, we must first start in the legacy Orion Report Writer. Your business hours…
Hi I need to create a monthly report showing Interface usage during office hours. A link to a post or documentation would be gratefully appreciated Regards
Unless I'm missing it, there isn't a OOTB UDT report (v2.5) that provides Used Ports/percentage, Free Ports/percentage, Total Ports per device like the UDT Ports in Use Overview graph below. Has anyone developed such a report they would be willing to share? I'm a UDT newbie and not strong in creating Advanced SQL reports…
hi, all. See that menu option Custom Poller (Current Status)? On my report writer, I don't see that option. I only see Network, Interfaces and Polling. Can anyone assist me in figuring out why thats not there? Thanks very much !
I would like to filter the Hardware Health Overview widget by a custom field "City". Is this possible? I have a SQL script to display data but can't select output and see groups like with the widget and no color just not as good. Regards, Here is the SQL script I'm using to start process: SELECT…
Hello, I'm trying to get a report written to show Make, Model, Serial Number, IPs and MAC addresses on Cisco devices. Using the Report Writer I can get everything except for the IP addresses on each interfaces. I'm able to show the polling IP of the device, but I'm not finding an IP Address option under Interfaces. I did…
To whom it may concern:· I need to run a report that will give me the In/OUT 95th percentile utilization in Mbps. · This needs to be a report that is ran once a month and reflects data for the last 30 days. · Report for global sites in different time zones· Needs to reflect only the 95th percentile for the hours of 8-5…
I am using a CAST function with SQL on an two existing columns. I would like to display the result of the CAST function as Bytes, but when I add the CAST column to the table, I am not given the option to select bytes. Is there a way to cast this so that I can display as Bytes instead of Integer or Decimal? CAST…
It looks like you're new here. Sign in or register to get started.