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

[Ryan_Hughes1]

Hi Marc,

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 (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