Hi Team, This highlighted subject report working fine in the old version of 2017.3.5, but now not working in the latest version of 2020.2.5 (we migrated recently) if we copied the same SQL command pasted over here. Report Name : 90/95/99th Percentile Traffic Rate - Last 7 Days ( working based on SQL query). Working -…
Hi, has anyone been successful in inserting an interface filter in out-of-the-box 95th percentile traffic reports in Orion? It uses a SWQL query, and if I insert a filter for a single interface, it would work. However, the tricky part is filtering for multiple interfaces (or devices), because when I do, it just provides me…
I wrote hard-edit SWQL for this month SELECT [data].[DisplayName] AS [Site] , [data].[ContainerStatus].[PercentAvailability] AS [PercentAvailability] , [data].[ContainerStatus].DateTime as [AvailabilityDate] , AVG([data].[ContainerStatus].[PercentAvailability]) AS [AveragePercentAvailability] , DateTrunc('Day',…
I have scoured the forums, I think, and I see lots of people asking this question, but no answer so far: There are several pre-canned reports for 95% percentile for Interfaces, but there doesn't seem to be a way to create a tabulated report (not a chart!) of CPU/Memory utilization for nodes. Am I missing something?
Hello, I'm new here, and I tried searching around and found nothing, so I thought this was the best place to start (apologies if this question belongs somewhere else). I am trying to use the existing "Lun Growth Report - 30/60/90/180 Days" to filter for specific LUNs as opposed to all of them. It's written in a SWQL query,…
This report shows nodes that have not been polling CPU data for 20 minutes or more. This report can be used to find devices that are no longer responding to SNMP, WMI, or agent collection but ARE still responding to ICMP and so their status is still "Up". This is dependent on nodes having been originally assigned to poll…
I have been tasked with creating an Executive Summary Report. We currently use N-Central RMM. The desired report would be a mix of several other reports to include network health score, client info, Server/Workstation Quantities with OS/Version/qty breakdown as well as software licenses, along with server uptime…
I have tried different reports but none of them really show what I am wanting. I am wanting to create a monthly report that shows how long interfaces have been down for on selected devices for the report so we can monitor what is no being used to remove unused connections. Is there a way to do this? I wish to have a report…
I need a little help in creating a report for Cloud Instances that is in the Solarwinds and see if it is added as a Node. I was able to figure out what tables and views are needed. First is the VIM_CloudInstances and then the VIM_VirtualMachineNodes. VIM_CloudInstances would contain all the Cloud Instances and there is a…
Hi All, There is a Orion.LicenseSaturation table in SWQL. Is there anything similar on the SQL tables? Thank you, Amit
It looks like you're new here. Sign in or register to get started.