Session begin time
Hi All, How to identify the start time of a session. Plese help. Regards Aboo
#!/bin/ksh
# rudy 04Jul98. Shows when a session originally connected
if [ $# -gt 2 ]
then
echo "Usage : $0 [-s <session> | -u user] "
exit 1
fi
GREENWICH_OFFSET=4
if [ $# -eq 2 ]; then
if [ $1 = "-s" ]; then
dbaccess sysmaster << eo_db 2>/dev/null | pg
select hostname[1,10], tty[1,8], sid Session, username[1,20],
(extend ('1970-01-01 00:00:00', year to second))
+ (connected - ($GREENWICH_OFFSET*60*60)) units second
Connected
from syssessions
where sid = $2
order by 5 desc;
eo_db
else
dbaccess sysmaster << eo_db1 2>/dev/null | pg
select hostname[1,10], tty[1,8], sid Session, username[1,20],
(extend ('1970-01-01 00:00:00', year to second))
+ (connected - ($GREENWICH_OFFSET*60*60)) units second
Connected
from syssessions
where username = "$2"
order by 5 desc;
eo_db1
fi
else
dbaccess sysmaster << eo_db 2>/dev/null | pg
select hostname[1,10], tty[1,8], sid Session, username[1,20],
(extend ('1970-01-01 00:00:00', year to second))
+ (connected - ($GREENWICH_OFFSET*60*60)) units second
Connected
from syssessions
order by 5 desc;
eo_db
fi
######## End #######
HTH
Rudy
Aboobacker V V wrote:
> Hi All,
>
> How to identify the start time of a session. Plese help.
>
> Regards
>
> Aboo