SolarWinds v1.0.0 Connector Corrections

[spectrum_one]

Hi all, 

If case anyone has issues with SolarWinds Connector v1.0.0. 

Solarwinds after version 2023 has changed the API port from 17778 to 17774, to correct the above edit the connector with a new version and perform the following corrections. 

1) operations.py Line 38 change endpoint_url port from 17778 to 17774 

2) Line 66 change respone.json()['message'] to response.json()['Message'] 

Correction no 2 is to show the SWIS query errors. 

P.S. There is an error with get alerts and get events.

If you want to receive all active alerts utilise the following query. 

SELECT
    aa.AlertActiveID,
    aa.AlertObjectID,
    aa.DisplayName        AS ActiveAlertDisplayName,
    aa.Description        AS ActiveAlertDescription,
    aa.TriggeredDateTime,
    aa.TriggeredMessage,
    aa.Acknowledged,
    aa.AcknowledgedBy,
    aa.AcknowledgedDateTime,
    aa.AcknowledgedNote,
    ac.Name               AS AlertName,
    ac.Severity           AS AlertSeverity,
    ac.AlertMessage       AS AlertMessage,
    ao.EntityType,
    ao.EntityCaption      AS AlertObject,
    ao.EntityDetailsUrl   AS AlertObjectUrl,
    ao.RelatedNodeId,
    ao.RelatedNodeCaption AS NodeName,
    ao.RelatedNodeDetailsUrl AS NodeUrl
FROM Orion.AlertActive AS aa
JOIN Orion.AlertObjects AS ao
    ON aa.AlertObjectID = ao.AlertObjectID
JOIN Orion.AlertConfigurations AS ac
    ON ao.AlertID = ac.AlertID
ORDER BY aa.TriggeredDateTime DESC

FortiSOAR 

S