How to get SQL server name and IP?

vh8000

Hi All

Is there any way to get the current login SQL Server name and IP address?

Thanks in advance.

mohana_cse06

You can get the server name in Table SERVER by filtering on MyServer = TRUE

To get the IP send nslookup + ServerName (which you get from above)
http://www.mibuso.com/forum/viewtopic.php?t=14707

stryk

mohana_cse06 wrote:

You can get the server name in Table SERVER by filtering on MyServer = TRUE

Have in mind that since NAV 5.0 this Server-Lookup-feature oly works on the server itself; remote clients will get wrong results!

Also, further information could be queried from the "Session" table.

mohana_cse06

stryk wrote:

mohana_cse06 wrote:

You can get the server name in Table SERVER by filtering on MyServer = TRUE

Have in mind that since NAV 5.0 this Server-Lookup-feature oly works on the server itself; remote clients will get wrong results!

Also, further information could be queried from the "Session" table.

Thanks stryk for info. :thumbsup: