Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Only send single email for escalation (OOB/UI)

    Posted Mon July 26, 2021 10:13 PM
    Edited by System Admin Wed March 22, 2023 11:45 AM
    MAM 7.6.1.2; Oracle 19c:

    For escalations, I can make Maximo only send me a single email -- by limiting the SQL condition to a single record:

    rownum = 1

    That works, but I can't help but wonder why that option wouldn't exist OOB in Maximo. 
    For example: a "Run for first record only" checkbox might be more intuitive.

    Is there a reason why that functionality doesn't exist OOB in the UI? It seems like a common use case. Or maybe I've misunderstood something?



    Looking for input. Thanks.

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Only send single email for escalation (OOB/UI)

    Posted Tue July 27, 2021 03:26 AM
    Hi.

    Could you please give a bit more about your use case.
    Do you want to return a single row so you can test the escalation?

    If that is the case then it sounds like you really want a "Test" button.
    A test button could be used to test the escalation with a single row.
    If the core escalation code was modified then it could also indicate if there was a problem..

    Sys admin's need to be aware of the number of the number of rows that have been processed and having a tick box that says "process first row" could be useful.
    There are several escalation related enhancements that could be implemented. Feel free to reach out if you want to raise an RFE - I should be able to help give it the best chance.

    best regards,
    Mark

    ------------------------------
    Mark Robbins
    Support Lead/Technical Design Authority / IBM Champion 2017 & 2018 & 2019 & 2020 & 2021
    Vetasi Limited
    https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
    ------------------------------

    Original Message


  • 3.  RE: Only send single email for escalation (OOB/UI)

    Posted Mon August 02, 2021 08:47 PM
    The reason I want my escalations to return a single row / send a single email is:
    I only need a single email sent to me if there is an issue, regardless of how many rows in Maximo are affected.

    Examples:
    1. There could be hundreds of rows that match this condition/escalation:
    WORKORDER: WHERE LATITUDEX IS NOT NULL AND ISGIS IS NULL [a possible issue with Maximo Spatial]
    2. Or there could be 20,000 rows that meet a condition due to a problem with a sync from an external system (GIS).

    I only need a single email that will alert me of the problem. I don't need an email for every row that the escalation finds.

    There are some related comments in this post:
    https://community.ibm.com/community/user/iot/communities/community-home/digestviewer/viewthread?MessageKey=423d3313-1021-4aed-87a5-5816f2721d1a&CommunityKey=3d7261ae-48f7-481d-b675-a40eb407e0fd&tab=digestviewer#bm423d3313-1021-4aed-87a5-5816f2721d1a
    Original Message


  • 4.  RE: Only send single email for escalation (OOB/UI)

    Posted Tue August 03, 2021 10:01 AM
    One possible option is to run your escalation against a custom property which you can set as 1 or 0.
    1 means escalation will run. Then invoke a script on action which will do the logic to figure out the data that you need to be send out.
    If its on WO, you can run separate queries for count to populate the mail with count and details as well

    ------------------------------
    Akshay T
    ------------------------------

    Original Message


Related Content