Skip to main content
August 21, 2023

View OneStream licenses

  • August 21, 2023
  • 5 replies
  • 0 views

Is there a way to see the current OS license that is installed?  We have recently had the number of user licences increased and now want to check that this has been applied, I'd hoped this would be in an obvious place like the environment or security but can't see anything that shows the current license (just being able to see the number of enabled users that the license allows would be a good start).

5 replies

August 21, 2023

Hi Ian,
I am not aware of viewing the user licenses from the frontend. The license is copied and installed on the back end. Note that there are different license type you can purchase and which will affect the users access to artifacts and associated OS offerings (Interactive, View, Restricted, Third Party access, Financial Close - those are user types). Note also that if only the "enabled" users are counting, not the total you see under Users.
The easiest is probably to check your contract with OS.
Have a good day,
Nic

August 21, 2023

You can check the total license count by going to the Error log and filtering on the Description field like this.


aricgresko_0-1692621760591.png

Note, this will only give you the license count, not count per license type. 

August 22, 2023

You can view the license from the System tab.  Go to Database under Tools and scroll to the System database section.  Then select the "SystemInfo" table.


SStalker_0-1692713136194.png

 

August 22, 2023

Oh Nice!! Thanks SStalker I did not know that. It is the key, right? Not the amount of users.

August 22, 2023

Correct, it's the actual key.  

ianreidAuthor
August 24, 2023

Thanks all for these suggestions, unfortunately we don't seem to be able to see the actual license info we need, though your suggestion aricgresko gets us closest.  Unfortunately, for reasons that completely baffle me, there is no real time view of license info, this should be something that is available (probably in the environment view).  I'll raise an enhancement request for this I think, though for something so fundamental it seems disappointing to have to ask for it.

August 25, 2023

What specifically are you looking to see?  Did the SystemInfo row not contain the OS license?  Or are you looking to get other information from the application?  

ianreidAuthor
August 25, 2023

We specifically wanted to see the number of users that the license enforces, I guess we could maybe hack something together and combine different tables together to get the answer, but really this is such a simple and fundamental piece of information it should be readily available to be seen (maybe in the environment tool) without having to dive into system database tables I think.

ianreidAuthor
August 25, 2023

Ah, right, had no idea that was part of that field.  I'm tempted to ask if this is documented anywhere, but think I already know the answer to that question. Thanks