View OneStream licenses

[ianreid]

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

[NicolasArgente]

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

[aricgresko]

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

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

[SStalker]

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.

[NicolasArgente]

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

[SStalker]

Correct, it's the actual key.  

[ianreid]

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.

[SStalker]

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?  

[ianreid]

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.

[SStalker]

The license key does show number of users enforced.  The second field is the number of users allowed by the license.  If it shows 999999 then the license allows unlimited users, otherwise it should show the exact number of users allowed. If you are looking to see the number of users remaining...then you would have to calculate the difference between the number of users in the license & the number of users in system security that are enabled (OS does not count disabled users).

[aricgresko]

My answer does provide the number of users licenses available... are you trying to get more granular info that that (i.e., view, interactive, third party, etc.)

[ianreid]

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