Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


On the server, you can get the user's ip-address using connection_property('NodeAddress').

Question: how on the server side (for example, in a procedure) to get the mac-address of the user ? After all, it is in the tcp/ip packet, so it can be obtained somehow ...

asked 06 May '21, 06:44

Stalker's gravatar image

accept rate: 11%

The server never sees the MAC address because that's all handled by the TCP stack. If the client is on the local network or subnet, you could invoke the 'arp' command via xp_cmdshell() to get a MAC address. If the client is not on the local network, there's no way to get the client's MAC address at all. At best you could get the MAC address of the closest router. That address is known to the TCP/IP stack but not the server. You could possibly deduce it using 'route' and/or 'traceroute'.

permanent link

answered 06 May '21, 06:54

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 06 May '21, 06:44

question was seen: 1,180 times

last updated: 06 May '21, 06:54