ServiceNow Graph Connector - Solarwinds for Asset information polling

Good afternoon

We are trying to implement the following on our Orion/ServiceNow setup

https://investors.solarwinds.com/news/news-details/2020/SolarWinds-Announces-Integration-With-ServiceNow-Service-Graph-Connector-Program/default.aspx

Service Graph Connectors harness the expertise of ServiceNow technology partners and ServiceNow engineering to provide a quick and reliable means of bringing third-party data into the ServiceNow Service Graph and Configuration Management Database (CMDB). The Service Graph Connector for SolarWinds Orion enables customers to:

  • Automatically populate the Service Graph and CMDB with inventory discovered by SolarWinds Orion Platform products, including network devices, server systems and public cloud instances. This augments the information populated in CMDB by ServiceNow.
  • Schedule synchronization and reconciliation of asset data with Service Graph and CMDB including system hardware components, network interfaces, operating system details, installed software, cloud instance information, and more.

This is for Asset polling , not alert and ticket generation management integration to ServiceNow. This requires a connection from ServiceNow to your Solarwind ORION 17778 ports ( API ) call to work . On Solarwinds ORION all you need to do is create a user with WebLogin access basic permissions and on ServiceNow you need to setup a Connector as per screenshot with that User ID:

These settings ( out of the box base path path/ connection URL ) do not seem to work as per below

When ServiceNow tries to connect we keep getting a ERROR 400 bad request ..

whats interesting enough if i try doing a CURL call via command line to the same basepath/connection URL path, i get the same error 400 bad request.. anybody know or has setup the Connector on ServiceNow properly?

curl -k -v -u USER:PASSWORD https://websitename:17778/solarwinds/informationservice/v3/json/query

HTTP/1.1 400 Bad Request

Parents
  • In your CURL example, I don't believe you'll be able to call ./query without actually defining a query, otherwise you'll get a 400 error. However, if you add a simple query, you should be able to run it in CURL like you're attempting to. For example,

    Curl.EXE -k -u USERNAME:password https://<IP>:17778/SolarWinds/InformationService/v3/Json/Query?query="SELECT+TOP+1+NodeID+from+Orion.Nodes"

Reply
  • In your CURL example, I don't believe you'll be able to call ./query without actually defining a query, otherwise you'll get a 400 error. However, if you add a simple query, you should be able to run it in CURL like you're attempting to. For example,

    Curl.EXE -k -u USERNAME:password https://<IP>:17778/SolarWinds/InformationService/v3/Json/Query?query="SELECT+TOP+1+NodeID+from+Orion.Nodes"

Children
  • Thanks for the response GKJONO , as per my screenshot ( configurations on ServiceNow, out of the box configurations) we cannot get ServiceNow to poll/ even test load data from our SW instance at all.. below is the error.. have you be able to get this going ?

    com.snc.process_flow.exception.ProcessAutomationException: Error creating Attachment raw_page_stream : Method failed: (/api/now/hub/temporaryattachment) with code: 400

    The curl statement is correct and works perfectly fine from Windows commandline using the same account we are trying to setup for the Graph Connector on ServiceNow..  do you know if the account has to have certain permissions in NPM/SAM to be able to pull data ? The ServiceNow graph connector requires a service account that has access to your Solariwnds NMP/SAM instance.