The most recent content from our members.
Hi Trying to create a Dashboard for whole infrastructure certificate expiry check. But stuck somewhere and we need to create an alert if expiry is near. Like Cisco, WIndows Server, IIS, Palo Alto, SD-WAN and etc.
Greetings, I need to get IP Addresses of Interfaces (which are in NodeIPAddress basically but couple more info from Nodes and NPM Interfaces also. Came up with this query but for every Interface, the IPAddress table is repeated. So instead of 19 rows, I get 437 rows. Can someone with knowledge help please. SELECT DISTINCT…
Hi All. In my shop we run a lot of script monitors. We collect both the 'Message' fields for string data, and 'Statistic' fields for numeric data. We have a number of consoles that display the Statistic and Message data. The Message data comes from the APM.DynamicEvidence table - StringData field Last week we upgraded to…
Hello All, I am attempting to create a SWQL or SQL query that will return the average availability of the entire network (All monitored nodes) for the last month. We currently have a web report that does this but would like to integrate this metric to a Power BI dashboard. However, when running SWQL or SQL against the…
I'm trying to join two working scripts into one but I'm a beginner at this scripting. Script #1: I have a SWQL script to pull last month user login. SELECT tolocal(TimeLoggedUtc) as [Login] , AccountID , AuditEventMessage FROM Orion.AuditingEvents ae WHERE daydiff9timeloggedutc, getutcdate())<31 AND…
Hey folks, Hoping y'all can help me out a bit here - I'm a bit of a novice when it comes to databases, and I'm hitting some snags with a business request that's come in. We're looking to create a report that outputs sums of interfaces in a given VLAN, per node, grouped by their container. I can get somewhere with SWQL to…
Where in the database would I find the details for file paths being monitored by a File Existence Monitor component? I am in the process of building detailed reports for our nodes, applications, and components we have configured.
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'm having trouble find the right SWQL to add the current values of two custom pollers to a report. The query I've been working with: SELECT ONPMC.Node.Caption, ONPMC.Node.IPAddress, ONPMC.Node.IOSImage, ONPMC.CustomPollerName, ONPMC.AssignmentName, ONPMC.CurrentValue AS FlashSize FROM…
With the help of antonis.athanasiou (yay MVP collab!), I came up with the following born out of need: SELECT TriggeredDateTime,OAA.AlertObjects.Node.Caption as [Node] --find nodes,OAA.AlertObjects.Node.CPULoad --change this to any relevant node metric,OAA.AlertObjects.Node.DetailsUrl as [_LinkFor_Node] --add hover…
It looks like you're new here. Sign in or register to get started.