This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Need a little help from you Maximo Pros out there. I am starting to mess with escalations and am running into a problem. I am trying to set up an automatic notification when a Work Order has been cancelled and send it to the originator. Currently I set my escalation up like this: STATUS = 'CAN' and STATUSDATE >= '7/18/12'
The schedule is set to 15 minutes for testing purposes, but this formula isn't yielding any notifications. Also, looking at this a bit more I am thinking that if this did work it would not get me what I want because, for example, if a work order is cancelled today and the system runs the escalation and notifies me then when it runs again it will notify me of the same Work Order cancellation.....this could be a problem as time goes on. Perhaps I am trying to use the wrong app for what I am trying to accomplish?
Anyways, although this is a very simple process for some of you out there any guidance you can provide would be much appreciated. Even if that included links to literature on the topic. Thanks.
Maximo v6.2.6
SQL 2002 Server
You date range is causing it not to yield any data.. using a '7/18/12' is
setting time to 7/1/18 00:01:00. I prefer to use a between or you could use
a (statusdate >= getdate()-1), but try your query from the where clause in
workorder tracking to make sure it yields the correct data before applying
to an escalation..
Also as long as the Repeat check box is not checked under escalation point
it should not repeat data that matches the query..
Shannon Sutton
CMMS Specialist
EAM/IBM-Tivoli Maximo
EMCOR Government Services
Office: 571-403-8940
Cell: 571-970-7965
From: Zeroxpectations <zeroxpectations@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Date: 07/19/2012 05:09 PM
Subject: [MAXIMO List] ESCALATIONS
Sent by: MAXIMO@yahoogroups.com
Need a little help from you Maximo Pros out there. I am starting to mess
with escalations and am running into a problem. I am trying to set up an
automatic notification when a Work Order has been cancelled and send it to
the originator. Currently I set my escalation up like this: STATUS =
'CAN' and STATUSDATE >= '7/18/12'
The schedule is set to 15 minutes for testing purposes, but this formula
isn't yielding any notifications. Also, looking at this a bit more I am
thinking that if this did work it would not get me what I want because, for
example, if a work order is cancelled today and the system runs the
escalation and notifies me then when it runs again it will notify me of the
same Work Order cancellation.....this could be a problem as time goes on.
Perhaps I am trying to use the wrong app for what I am trying to
accomplish?
Anyways, although this is a very simple process for some of you out
there any guidance you can provide would be much appreciated. Even if that
included links to literature on the topic. Thanks.
Maximo v6.2.6
SQL 2002 Server
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are
not the intended recipient.
Thanks for the response, Shannon. I'll definitely give ur suggestions a try. I am new to this part of Maximo so please excuse my ignorance. Thanks and I'll let you know my results!
On Jul 19, 2012, at 5:27 PM, Shannon Sutton <ssutton@emcor.net> wrote:
> You date range is causing it not to yield any data.. using a '7/18/12' is
> setting time to 7/1/18 00:01:00. I prefer to use a between or you could use
> a (statusdate >= getdate()-1), but try your query from the where clause in
> workorder tracking to make sure it yields the correct data before applying
> to an escalation..
>
>
> Also as long as the Repeat check box is not checked under escalation point
> it should not repeat data that matches the query..
>
>
>
> Shannon Sutton
> CMMS Specialist
> EAM/IBM-Tivoli Maximo
> EMCOR Government Services
> Office: 571-403-8940
> Cell: 571-970-7965
>
>
>
>
> From: Zeroxpectations <zeroxpectations@yahoo.com>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Date: 07/19/2012 05:09 PM
> Subject: [MAXIMO List] ESCALATIONS
> Sent by: MAXIMO@yahoogroups.com
>
>
>
>
>
>
> Need a little help from you Maximo Pros out there. I am starting to mess
> with escalations and am running into a problem. I am trying to set up an
> automatic notification when a Work Order has been cancelled and send it to
> the originator. Currently I set my escalation up like this: STATUS =
> 'CAN' and STATUSDATE >= '7/18/12'
> The schedule is set to 15 minutes for testing purposes, but this formula
> isn't yielding any notifications. Also, looking at this a bit more I am
> thinking that if this did work it would not get me what I want because, for
> example, if a work order is cancelled today and the system runs the
> escalation and notifies me then when it runs again it will notify me of the
> same Work Order cancellation.....this could be a problem as time goes on.
> Perhaps I am trying to use the wrong app for what I am trying to
> accomplish?
>
> Anyways, although this is a very simple process for some of you out
> there any guidance you can provide would be much appreciated. Even if that
> included links to literature on the topic. Thanks.
>
> Maximo v6.2.6
> SQL 2002 Server
>
>
>
>
>
>
> This message is for the named person's use only. It may contain confidential,
> proprietary or legally privileged information. No confidentiality or privilege
> is waived or lost by any mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your system, destroy any
> hard copies of it and notify the sender. You must not, directly or indirectly,
> use, disclose, distribute, print, or copy any part of this message if you are
> not the intended recipient.
>
>
>
Check the recipient role assigned to your e-mail template looks like this
Type = A set of data …..
Object = WORKORDER
Value = :reportedby.primaryemail
E-mail = true i.e. checked
Reportedby is a relationship on the workorder table to the person table make sure it exits. it does on version 7.5
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of zeroxpectations@yahoo.com
Sent: 19 July 2012 23:40
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] ESCALATIONS
Thanks for the response, Shannon. I'll definitely give ur suggestions a try. I am new to this part of Maximo so please excuse my ignorance. Thanks and I'll let you know my results!
On Jul 19, 2012, at 5:27 PM, Shannon Sutton <ssutton@emcor.net<mailto:ssutton%40emcor.net>> wrote:
> You date range is causing it not to yield any data.. using a '7/18/12' is
> setting time to 7/1/18 00:01:00. I prefer to use a between or you could use
> a (statusdate >= getdate()-1), but try your query from the where clause in
> workorder tracking to make sure it yields the correct data before applying
> to an escalation..
>
>
> Also as long as the Repeat check box is not checked under escalation point
> it should not repeat data that matches the query..
>
>
>
> Shannon Sutton
> CMMS Specialist
> EAM/IBM-Tivoli Maximo
> EMCOR Government Services
> Office: 571-403-8940
> Cell: 571-970-7965
>
>
>
>
> From: Zeroxpectations <zeroxpectations@yahoo.com<mailto:zeroxpectations%40yahoo.com>>
> To: "MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>" <MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>>
> Date: 07/19/2012 05:09 PM
> Subject: [MAXIMO List] ESCALATIONS
> Sent by: MAXIMO@yahoogroups.com<mailto:MAXIMO%40yahoogroups.com>
>
>
>
>
>
>
> Need a little help from you Maximo Pros out there. I am starting to mess
> with escalations and am running into a problem. I am trying to set up an
> automatic notification when a Work Order has been cancelled and send it to
> the originator. Currently I set my escalation up like this: STATUS =
> 'CAN' and STATUSDATE >= '7/18/12'
> The schedule is set to 15 minutes for testing purposes, but this formula
> isn't yielding any notifications. Also, looking at this a bit more I am
> thinking that if this did work it would not get me what I want because, for
> example, if a work order is cancelled today and the system runs the
> escalation and notifies me then when it runs again it will notify me of the
> same Work Order cancellation.....this could be a problem as time goes on.
> Perhaps I am trying to use the wrong app for what I am trying to
> accomplish?
>
> Anyways, although this is a very simple process for some of you out
> there any guidance you can provide would be much appreciated. Even if that
> included links to literature on the topic. Thanks.
>
> Maximo v6.2.6
> SQL 2002 Server
>
>
>
>
>
>
> This message is for the named person's use only. It may contain confidential,
> proprietary or legally privileged information. No confidentiality or privilege
> is waived or lost by any mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your system, destroy any
> hard copies of it and notify the sender. You must not, directly or indirectly,
> use, disclose, distribute, print, or copy any part of this message if you are
> not the intended recipient.
>
>
>
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
**************************************************************************************************************