I've tried the following but I an extremely helpful error message that says 'Invoke-SwisVerb : Unable to create application' Invoke-SwisVerb -EntityName 'Orion.APM.SqlServerApplication' -Verb 'CreateApplication' -Arguments @($nodeid,$applicationtemplateid,$credentialsetid,1) -SwisConnection $swis When I tried to supply an…
Hello Guys, i am trying to build a API call to update the alert with Incident number details. Which table i should update so that i can get it via reports.
Hey y'all So, my company uses an RTU which collects binary inputs from multiple devices connected to it and uses that to signify when the connected systems are in alarm. When their binary state changes it triggers a preset alarm. The following is the custom Poller table on the node which contains the alarms and which…
Howdy again y'all Trying to figure out how to do custom Severity, to look like this: I tried writing a case statement: However It doesn't show up in the format options. Does anyone know how to do this properly. (I can't pull it through the AlertObject) Thanks!
Hey everyone, i'm trying to cound the triggered alerts in a web based report for several Alerts, but i noticed that the IN statement takes only the first value inside parenthesis. here's the SWQL code: SELECT COUNT( AlertHistoryID ) AS [Alert Count] , oah.AlertObjects.AlertConfigurations.DisplayName AS [Alert Name] ,…
Hello Twack community, We are in the process of replacing old switches with new switches and have some questions regarding moving away from the WebUI. The goal is to utilize SWIS is the following: * Identify all interfaces monitored for a particular switch IP. * Delete all interfaces monitored for a particular switch IP. *…
Having an issue pulling data from two tables, normally I use a Join. This time I was trying this method of swql linked tables. It is throwing a common error but I cannot find it this time. error: Column is invalild in the select list cause it is not contained in the either the aggregate function or the GROUP BY clause.…
Hi, I need help in understanding if the above can be done with the SDK. Basically when a node sees its location custom property modified, it should be inserted in the world map (or edited if already there) with the coordinates for the location inserted (which are stored in a sql table on a separate db on the same…
Hey. Could you help me find the problem in my query? I'm trying to gather information about unknown SAM applications, and my query is working as expected, but I want to display "Never up" when the downtime column is NULL. SELECT ACP.Application.Name AS ApplicationName, ACP.Application.Node.Caption AS Node,…
Has anyone any ideas on how to join information from the ServiceNow integration tooling into queries about alert actions? What I need to do is to find Alert Actions that contain the CreateSniTicket action type - and then pull out the fields that are within that integration tool. The purpose is to update a pile of URLs that…
It looks like you're new here. Sign in or register to get started.