Hello, I want to make a report including all nodes of a network which are down, their down time and the duration. I managed to get only the nodes with a duration which is less than a month (31 days), though there are some with a duration of hundreds of days. Here is the SWQL code I currently have (the Orion Platform…
I've been stumbling around Thwack and everywhere else in the Google land and haven't yet been able to figure out how to run a report against a group of interfaces that I created using Dynamic Queries. It seems that I can only create a report that reports on the Interface status, description, etc. But nothing that allows me…
I know there are reports that will allow you to find out what IOS is on a device. What I would like to know is, if there is a way to sort devices just by IOS? I would like to know what IOS is out there and how many devices its on. Possibly a widget, something similar to "End of support devices" or "Total nodes by type"…
Cisco Devices grouped by IOS version
I need to add 18 interfaces to this query: 9056 works DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @StartDate = ${FromTime} SET @EndDate = ${ToTime} SELECT Interfaces.InterfaceId, Nodes.NodeID, Nodes.Caption AS NodeName, Interfaces.Caption AS Interface_Caption, Maxbps_In95, Maxbps_Out95, Maxbps_In99,…
I'm trying to track down a flaw in the logic of one of my reports, and hope I'm missing something simple. I have a total of 10 interfaces on a single Juniper device that I'm polling for detailed statistics every 1 minute. Using these statistics, I've created both a chart and a report that shows the max transmit bps values…
Based on Request from Span off Time for Acknowledgement, this report was created. It shows the acknowledgement for the last hour, last day, last week and last 30 days. Note: On systems with large amounts of active alerts, you are recommended to delete the "Last 30 day" portion or change other filtering.
I created a simple transform for an APC UNDP to display Amps instead of Amps X 10 which the OID returns. This works fine in the web display for node details but I would like to put that in a report. At present the report displays both the results returned by the OID and by the transform which makes it difficult to read.…
Is there an 'easy way' to modify the Logo & custom footer information in every report, and bulk change the email message content and from address for 90+ reports that are sent via 35+ schedules every Monday morning? As of July 1, we will have a new name and everything has to magically cut over at midnight.
I am starting to move reports from an old NPM 11.5.2 (Orion Platform 20415.1.2) to a new, up-to-date instance. As part of one report , I SELECTed SNMPV3AuthMethod and SNMPV3PrivMethod from [dbo].[NodesData] in SQL. The NodesData table in the new Orion database no longer includes these two fields. Does anyone know where is…
It looks like you're new here. Sign in or register to get started.