Maximo Anywhere

  • 1.  Determine what users are connected to Anywhere?

    Posted Tue June 08, 2021 03:14 AM
    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.


  • 2.  RE: Determine what users are connected to Anywhere?

    Posted Wed June 09, 2021 10:39 AM
    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
    ------------------------------



  • 3.  RE: Determine what users are connected to Anywhere?

    Posted Wed June 09, 2021 12:22 PM
    Edited by User1971 Wed June 09, 2021 12:25 PM
    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.



  • 4.  RE: Determine what users are connected to Anywhere?

    Posted Wed June 09, 2021 01:26 PM
    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
    ------------------------------