Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alert server

Status
Not open for further replies.
Zak2009

Zak2009

Programmer
Sep 4, 2009
325
KE
Hi all,

How can one configure the Alert server to check the idle time of users who have logged in and are not using and send an email to some one with there details.

Thanks
 
Sort by date Sort by votes
If u run on a terminal server you can configure idle times and force the user to log off.
 
Upvote 0 Downvote
In theory you should be able to poll the connections on an MSSQL database using EXECUTE sp_who2 and look at the Accpac databases only. The last batch field might give you what you need.
 
Upvote 0 Downvote
Hi johnhugh

On your comment above 'If u run on a terminal server you can configure idle times and force the user to log off. ' how is it achieved

Regards.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hushman
  • Locked
  • Question
Order entry & Purchase orders not opening on the server
Replies
1
Views
118
DjangMan
DjangMan
jsh8286
  • Locked
  • Question
One Database Slower then the Other - Terminal Server Setup
Replies
4
Views
137
jsh8286
jsh8286
kdien
  • Locked
  • Question
Insert record in SQL Server 1
Replies
3
Views
129
ettienne
ettienne
dikidushi
  • Locked
  • Question
Install Accpac pac Erp 300 on server 2012
Replies
3
Views
90
Jay Converse
Jay Converse
oxie18
  • Locked
  • Question
SQL Server connection conflict
Replies
5
Views
108
oxie18
oxie18

Part and Inventory Search

Sponsor

Back
Top