Hi,
I guess the easiest way to get the logoff time is to map the session to
your User Login id. Afterwards you can always overwrite the logoff time
with the current time when the session is verified - thus you have the
time of the last request as the logoff time.
Cheers,
Stefan
Roy El-Hames wrote:
Zhiming;
There is nothing within the RT code that allow for this ..
I have a similar requirement, which I will be starting to work on in the
next couple of weeks .. if you wish we can exchange ideas ..
What I had in mind is :
Create new table UserLogins (3->4 fields --keeping it small
..(id,UserId, LoginTime,Logoff time)
create appropriate classes using factory
grab user login(session starting ) from web.pm and populate the table
with id,UserId, LoginTime
I am still investigating how to trap the session end .. anyone any ideas
?? but once its known you can update that row with logoff time
Roy
Zhiming Liu wrote:
Hi, can someone help me to write a query for
users/super users:
select all of modified tickets since last login
Thanks, Zhiming.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com _______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy
a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
