ServiceNow Event Management Integration

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

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.

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.

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,.

........

I think you might be connecting to the wrong machine. Are you using the hostname of your Orion server or your SQL server?

I was connecting to SQL server.

Tried connecting to Orion server using Java over HTTPS -- Received same error as pasted above.

But if I try connecting using Orion (v2) over HTTPS i get below error.

After clicking Yes, i get the message that HTTP request was forbidden. Orion is running over HTTP and not with HTTPS.

I am using same service account which is used for polling other servers using WMI.

I have tried with my personal account which is an admin account also result in same error message.

Am i using a wrong account or missing some configurations? Today is my first day trying Solarwind SDK API's

In SWQL Studio, you probably want to do everything using the "Orion (v3)" type. The username/password you use should be one that can be used to log in to the Orion website.