Re: SQL to get IP and OS

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 05 Jul 2007 16:31:21 -0700
Message-ID: <1183678281.565745.102750@w3g2000hsg.googlegroups.com>

On Jul 5, 5:12 pm, sybra..._at_hccnet.nl wrote:

> On Thu, 05 Jul 2007 11:54:51 -0700, Jeff B <jbis..._at_yahoo.com> 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
>
> Before applying kludges recommended by Netcomrade look into the
> sys_context function and the dbms_utility package (or that manual). I
> know there are calls in dbms_utility.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Jeff, you can get the host name and IP via the Oracle supplied package utl_inaddr.

There are numerous dictionary and v$ views that contain information that potentially could provide enough information to ID the OS. Take a look at product_component_version, database_properties, v$version, v $instance, and v$database.

HTH -- Mark D Powell -- Received on Thu Jul 05 2007 - 18:31:21 CDT