Re: How to Find Client OS type from Oracle 8174......

From: Jose Luis Delgado <joseluis_delgado_at_yahoo.com>
Date: Fri, 05 Dec 2003 12:34:26 -0800
Message-ID: <F001.005D8F36.20031205123426@fatcity.com>

Man...

it's just a bit difficult to find that you want only in Oracle...

but can try this:

1.- There is an utility on Windows 2000 Resource Kit called: gettype.exe, it can help you to determine your OS Type (it works with the errorlevel), you need to be logged in your domain to make this works, else, it gets errors.

2.- You can combine with an sqlplus script to get your desired results.

3.- There you go:

gettype \\machine_name <-- get it from v$session.

errorlevel means:

Returns 1 for Windows NT Workstation.
Returns 2 for Windows 2000 Professional installation. Returns 3 for Windows NT Server Non-Domain Controller. Returns 4 for Windows 2000 Server Non-Domain Controller.
Returns 5 for Windows NT Server Domain Controller. Returns 6 for Windows 2000 Server Domain Controller. Returns 7 for Windows NT [Enterprise/Terminal] Server Domain Controller
Returns 8 for Windows NT [Enterprise/Terminal] Server Non-Domain Controller

--ELSE--
Windows 95 or 98.

Testing should be done.

Is this enough?
If not... I have the utiilty and can email to you off-list... then if you need a bit of help for making your script, I can try to help you too.

Best regards!
HTH
JL

• Janardhana Babu Donga <jbdonga_at_ucdavis.edu> wrote:
  > Dear List,
  >
  >
  >
  > We have TXN processing system with as many as 900
  > users log in at any point
  > of time. We have the necessity to find what OS type
  > the client is using
  > (Windows 95, NT 2000 etc). I tried thru V$SESSION,
  > V$SESSION_CONNECT_INFO
  > and V$PROCESS, but couldn't find any useful info to
  > get the client OS type.
  > I also looked at the NET8 documentation to see if I
  > can get any such info. I
  > am not successful in getting such information from
  > any source.
  >
  >
  >
  > I tried setting LOG_DIRECTORY_CLIENT and
  > LOG_FILE_CLIENT in SQLNET.ORA, but
  > it is not generating any logfiles.
  >
  >
  >
  > Could some one help me how I should get such info.
  > Appreciate a reply.
  >
  >
  >
  > -- Janardhana
  >
  >
  

  ---

Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: joseluis_delgado_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Dec 05 2003 - 14:34:26 CST