rhether ✭✭✭✭✭

da bomb

 2025.1.1

Awesome, can't wait to try this, beats using SWQL studio

Same issue for me, "Application Dependency Polling Enabled" missing for some nodes that had it previously enabled.

This may help you get started: It shows the start and end time in the last 24 hours of a maintenance cycle. It's in SQL, just change it to SWQL SELECT TOP 2 [Message],[EventTime] As 'Event Time' FROM [dbo].[Events] WHERE [Message] LIKE '%Nightly Maintenance%' AND [EventTime] >= DATEADD(hh, -24, GETDATE()) --last y days…

Reach out to your account manager. You may get a faster response if you are close to your renewal date

I am using an email trigger when the alert triggers. Only thing I can't find is the variable to use for the name of the VM host. or the Log Entry Message There may be some trickery to finding this as the trigger comes from Log Analyzer. No luck with these variables: VM: ${N=SwisEntity;M=DisplayName}…

Hi Kevin, I've set this up as suggested. Thanks!

I could not do this in SWQL I was able to do it in SQL SELECT STRING_AGG(OriginalName, ' | ') AS result FROM [Orion].[dbo].[VIM_GroupingCustomPropertiesMapping] WHERE Name LIKE '%orion%' 

I tried that: ${N=SWQL;M=SELECT CONCAT(OriginalName,' - ') AS Tag FROM Orion.VIM.TagCustomPropertiesMapping WHERE Name LIKE '%ORION%' } Output is: orion1 - The issue is I have to CONCAT the result from the Query, combining x # of records onto 1 line

As I far as I have been told the SAML cert / configuration is tied down to a single physical server. Please let me know your results.

Just to clarify I am trying to reference the variable name for Trigger Value "18" in this case SELECT E0.[Uri], E0.[DisplayName] FROM Orion.NPM.CustomPollerStatusOnNodeTabular AS E0 WHERE ( ( ( E0.[CustomPollerAssignment].[CustomPoller].[UniqueName] = 'PeerAdvertised' ) ) AND ( ( ( E0.[RowID] = '192.1.168.1.1.1' ) AND (…

I have the SWQL code narrowed down to this: SELECT COUNT(Nodes.Caption) As Node FROM Orion.AlertHistory Alert INNER JOIN Orion.Nodes AS Nodes ON Alert.AlertObjects.RelatedNodeId = Nodes.NodeID WHERE (MinuteDiff(Alert.TimeStamp,ToUtc(GetDate())) < 120) AND (Alert.Message LIKE '%triggered%') My issue now is getting it into…

Yup, I was able to modify the alert to my needs. Forgot about the time being in UTC (ToUtc) Thank you

I tried with no success. The error is get in SWQL Studio is: no viable alternative at input 'WITH' After I type 'WITH', a drop down box appears with some operands, 'NOLOCK' does not appear. Tried brackets, no brackets.

I was able to figure it out a few hours after posting it. ${SQL:SELECT ISNULL('MyText :'+[RunBook],'') FROM [ORION].[dbo].[Nodes] where NodeID = ${N=SwisEntity;M=NodeID}} I was surprised I did not have to use 'CustomProperties.RunBook', I got away just using 'RunBook'

Yes, I have done the MIB walk, trying to find something descriptive that identifies the modules/cards.

We already have 1 world map created. Basically I want to create another one while leaving the current one in place. I like the features of the long / lat to display different Nodes / Groups

It is treating the links in the left navigation as Subviews which appears to be be using the limitation from the main view. Looks like it is not possible. 

I believe I found the issue. In the local poller library you must have "Wireless Heat Map" enabled and assigned to at least one node. It is only supported by Cisco devices. Mine are Aruba so I am out of luck.

I'm curious to see what polling times people are using for there disk space alerts. I have moved to new organization and they are polling every 3 hours. Thinking of changing that to every hours after someone asked me why it took 3+ hours to get an alert.

Are your rabbit log files excessively large as well? I've had some log files as large as 22GB and Tech Support advised me to reinstall RabbitMQ

Hi @Seashore, I will give it a try this week. I am positive I can get this working with your SWQL statement. The part about using SQL/SWQL in advanced alerts is it prefills part of the query as I have outlined in yellow. I guess you have to use an "INNNER JOIN" and continue from there. I guess the purpose of this is to…

Hi Chuck, Wondering if you could share this document with me. I am also in the process of integrating Solar Winds with Servicenow. Thanks, Rick

We need to manufacture these mugs in America and make America great again.

Around the cap, turns a white shirt into a brown shirt.

It is working now with the 32 bit drivers !

Doh!

I think you guys can read my mind like Google.

It worked for me.