Query : Join table Alert

Question

Hello,

I read a query SQL for display a information of alert :

SELECT TOP (1000) AlertObjects.AlertObjectID, AlertObjects.AlertID, AlertObjects.EntityType, AlertObjects.EntityCaption, AlertObjects.EntityDetailsUrl, AlertObjects.EntityNetObjectId, AlertObjects.RelatedNodeCaption,
AlertObjects.RelatedNodeId, AlertObjects.RelatedNodeDetailsUrl, AlertObjects.RealEntityType, AlertObjects.TriggeredCount, AlertObjects.LastTriggeredDateTime, AlertObjects.Context, AlertObjects.AlertNote,
AlertActive.AcknowledgedBy, AlertActive.TriggeredMessage
FROM AlertObjects INNER JOIN AlertActive ON AlertObjects.AlertObjectID = AlertActive.AlertObjectID

And search a similar query in SWIS, but my request return none value

SELECT A.AlertObjectID, A.EntityType, S.TriggeredMessage FROM Orion.AlertObjects A JOIN Orion.AlertActive S ON A.AlertObjectID = S.AlertObjectID

I don't find a error

roadcycling · Accepted Answer

I found

[string]$AlertinfoFD = 'SELECT A.AlertObjectID, A.EntityType, S.TriggeredMessage FROM Orion.AlertObjects A JOIN Orion.AlertActive S ON A.AlertObjectID =  S.AlertObjectID where A.alertobjectID = ' + $AlerteID + ''

Regards