Maximo Open Forum

 View Only

  • 1.  Need list of users logged into Maximo

    Posted 12 days ago
    Edited by Trisha S 12 days ago

    Hi,

    I have a requirement to find list of users who logged into maximo ( like previous day) or last week and share that report. I tried using escalation but with that suppose if 10 records are there then i am getting 10 different mails in my mailbox. I tried via automation script too but there seems to be some issue and I do not have access to logs so i cant see the errors too.

    I also thought if i could schedule the report from.maximo only but i do not see attempdate column from login tracking table there.

    Can anyone help me or suggest how do I achieve it?

    I can share the query if required.

    Thanks


    #EverythingMaximo

    ------------------------------
    Trisha S
    Tcs
    ------------------------------



  • 2.  RE: Need list of users logged into Maximo

    Posted 12 days ago

    For current users, you can drop a where clause into the users application:

    userid in (select userid from maxsession) or (status in (select value from synonymdomain where maxvalue = 'BLOCKED' and domainid = 'MAXUSERSTATUS' and defaults = 1)) order by DEFSITE, USERID

    This will identify who is logged in or blocked at the time the query runs. 

    For history, you want to query the 'LOGINTRACKING' object, which includes the attempted date, attempted result, name, and user, so your main piece of criteria would be ' "LOGINTRACKING.ATTEMPTRESULT = 'LOGIN' " plus your date range and whatever else you want to display. Login Tracking will need to be enabled:

    Build your report from there. If you make it in BIRT, you can pre-load your date range with substitution variables (like ATTEMPTDATE > GETDATE()-7 or ATTEMPTDATE > SYSDATE-7, etc.) and then just schedule the report weekly and distribute to whomever you like



    ------------------------------
    Christopher Winston
    Projetech Inc.
    IBM Champion 2024
    ------------------------------

    Original Message


  • 3.  RE: Need list of users logged into Maximo

    Posted 10 days ago

    Hi @Trisha S!

    In users application, you need to execute this where claus: 

    userid in (select distinct userid 
    from maximo.logintracking 
    where attemptdate >= current date - 7 days)

    It will list the users who connected in the last week.

    Then, you need to "Create report" in More Option menu

    Create the report and then schedule it to be sent whenever you decide. The report will list the users who logged in (in this case, the last 7 days).

    You will receive a single email with an attachment, as you need.

    Regards!



    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------

    Original Message


Related Content