01-14-2019 04:36 AM
Hello Together,
We have a customer with 16 Concurrent licenses. with the modul "report services" i can see that all licenses are used. The customer now needs to know who (Username) is consuming those licences. According to the customer it makes no sense that 16 licenses are used as just 5 people working with a concurrent licence.
How can i see the user names or machine names from all the users which are at the moment using a concurrent licence?
Many thanks for your time and advice
Marc
01-14-2019 05:58 AM
Hi Marc,
I believe the easiest way to view this information would be by navigating to Admin | User Management | View Current Users in the Thick Client. A window with detailed information about which Licenses are being used and which User Account/Workstation is consuming said License will be displayed.
Hope this helps!
-Joel
01-14-2019 05:59 AM
Hi Marc,
Looks like this was posted multiple times, but I'll trow my response here as well.
Joel is absolutely correct. The easiest way to see this is actually via the Thick Client. You can go to "Thick Client > Admin > User Management > View Current Users", and this will show you a list of the users currently active with a Concurrent Client license and the time it was consumed.
If you don't have Thick Client access and/or would rather do this via SQL Query (to use on the fly or to put in Report Services), you can use the following query below (note that this query has been shortened compared to the Thick Client results to only show active username and the related workstation name):
select ua.username, ru.registername
from hsi.loggeduser lu
join hsi.registeredusers ru on lu.registernum = ru.registernum
join hsi.useraccount ua on lu.usernum = ua.usernum
where lu.producttype = 16
The query may need to be adjusted for Reprot Services, but this should get you/your customer the info that they are looking for.
Best,
Ryan
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.