6,010
Is there any column that will show the last activity time for a user? I would like to be able to send email alerts to users who are logged in but haven't been active for 1 hour.
*This post is locked for comments
HI Sivakumar
Could you please help me how can i create job to delete user that idle time for example more than 7 minutes
Sivakumar,
This post got me to thinking that if I had a blog I would post this...
I now have a blog. http://rldu.wordpress.com
I have given you credit for this script! Thanks so much...it is an AWESOME script...
Sounds good Siva - thanks!!
Well Ron, get busy! :)
Man if I had a blog I would post it on it too :)...
Yes sir, Ron, it makes sense to me. I didn't think about using the SQL session timing to do this. Great idea Siva!! Would you mind if I post this on my blog?
Sivakumar,
Thanks...this is exactly what I needed.
Ron
Hi Ron
Yes. This looks at the SQL Session ID's in the tables in the tempdb, DYNAMICS and the master databases to identify which GP's processes are being run by a specific user and note the inactivity for each user.
Let me know if you need further assistance.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (