Most of the data in alert central is accessible via SWQL using the Solarwinds Orion SDK: Orion SDK Information
Use the Orion SDK 1.6 build 40 or later.
Server Name: HTTPS://<serverip>:443/services/InformationService
Server Type: Java over HTTP
User Name: <account configured with ADMINISTRATOR role>
3rd party integration with Alert Central is not officially supported, and we do not have any public documentation available for the schema, so use it at your own risk right now.
We are trying to connect to the Alertcentral through SDK to obtain information but when we try to do this with .net it doesn't work.
This is the code that we are using:
Dim pp As SolarWinds.InformationService.InformationServiceClient
Dim address As String = String.Format("HTTPs://lnXXXXX/services/InformationService", "lnXXXXX")
pp = New InformationServiceClient("BasicHttpBinding_InformationService", address)
pp.ClientCredentials.UserName.UserName = "admin"
pp.ClientCredentials.UserName.Password = "RXXXXXXXXXXX4"
pp.QueryXml("SELECT Id, Severity FROM AlertManager.Alert")
The error obtained is "SecurityNegotiationException" "No se pudo establecer una relacion de confianza para el canal seguro SSL/TLS con la autoridad lnXXXXX"
This error message is literally in spanish (we don't to translate it because we don't change the meaning).
Were you able to connect to Alert Central using the SWQL Studio?
Yes, with swql i can do it.
I downloaded the SDK and am am trying to connect via the SWQL Studio. Do I need to configure Alert Central for HTTPS? If so how do I do it? I need this capability to report on the productivity of the NOC. I wish the reporting was just integrated with Orion or you could do a standard SQL connection.@
You more than likely need to ignore certificate errors when you connect to the endpoint. I know how to do this in PowerShell and C# but not in vbscript. This looks promising though: