Need to fetch node id in the existing query

You really should start leveraging the Navigation Properties instead of using all these JOINs.  Makes the queries easier to parse.

SELECT DISTINCT [AlertObjects].AlertActive.AlertActiveID
     , [AlertObjects].AlertObjectID
     , [AlertObjects].AlertConfigurations.Name
     , [AlertObjects].AlertConfigurations.Severity
     , [AlertObjects].AlertConfigurations.ObjectType
     , [AlertObjects].EntityUri
     , [AlertObjects].EntityType
     , [AlertObjects].EntityCaption
     , ToLocal([AlertObjects].AlertActive.TriggeredDateTime) AS [TriggeredDateTime]
     , [AlertObjects].LastTriggeredDateTime
     , [AlertObjects].AlertActive.TriggeredMessage AS Message
     , [AlertObjects].AlertActive.AcknowledgedDateTime
     , [AlertObjects].AlertActive.Acknowledged AS Acknowledged
     , [AlertObjects].AlertActive.AcknowledgedBy
     , [AlertObjects].AlertActive.AcknowledgedNote
     , CASE 
          WHEN Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 86400) > 0
               THEN ToString(ToString(Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 86400)) + 'd ' + ToString(Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 86400 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 86400))) + 0.0) / 3600)) + 'h ' + ToString(Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 3600 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 3600))) + 0.0) / 60)) + 'm ')
          WHEN Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 86400 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 86400))) + 0.0) / 3600) > 0
               THEN ToString(ToString(Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 86400 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 86400))) + 0.0) / 3600)) + 'h ' + ToString(Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 3600 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 3600))) + 0.0) / 60)) + 'm ')
          WHEN Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 3600 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 3600))) + 0.0) / 60) > 0
               THEN ToString(ToString(Floor(((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) - 3600 * (Floor((SecondDiff([AlertObjects].AlertActive.TriggeredDateTime, GetUtcDate()) + 0.0) / 3600))) + 0.0) / 60)) + 'm ')
          ELSE ''
          END AS ActiveTime
     , [AlertObjects].Node.NodeID
FROM Orion.AlertObjects AS [AlertObjects]
ORDER BY [AlertObjects].AlertConfigurations.Name
     , [AlertObjects].EntityCaption

In the Orion.AlertObjects table it appears you could use either EntityNetObjectID or RelatedNodeID as your node ID for your query. 

can u pls help with the query pls wher to add this entitynetobjectid in the above query ?

i am new to this platform , can u help me with the complete query pls

Already did.  The above query added NodeID at the end of the list.

As bobmarley suggested, you could also use the EntityNetObjectID but that would return the NetObjectID for anything - not just nodes.  For this screenshot below I added in the EntityNetObjectID so you can see the difference.

The first element shows a NodeID of 1, but an EntityNetObjectID of AM:2. Because this is an alert on an Application Component, it uses the AM prefix followed by the ID number for that Application Component.

Are you trying to build an Alert dashboard or something?  Because you can just import one that our members have shared from the Modern Dashboards Content Exchange.

The EntityNetObjectID in the Orion.AlertObjects entity isn't always a Node.  Sometimes it's a Volume, an Interface, an Application, or something else.  It all depends on the 'target' of the specific alert.  You are better off using the Navigational Properties and just connecting to the Orion.Nodes entity and retrieving the NodeID from that.

Thanks! 

Dear i had tried your query , when i executed urs which include nodeid  i am getting errror as bleow , using previous query not getting any error , can you please advice .

How many alerts do you have?  That's timing out, which means it's taking over 2 minutes (120 seconds) to pull back the data.

Can you run this query to get the size of the AlertObjects entity?

SELECT COUNT(DISTINCT [AlertObjects].AlertObjectID ) AS [TotalAOs]
FROM Orion.AlertObjects

In one of my labs, I have over 1,000 entries, but the results return in under 2 seconds.