7 Replies Latest reply on Jun 7, 2017 11:30 PM by tdanner

    ServiceNow Event Management Integration

    pranavpparmar

      Has anyone used the out of box integration that is available with ServiceNow Event Management for Solarwinds Connector?

       

      We are not able to post the REST API to SolarWinds node. Following are the details:

       

      https://<IP>:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT%20TOP%2010%20NodeID%20FROM%20Orion.Nodes

      Basic Auth:

      Content Type : application/json

       

      ServiceNow Event management uses this API to poll the alerts. I tried to use the Postman as well but it gives me the same error. 403-forbidden.

       

      Is there any specific access required on Orion?

       

      Thanks

      Pranav

        • Re: ServiceNow Event Management Integration
          tdanner

          Are your basic auth credentials valid in Orion? Do they work in SWQL Studio?

            • Re: ServiceNow Event Management Integration
              pranavpparmar

              Hi tdanner,

               

              I tried using SWQL studio and I was unable to connect from that as well. I we try with normal DB connection it works.

               

               

              Error.png

              • Re: ServiceNow Event Management Integration
                yagyavir.singh@gmail.com

                From Orion SQL server, i am able to connect to database using Microsoft SQL Studio using my personal account and with DB account which is used during configuration.

                Connecting from SWQL gives below error while using "server type" value as "Orion(V3) over HTTPS" or "Orion(V2) over HTTPS" or Java over HTTPS

                Appreciate any support on this.

                 

                Detailed error:

                 

                the end of this message for details on invoking

                just-in-time (JIT) debugging instead of this dialog box.

                 

                 

                ************** Exception Text **************

                System.NullReferenceException: Object reference not set to an instance of an object.

                   at System.Windows.Forms.DataObject.DataStore.SetData(Object data)

                   at System.Windows.Forms.DataObject.SetData(Object data)

                   at System.Windows.Forms.Control.DoDragDrop(Object data, DragDropEffects allowedEffects)

                   at SwqlStudio.ObjectExplorer.TreeMouseMove(Object sender, MouseEventArgs e)

                   at System.Windows.Forms.Control.OnMouseMove(MouseEventArgs e)

                   at System.Windows.Forms.Control.WmMouseMove(Message& m)

                   at System.Windows.Forms.Control.WndProc(Message& m)

                   at System.Windows.Forms.TreeView.WndProc(Message& m)

                   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

                   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

                   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

                 

                 

                 

                 

                ************** Loaded Assemblies **************

                mscorlib

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

                ----------------------------------------

                SwqlStudio

                    Assembly Version: 2.2.54.0

                    Win32 Version: 2.2.54.0

                    CodeBase: file:///C:/Program%20Files%20(x86)/SolarWinds/Orion%20SDK/SWQL%20Studio/SwqlStudio.exe

                ----------------------------------------

                SolarWinds.Logging

                    Assembly Version: 2.2.54.0

                    Win32 Version: 2.2.54.0

                    CodeBase: file:///C:/Program%20Files%20(x86)/SolarWinds/Orion%20SDK/SWQL%20Studio/SolarWinds.Logging.DLL

                ----------------------------------------

                System

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

                ----------------------------------------

                System.Windows.Forms

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

                ----------------------------------------

                System.Drawing

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

                ----------------------------------------

                System.Core

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

                ----------------------------------------

                log4net

                    Assembly Version: 1.2.13.0

                    Win32 Version: 1.2.13.0

                    CodeBase: file:///C:/Program%20Files%20(x86)/SolarWinds/Orion%20SDK/SWQL%20Studio/log4net.DLL

                ----------------------------------------

                System.Configuration

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

                ----------------------------------------

                System.Xml

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

                ----------------------------------------

                SolarWinds.SDK.Swis.Contract

                    Assembly Version: 2.2.54.0

                    Win32 Version: 2.2.54.0

                    CodeBase: file:///C:/Program%20Files%20(x86)/SolarWinds/Orion%20SDK/SWQL%20Studio/SolarWinds.SDK.Swis.Contract.DLL

                ----------------------------------------

                System.ServiceModel

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll

                ----------------------------------------

                System.Runtime.Serialization

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll

                ----------------------------------------

                SMDiagnostics

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll

                ----------------------------------------

                System.ServiceModel.Internals

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll

                ----------------------------------------

                System.ServiceModel.Web

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Web/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Web.dll

                ----------------------------------------

                System.Data

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

                ----------------------------------------

                System.IdentityModel

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.dll

                ----------------------------------------

                Microsoft.GeneratedCode

                    Assembly Version: 1.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

                ----------------------------------------

                ScintillaNET

                    Assembly Version: 3.5.6.0

                    Win32 Version: 3.5.6.0

                    CodeBase: file:///C:/Program%20Files%20(x86)/SolarWinds/Orion%20SDK/SWQL%20Studio/ScintillaNET.DLL

                ----------------------------------------

                System.IdentityModel.Selectors

                    Assembly Version: 4.0.0.0

                    Win32 Version: 4.6.1099.0 built by: NETFXREL4STAGE

                    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel.Selectors/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.Selectors.dll

                ----------------------------------------

                 

                 

                ************** JIT Debugging **************

                To enable just-in-time (JIT) debugging, the .config file for this

                application or computer (machine.config) must have the

                jitDebugging value set in the system.windows.forms section.

                The application must also be compiled with debugging

                enabled.

                 

                 

                For example:

                 

                 

                <configuration>

                    <system.windows.forms jitDebugging="true" />

                </configuration>

                 

                 

                When JIT debugging is enabled, any unhandled exception

                will be sent to the JIT debugger registered on the computer

                rather than be handled by this dialog box.

              • Re: ServiceNow Event Management Integration
                bluefunelemental

                I just looked through the connector definition and entered this into my rest client - responded with no issue.

                 

                HTTP GET with basic auth (local user created in Solarwinds GUI with admin rights):

                https://hostname:17778/SolarWinds/InformationService/v3/Json/Query?query=SELECT TOP 10 EventID,EventTime,NetworkNode,NetObjectID,EventType,Message,Acknowledged,NetObjectType,Timestamp FROM Orion.Events

                 

                {

                  "results": [

                    {

                      "NetObjectType": "C",

                      "Timestamp": [

                        "0",

                        "0",

                        "0",

                        "0",

                        "58",

                        "118",

                        "97",

                        "32"

                      ],

                      "NetworkNode": null,

                      "Acknowledged": false,

                      "NetObjectID": 109,

                      "EventTime": "2017-05-12T13:55:40.4130000",

                      "EventID": 20137020,.

                ........