how to see active user connection?

• whitlander

  SSChasing Mays

  Points: 637

  More actions

  February 22, 2011 at 6:56 am

  #245899

  Now and again i need to restart reporting services. Unfortunately I don't have an easy way to ascertain whether users are logged on when I do this, so inevitably end up throwing people off.

  I could log log on the to box that ssrs sits on and run netstat, but was wondering if people here know of a plugin to report manager that can tell what users are logged in and active.

  Andy

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  February 23, 2011 at 7:47 am

  #1290407

  Hi,

  Hope this query helps. Kindly run this statement in your "reportserver" Database and "reportservertempdb" should be your reportserver temp DB.

  select usr.username , reportpath, expiration

  from Users usr,

  reportservertempdb..SessionData ses

  where usr.UserID = ses.ownerid

  order by 1

  Note: if i close the report from browser the session closes 5 minutes closely after the expiration time in my server.

  Regards
  Durai Nagarajan