Maximo

I want to use Maximo scheduled reports to monitor for issues with my data.

For example, if a certain report/query returns records, then email me.
Alternatively, if a different report doesn't return records, then email me.

Is it possible to set up a scheduled report so that it only emails the recipients if a condition is met? (i.e. based on record count)
#AssetandFacilitiesManagement
#Maximo

Escalations might be your best option.  It may be a little redundant as the logic to look for records would have to be duplicated in the Escalation but it will allow you a great deal of flexibility to control the email content and Distribution.

#Maximo
#AssetandFacilitiesManagement

I would agree with Julio, in fact i would say this is the best way to do this instead of scheduling the report e.g. Create the escalation to run the query at the desired frequency to check for the data you need then:

1.  If No records returned you can just send the email notification
2.  If records exist run an action that will run the report for you and email it to the required recipients with the report attached. (This may have to be done using an automation script action)

------------------------------
Steve Lee
Maximo Technical Sales Specialist
IBM
Leeds
------------------------------

Original Message:
Sent: Sun February 14, 2021 01:51 PM
From: User1971
Subject: Email report based on condition? (i.e. record count)

MAM 7.6.1.2:

I'm considering using Maximo scheduled reports as a poor-man's monitoring service.

For example, if a certain report/query returns records, then email me.
Alternatively, if a different report doesn't return records, then email me.

Is it possible to set up a scheduled report so that it only emails the recipients if a condition is met? (i.e. based on record count)

Thanks.

---

Note:

Ideally, I would do this via Oracle Scheduler, not through Maximo. But that would mean I would need to involve my DBA ... and I wouldn't have control over the things I want to monitor. That would be very inefficient & ineffective due to office politics challenges.
It would be much better to find a way to do the monitoring myself (as MAXADMIN). So I wondered if reports might be an easy & efficient way to do it.
#AssetandFacilitiesManagement
#Maximo

Good ideas. Thanks.
Original Message:
Sent: Tue February 16, 2021 03:46 AM
From: Steve Lee
Subject: Email report based on condition? (i.e. record count)

I would agree with Julio, in fact i would say this is the best way to do this instead of scheduling the report e.g. Create the escalation to run the query at the desired frequency to check for the data you need then:

1.  If No records returned you can just send the email notification
2.  If records exist run an action that will run the report for you and email it to the required recipients with the report attached. (This may have to be done using an automation script action)

------------------------------
Steve Lee
Maximo Technical Sales Specialist
IBM
Leeds

Original Message:
Sent: Sun February 14, 2021 01:51 PM
From: User1971
Subject: Email report based on condition? (i.e. record count)

MAM 7.6.1.2:

I'm considering using Maximo scheduled reports as a poor-man's monitoring service.

For example, if a certain report/query returns records, then email me.
Alternatively, if a different report doesn't return records, then email me.

Is it possible to set up a scheduled report so that it only emails the recipients if a condition is met? (i.e. based on record count)

Thanks.

---

Note:

Ideally, I would do this via Oracle Scheduler, not through Maximo. But that would mean I would need to involve my DBA ... and I wouldn't have control over the things I want to monitor. That would be very inefficient & ineffective due to office politics challenges.
It would be much better to find a way to do the monitoring myself (as MAXADMIN). So I wondered if reports might be an easy & efficient way to do it.
#AssetandFacilitiesManagement
#Maximo