Re: SQL to get IP and OS

Jeff B wrote:
> Hello,
>
> I am using Oracle 10gR2 on Windows 2003 Server. Is it possible to
> retrieve the host's IP address and its OS version using a sql
> statement? I know that I can get the host_name from v$instance, and I
> can get the OS from the v$version, but I need more that just "Windows"
> for the OS. I'm looking for something like "Windows 2003 Server".
>
> Any ideas?
>
> Thanks in adavance!
> Jeff

SELECT sys_context('USERENV', 'IP_ADDRESS') FROM dual;

SELECT dbms_utility.port_string FROM dual;

If you want something else you'll need to explicitly describe it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org