MAM 7.6.1.2; Anywhere Work Technician 7.6.4; LDAP/LTPA Authentication

Question:

Is there a way to determine what users are currently connected to Anywhere?
 - Can I query the DB to get this information? Or is it available in the Maximo UI somewhere?

Thanks.


#Maximo
#MaximoAnywhere
#AssetandFacilitiesManagement

There is no inbuilt mechanism to identify users of Maximo Anywhere per-se.  By setting up a separate JVM for Anywhere users you can approximate the user count then by looking at user connection through that JVM. But other than that, there is nothing in-built to identify Mobile users of Maximo Anywhere.

I would imagine you can construct a mechanism that would allow you to identify users through additional fields on the person record and or user group membership.  This would be a construct however that may not hold up depending on how you build it.  Users can be members of different groups and it is possible to log into Maximo from a mobile device and NOT be using Anywhere.

------------------------------
Bradley K. Downing , MBA
IBM Certified Adv. Deployment Prof. Maximo v7.6.1
IBM
Bakersfield CA
------------------------------

Original Message:
Sent: Tue June 08, 2021 03:13 AM
From: User1971
Subject: Determine what users are connected to Anywhere?

MAM 7.6.1.2; Anywhere Work Technician 7.6.4; LDAP/LTPA Authentication

Question:

Is there a way to determine what users are currently connected to Anywhere?
 - Can I query the DB to get this information? Or is it available in the Maximo UI somewhere?

Thanks.


#MaximoAnywhere
#Maximo
#AssetandFacilitiesManagement

Thanks Bradley. That helps.

If I understand correctly:
I can query for who is using Maximo. And I can see what security groups they have. But I can't easily determine what they're using (desktop or Anywhere). Unless they only have security to use one or the other (or make an educated guess if certain users would probably only be using one or the other, even if they have security to access both).

--Oracle query
select
    u.userid,
    personid,
    loginid,
    security_groups
from
    maximo.maxuser u
left join
    (
    select 
        userid, 
        listagg(groupname,', ') within group( order by groupname ) as security_groups
    from 
        maximo.groupuser
    group by userid
    ) sec
    on u.userid = sec.userid
where
    --this was borrowed from a Maximo saved query
    exists (select 1 from maximo.maxsession where (userid = u.userid))
order by
    security_groups

For example, the user with these security groups: ANYWHERE_TECHNICIAN, MAXEVERYONE, SELFSR is probably only using Anywhere, not desktop.

#MaximoAnywhere
#Maximo
#AssetandFacilitiesManagement

This will give you a good idea.  You may want to add a filter for the various "ANYWHERE_%" groups, and also in your select query return the IP address (MAXSESSION.CLIENTADDR) in your query.  You could then pipe that into a BIRT report and gain visibility that way.  My guess is that you have either an MDM or other tool that can tell you whose IP belongs to which device.

In the earlier versions of Maximo Anywhere the MobileFirst server did have a database that kept track of the device logins.  I created a custom report years ago and tied the login of the user to the login of the device (there was a key between the MobielFirst DB and th Maximo DB.)  The report then told me what users were logging into any given Anywhere app specifically.  With the removal of the MobileFirst server from the solution this is no longer possible.

------------------------------
Bradley K. Downing , MBA
IBM Certified Adv. Deployment Prof. Maximo v7.6.1
IBM
Bakersfield CA
------------------------------

Original Message:
Sent: Wed June 09, 2021 12:21 PM
From: User1971
Subject: Determine what users are connected to Anywhere?

Thanks Bradley. That helps.

If I understand correctly:
I can query for who is using Maximo. And I can see what security groups they have. But I can't easily determine what they're using (desktop or Anywhere). Unless they only have security to use one or the other (or make an educated guess if certain users would probably only be using one or the other, even if they have security to access both).

--Oracle query
select    u.userid,    personid,    loginid,    security_groupsfrom    maximo.maxuser uleft join    (    select         userid,         listagg(groupname,', ') within group( order by groupname ) as security_groups    from         maximo.groupuser    group by userid    ) sec    on u.userid = sec.useridwhere
    --this was borrowed from a Maximo saved query    exists (select 1 from maximo.maxsession where (userid = u.userid))order by    security_groups

For example, the user with these security groups: ANYWHERE_TECHNICIAN, MAXEVERYONE, SELFSR is probably only using Anywhere, not desktop.

#Maximo
#MaximoAnywhere
#AssetandFacilitiesManagement