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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
