Question

Logging user login and their environment

  • 5 October 2021
  • 4 replies
  • 249 views

Userlevel 2
Badge +5
  • Do Gooder (Customer)
  • 5 replies

Hi!

As we have a lot of users using both mobile/portal and smart client, we’d wan’t to track the usage of the different “licenses used”.

F.ex a named user has the ability to both log in to the mobile, portal and smart client, but is there any way we are able to log/track usage of each of these?

We’ve tried adding br’s for person_login_history to add data when the table is inserted to, but to no avail, as this seems to be inserted before the br’s are able to run.

So, is there a reasonable way to differentiate between different types of login and be able to log this information?


4 replies

Userlevel 6
Badge +22

Hi Bjørn,

the obvious out-of-the-box solution would be to manually monitor it by accessing the License Administration Screen available in Smart Client.

Further, you might create a report based on some SQL queries. The mx_t-Table is logging all currently consumed/assigned license tokens. A license token is generated upon first user login and is created for each client (Smart, Mobile, Web, Portal, etc.). Thus, you would see a couple of tokens created for one and the same user. You would also need to join that table with the person-table to get all the information.

Some example query to fetch all User assigned a STUDIO license AND consumed a token:

 

select person_id, status, last_logged_in from person

inner join mx_t on mx_t.mx_t_02 = person.person_id

where person.metrix_user_type = 'STUDIO';

 

Hope that helps!

 

Best regards

Roman

Userlevel 2
Badge +5

That solution will only be valid if the user is logging in to it’s licensed environment.

F.ex if the user has a named license and is logging in on the mobile, how do we then differentiate that and a login on the webclient or smart-client?

Is there any information on the mx_t table which would tell us if the user is logging in on the mobile?

Userlevel 6
Badge +22

As far as I know, this information can’t be fetched from the mx_t-table.

@Lee Pinchbeck do you have any idea, if that can be achieved somehow?

Best regards
Roman

Userlevel 7
Badge +24

Hi @Bjorn @roklde,

A mobile license will be consumed for every active mobile device in the database. Note this is per device not per user so a user with multiple devices will use multiple licenses. Also, the license is consume whilst the device is marked as active in the database and not only whilst the user is logged on via the mobile.

When a user logs on to the mobile app they are authenticated but it should not, at that point, change the license in use numbers as they will be using the mobile license that has already been accounted for by having an active device.

Likewise, when they log in to the web/smart client there will, at that point, be an increase in the number of named or studio licenses as the mobile license is not used for the web/smart client.

Kind regards,

Lee Pinchbeck

Reply