[rt-users] Query tickets login?

[Stefan Franck]

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: sales at bestpractical.com
>>
>>
>> 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: sales at bestpractical.com
> 
> 
> 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
>