Skip to main content
S
Sathish
Newcomer
January 25, 2022

Active Users

  • January 25, 2022
  • 3 replies
  • 0 views

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 application.

3 replies

M
MichaelSBrokaw
Newcomer
January 25, 2022

There are XF MarketPlace solutions you may leverage for this. Developed by OneStream with no additional cost.

Security Audit Reports

Set the Start Date and End Date at the top of the dashboard then Refresh. To derive active user count, take the difference between Total Users and Inactive Users from the table at the top left of the dashboard. Active Users would include any user who has logged on at least once during the set date range.

image

Standard Application Reports

Includes User Log Activity reports. Could use this to get logon count by user.

    N
    NicolasArgente
    Veteran
    January 25, 2022

    The active users are stored into the OneStream Framework database.
    The SQL Query to get the list of users can be seen in a simple Dashboard Data Adaptor by running this
    SELECT
    SecUser.Name
    ,SecUser.IsEnabled
    ,SecUser.Description
    FROM OneStream_Framework.dbo.SecUser

    Thanks

      O
      Oscar
      Contributor
      May 13, 2022

      Hi !

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

      N
      NicolasArgente
      Veteran
      May 16, 2022

      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.

        O
        Oscar
        Contributor
        May 16, 2022

        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

          K
          Kreasoner
          Newcomer
          June 3, 2022

          Thanks for all the information to get this data.   

          Terms & ConditionsAccessibility statement