Show user names, which consume a Concurrent License at a specific time

[marc_ettelrin]

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

[Joel_Moore1]

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

[Ryan_Hughes1]

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