• Replies 2 replies
  • Subscribers 338 subscribers
  • Views 108 views
  • Users 0 members are here
Related

How to check who is logged on, for concurrent user count

Nathanael Pearson
$organization

Is there a way to check which users are logged onto CITRIX at any one time? We occasionally hit our cap, and I want to be able to check on who's online, to see if we can disconnect any unused accounts.

Is this possible, without checking through each and every user in the selfservice tool?

Parents
  • $organization
    Hi Nathanael,
     
    This query will bring back all logged in users by querying TX_MACHINE_LOCATION for Logout Date < Login Date. When users log out, the Logout date is > than the login date.
     
    I restricted this to just last login date of Today. I wouldn’t go too far back though. We have a lot of stale data in that table where for whatever reason the user never logged out properly (maybe tessitura crashed or whatever).
     
    There may be other ways to do this that I don’t know about. This just took less than a minute to get who logged in today who is still logged in.
     
    SELECT * FROM TX_MACHINE_LOCATION tml
    WHERE tml.last_logout_dt < tml.last_login_dt
    AND last_login_dt >= CONVERT(DATE,getdate())
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
Reply
  • $organization
    Hi Nathanael,
     
    This query will bring back all logged in users by querying TX_MACHINE_LOCATION for Logout Date < Login Date. When users log out, the Logout date is > than the login date.
     
    I restricted this to just last login date of Today. I wouldn’t go too far back though. We have a lot of stale data in that table where for whatever reason the user never logged out properly (maybe tessitura crashed or whatever).
     
    There may be other ways to do this that I don’t know about. This just took less than a minute to get who logged in today who is still logged in.
     
    SELECT * FROM TX_MACHINE_LOCATION tml
    WHERE tml.last_logout_dt < tml.last_login_dt
    AND last_login_dt >= CONVERT(DATE,getdate())
     
    Jerry Boutot | Manager, Information Technology - Data
    O: 813.222.1097 C: 352-428-4199
     
Children