November 27, 2014

Learn how to query data with SQL

Many times Maximo users and administrator lacks database skills. These are important in several situations:
  • Write 'where clause' statements to filter data in Maximo UI.
  • Develop complex SELECT statements to extract data from multiple tables when developing report.
  • Optimize existing queries to solve performance issues.

If you need to improve your SQL skills I suggest you to read few chapters of the SQL Getting Started guide of IBM DB2. This is not just for DB2, SQL syntax is quite similar across different database types.

The important chapters to read are:
  • Chapter 4. Using SQL Statements to Access Data
  • Chapter 6. Using Operators and Predicates in Queries
  • Chapter 7. Advanced SQL (Joins paragraph)

Does anybody have other good SQL tutorials to share?

November 12, 2014

Maximo Tranining presentations

Here are some nice presentations that I use during basic education sessions for new Maximo users.

I tried to use a pretty template and a common style across all of them.

Feedback is welcome!

November 6, 2014

Maximo is the leader Enterprise Asset Management Software

Gartner has recently published its Magic Quadrant for Energy and Utilities Enterprise Asset Management Software and guess what?
IBM Maximo Asset Management is positioned it the 'Magic' corner!

Read the full report here.

October 30, 2014

Preventive Maintenance (PM) automatic work order generation

You probably know that Preventive Maintenance module in Maximo allows to schedule periodical maintenance activities in order to keep your assets running efficiently.
In other words you can use the  Preventive Maintenance to schedule the automatic generation of work orders.

Work orders can be generated manually using the 'Generate Work Orders' action in the Preventive Maintenance application. A dialog will be displayed allowing to set the number of days in the future for which the work orders must be created.

The work order generation can be easily automated using the PMWoGenCronTask cron task.
Once the cron task schedule is set you can specify the PM generation rules for each site. Open the Organization application, pick your organization and select the 'PM Options' action from the menu.
The following dialog will be displayed allowing to set the generation option for each site.

Processing all the PM records each day to generate few work orders is not the best option. Almost all the processed records will generate a warning like this:
BMXAA3191E - PM XXXXX is not due yet, or it does not fall within the active season.

A good practice is to restrict as much as possible the PM records processed using the where clause. For example the following where clause selects only the active PM records that will generate a work order in the next month.

status='ACTIVE' and
nextdate - NVL(leadtime,0) - 30 <= SYSDATE

This is important to lower PM generation workload and to avoid a long list of warning messages in the logs.


Using Preventive Maintenance (PM) Records to Create Work Orders
Executing PM Wogen Crontask by Site