The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sathish's avatar
Sathish
New Contributor III
4 years ago

Active Users

SOURCE: ONESTREAM CHAMPIONS Hi All, Is there any way to see the active user count from the application? My requirement is to project the active users from the total users available in the appli...
Reports
Oscar's avatar
Oscar
Contributor
4 years ago

Hi !

This is good information! Is there a way to tell how many people are currently logged in the system?

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    4 years ago

    Yes, the easy way is to look into the log on activity under system and filter on the first column "Logged On". Otherwise you can have a look at the system DB UserLogonStatus (dirty way 🙂 .
    Please give a kudo if it helps, Thanks.

    • Oscar's avatar
      Oscar
      Contributor
      4 years ago

      I wrote the query below which is what we have been needing for a while in case anyone out there finds it of use.

       

      Select ULA.UserName AS USERNAME, SU.DESCRIPTION AS NAME, SU.EXTERNALUSERNAME AS EMAIL,
      CASE
      WHEN ULA.ClientModuleType = 0 THEN 'WINDOWS'
      WHEN ULA.ClientModuleType = 3000 THEN 'EXCEL'
      END AS MODULE
      FROM UserLogonActivity ULA,SecUser SU
      WHERE
      ULA.LogoffTime < '01/01/1901'
      and ULA.UserName = SU.Name