Computer Name and/or IP Address

ta5 · 2006-11-09

Hi
How can I find out from a navision code unit on what computer (computer name, eg. xyws27) and/or its IP Address the code is currently running?
Thanks
Thomas

Waldo · 2006-11-09

In the session table you have a field called "host name".
You should filter on "My Session"=TRUE.

ta5 · 2006-11-09

Hi Waldo

Thanks for your post.
I have to problems:

1) I cant find the field in my 3.7 installation, it seems to be a 4.x thing?
2) On a test installation of 4.2 I see the field, but in host_name there is the name of the server, not of the client. ](*,)

Waldo · 2006-11-09

I'm using SQL Server 4.00SP2 and all is correct.

You're using 3.70 native?

Marije_Brummel · 2006-11-09

To find the computername you can also use

'Windows Script Host Object Model'.IWshNetwork_Class

as an automation control

Waldo · 2006-11-09

Nice one, Mark.

And it is automatically installed when Windows is installed ...

garak · 2006-11-09

Also possible

Takes back the Computername where navision runs
message(environ('computername'));

Takes back the connected Client Computername from where is connect to an terminalserver (like citrix or MS Terminalserver)

message(environ('Clientname'));

Let us know, If you need the IP.

Regards

ta5 · 2006-11-10

Hi
Thanx for your valuable help on this.
I've tested both (WSH and environ), works like a charm =D>

Thomas

Waldo · 2006-11-10

garak wrote:

Also possible

Takes back the Computername where navision runs
message(environ('computername'));

Takes back the connected Client Computername from where is connect to an terminalserver (like citrix or MS Terminalserver)

message(environ('Clientname'));

Let us know, If you need the IP.

Regards

OK, how about the IP?

garak · 2006-11-10

Ok, here the code for the ip.

1. create an singleinstance CU with variables to save the ip in an globel variable. Run this CU from CU 1 Company open (or your created cu). The reason for singleinst. CU is, an DOS Promp comes and users doesn't like it, ever see this promt

needed variables 

Name	DataType	Subtype	Length
WSHShell	Automation	'Windows Script Host Object Model'.WshShell	
WSHExec	Automation	'Windows Script Host Object Model'.IWshExec	
WSHTxt	Automation	'Windows Script Host Object Model'.TextStream	
FullCompName	Text		80
FullCompIP	Text		80


IF ISCLEAR(WSHShell) THEN
  CREATE(WSHShell);

WSHExec := WSHShell.Exec('nslookup ' + ENVIRON('computername'));

WSHTxt := WSHExec.StdOut;
WSHTxt.SkipLine;
WSHTxt.SkipLine;
WSHTxt.SkipLine;
FullCompName := COPYSTR(WSHTxt.ReadLine,1,80);
FullCompIP := COPYSTR(WSHTxt.ReadLine,1,80);
MESSAGE();
CLEAR(WSHShell);

MESSAGE(FullCompName);
MESSAGE(FullCompIP);

Regards

kriki · 2008-07-01

[Topic moved from Navision forum to Navision Tips & Tricks forum]

vikram7_dabas · 2009-11-25

Dear Concern
I want to know that where I have to write the following code in Navision codeunit,and following code only shows us the that client computer name not of others:

message(environ('computername'));

garak · 2009-11-25

Sorry, i doesn't understand your problem.
You want to know where you can write this codesnipes?

vikram7_dabas · 2009-11-25

Dear Concern
I want to know that where I have to write following code:

message(environ('computername'));

It means that in which codeunit I have to write above code.Suppose I m using Native DB (Local) and write code code in CU 1 in Function CompanyOpen, when I open any company then it shows me a message(means, Computer Name).And If I m using Navision SQL server then where I have to write code and how this code will be executed?

Okune_JR · 2020-11-05

Hey I want to pull a report that will pull the computer name of the user how can I get this?

irasoelbaks · 2020-11-05

Please check the Active Session table as this should hold the computer name of the user:

irasoelbaks · 2020-11-09

Please check the Active Session table as this should hold the computer name of the user:

Howdy, Stranger!

Quick Links

Categories

Computer Name and/or IP Address

Comments