How to recognize Client PC

navuser1

Dear All,

Is there any possibility to know unique Id (like name, IP, etc.) of a Client PC which is accessing my NAV 2013 R2 database through NAV-tier ?

Kindly inform.

MarvinPowell

Hi, there are two ways that I know of:

1) Create A Function that will return the current computername:

PROCEDURE GetCurrentComputerName@1000000000() ComputerName : Text[100];
    VAR
      WshNetwork@1000000000 : Automation "{F935DC20-1CF0-11D0-ADB9-00C04FD58A0B} 1.0:{093FF999-1EA0-4079-9525-9614C3504B74}:'Windows Script Host Object Model'.WshNetwork";
    BEGIN
      CLEAR(WshNetwork);
      CREATE(WshNetwork,TRUE,TRUE);
      ComputerName := WshNetwork.ComputerName;
    END;

2) Check the Session table. It has a column "Client Computer Name". If you want to get the Client Name visible in the RTC, you might have to add this column to the Session List Page.

navuser1

MarvinPowell wrote:

Hi, there are two ways that I know of:

1) Create A Function that will return the current computername:

PROCEDURE GetCurrentComputerName@1000000000() ComputerName : Text[100];
    VAR
      WshNetwork@1000000000 : Automation "{F935DC20-1CF0-11D0-ADB9-00C04FD58A0B} 1.0:{093FF999-1EA0-4079-9525-9614C3504B74}:'Windows Script Host Object Model'.WshNetwork";
    BEGIN
      CLEAR(WshNetwork);
      CREATE(WshNetwork,TRUE,TRUE);
      ComputerName := WshNetwork.ComputerName;
    END;

2) Check the Session table. It has a column "Client Computer Name". If you want to get the Client Name visible in the RTC, you might have to add this column to the Session List Page.

No. 1 is working fine but I have not found the column name Client Computer Name in the Session Table..

MarvinPowell

Hi,

I've checked in NAV 2013 and NAV 2013 R2:

Table ID: 2000000110 - Active Session
Field No.: 8 - Client Computer Name

That field should give you the client pc name. :thumbsup:

navuser1

=D>