Enterprise IDs once EOC is installed.

A work around I am now using is  (snippet)

FROM Orion.NodesCustomProperties NCP   

JOIN Orion.Nodes N on NCP.NodeID = N.NodeID AND NCP.OrionSite.SiteID = N.OrionSite.SiteID

JOIN Orion.UDT.PortUsage PU ON PU.NodeID = N.NodeID AND PU.OrionSite.SiteID = N.OrionSite.SiteID

Main Point is the Join on 2 fields in my case I was used NodeID and SiteID  from 3 tables,  in the entire query.

the Property NodeID was the same values in all 3 tables. I used the built in JOIN to OrionSite.SiteID, which was allowed in all thre3 tables

siteID NodeID            colum1                              2     portct     datetime         

In the modified for security output you can see how now the separate NODEID made that row distinct.

without the AND in the ON part of the join

although site would show different the other values would come from the first NodeID it found.  When using EOC NodeID is no longer unique as every site that ties into the EOC the Orion Server starts with NodeID 1.

I wish I found this a month ago.

I hope this helps someone.