The Help for 22.214.171.1246 says that "When the client and server are both on the same computer, an empty string is returned" but that's not completely correct.
When the client is an EVENT, it returns 'NA'. Does that mean 'Not Applicable'?
Likely answer: "Gosh, what do you think, Breck?" <g>
And here is another stupid question: Does it return 'NA' for SERVICE connections as well? ( I don't have any of those that last long enough to see :)
SELECT * FROM sa_conn_properties() WHERE PropName = 'NodeAddress'; Number,PropNum,PropName,PropDescription,Value 1000000107,193,'NodeAddress','Client node address','NA' 1000000021,193,'NodeAddress','Client node address','NA' 177,193,'NodeAddress','Client node address',''
asked 26 Feb '10, 09:14
I can confirm that result for 126.96.36.1996, and it's the same with 188.8.131.5286. And even for good old 184.108.40.20641 sa_conn_info() shows NA for an event's connection. Looks like it's always been there. So that might be the right time to request a documentation update (I don't have to point to to DCX, I suppose).
answered 26 Feb '10, 13:18