May be i m wrong.
Can You Send Me The Sample Form .FMB On My Email Address
abmian1981@gmail.com
I have tried It On AS as Well On Runtime But Can't Get The Required Results.i want to store IP adress of Client Dataentry machine With Username and Timestamp.
Thanks in Anticipation
How to get HD serial and IP of a machine?
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
SCOTT@KSM> Select sys_context('USERENV','IP_ADDRESS') from dual;
SYS_CONTEXT('USERENV','IP_ADDRESS')
--------------------------------------------------------------------
192.168.1.7
SCOTT@KSM> Select sys_context('USERENV','OS_USER') from dual;
SYS_CONTEXT('USERENV','OS_USER')
--------------------------------------------------------------------
Kashif
SCOTT@KSM> Select sys_context('USERENV','TERMINAL') from dual;
SYS_CONTEXT('USERENV','TERMINAL')
--------------------------------------------------------------------
KASHIF
SCOTT@KSM> Select sys_context('USERENV','SESSION_USER') from dual;
SYS_CONTEXT('USERENV','SESSION_USER')
--------------------------------------------------------------------
SCOTT
All the Above Queries Result in on Client side.
as My database Server Name is DBserver. its IP address is Different then the Above. and it is Logined with the DSERVER.
Hope u understand it..
SYS_CONTEXT('USERENV','IP_ADDRESS')
--------------------------------------------------------------------
192.168.1.7
SCOTT@KSM> Select sys_context('USERENV','OS_USER') from dual;
SYS_CONTEXT('USERENV','OS_USER')
--------------------------------------------------------------------
Kashif
SCOTT@KSM> Select sys_context('USERENV','TERMINAL') from dual;
SYS_CONTEXT('USERENV','TERMINAL')
--------------------------------------------------------------------
KASHIF
SCOTT@KSM> Select sys_context('USERENV','SESSION_USER') from dual;
SYS_CONTEXT('USERENV','SESSION_USER')
--------------------------------------------------------------------
SCOTT
All the Above Queries Result in on Client side.
as My database Server Name is DBserver. its IP address is Different then the Above. and it is Logined with the DSERVER.
Hope u understand it..
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Sorry Mr Ahmad.
I check the Quires in the FORM. It is Not working in Developer 6i.
Giving error on SYS_CONTEXT (Unknown Identifier)..
But its Working Fine in SQL Plus. and Give the 100% Acurate result.
Sorry again.
Please Use the Following.
Select userenv('TERMINAL') from dual; (will Return Comuter Name)
Select USER from dual; (will Return Session User "Database User")
Select Sysdate from Dual (For Getting Current Time/Date)
Above 3 Queries are Tested in Forms 6i and Forms 10g as well.
I check the Quires in the FORM. It is Not working in Developer 6i.
Giving error on SYS_CONTEXT (Unknown Identifier)..
But its Working Fine in SQL Plus. and Give the 100% Acurate result.
Sorry again.
Please Use the Following.
Select userenv('TERMINAL') from dual; (will Return Comuter Name)
Select USER from dual; (will Return Session User "Database User")
Select Sysdate from Dual (For Getting Current Time/Date)
Above 3 Queries are Tested in Forms 6i and Forms 10g as well.
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Who is online
Users browsing this forum: No registered users and 12 guests