Auto logout of idle RTC sessions

ugxfmsugxfms Member Posts: 7
edited 2012-10-25 in NAV Three Tier
Hi forum.
Looking for a solution to auto log off idle RTC sessions for a client. Too many users leave sessions running thus using up the license ](*,)
I have searched through the forums but havent seen any solution.
Please help.
Thanks :roll:


  • agentzagentz Member Posts: 14
    the core functionality is below.
    i use this as part of an automated webservice which fires every 60 seconds but has a maxIdle param and an exempt param.

    i've checked with my vendor before running this in a live environment to ensure it would not orphan any records or corrupt any indexes and they assured me it is fine.

    you will need an sa account to execute kill and the other sql statement to get current users.

    this is how you find current sql nav users (sorry, remove the 'usersExempt...' junk):

    SqlCommand cmd=new SqlCommand("SELECT ISNULL(usersExemptFromKill.editedBy, '') as editedBy, s.[Connection ID], s.[User ID], s.[My Session], CONVERT(VARCHAR(12), s.[Login Date], 107) AS [Login Date], CONVERT(VARCHAR(12), s.[Login Time], 114) AS [Login Time], s.[Database Name], s.[Application Name], s.[Login Type], s.[Host Name], s.[CPU Time (ms)], s.[Memory Usage (KB)], s.[Physical I_O], s.Blocked, s.[Wait Time (ms)], s.[Blocking Connection ID], s.[Blocking User ID], s.[Blocking Host Name], s.[Blocking Object], s.[Idle Time] / 60000 AS [Idle Time] FROM usersExemptFromKill RIGHT OUTER JOIN Session AS s ON usersExemptFromKill.userID = s.[User ID] WHERE (s.[Application Name] LIKE '%Dynamics%') and usersExemptFromKill.editedBy is null and ((" + idleLimitMinutes.ToString() + " - s.[Idle Time] / 60000) <=0 ) ORDER BY CAST(s.[Idle Time] AS bigint) DESC");

    SqlDataAdapter da = new SqlDataAdapter(cmd);
    SqlConnection cn = new SqlConnection(WebConfigurationManager.ConnectionStrings["NavConnectionString"].ConnectionString);
    System.Data.DataTable dt = new System.Data.DataTable("hitList");
    System.Data.DataView dv = new System.Data.DataView(dt);

    cmd.Connection = cn;
    cmd.CommandType = System.Data.CommandType.Text;


    this is how you kill the user by the id
    Private Sub killMe(ByVal connectionID As String)

    Dim cn As New SqlConnection
    Dim cmd As New SqlCommand
    Dim cmdText As String = "kill " & connectionID
    Dim connectionString As String = WebConfigurationManager.ConnectionStrings.Item("NavConnectionString").ToString

    cn.ConnectionString = connectionString

    With cmd

    .Connection = cn
    .CommandText = cmdText
    .CommandType = CommandType.Text

    End With


    End Sub
  • gycsiakgycsiak Member Posts: 19

    Maybe this was working for 2009 R2, but do you also have a solution for 2017 as well?

    FYKI, Session table with Idle time field doesn't exist any more, from SQL master..sysprocesses I can only see Service sessions, but not client connections running through the service, so I cannot register nor query Idle time for client connections.

    Any suggestions where I could query the idle time for a client connection or do you have any information, where the service is storing and registering the idle time for a client, where it can be queried?

    Thanks in advance,


Sign In or Register to comment.