Maximo 7.6 Installation Procedure Step by Step | IBM Maximo

with new features Maximo 7.6 has introduced a number of technology updates, first look is and updated installer.

A document describes how to download IBM® Maximo® Asset Management 7.6 using the IBM Passport Advantage web site. https://www-304.ibm.com/support/docview.wss?uid=swg24038431

DEOCK YONG SHIN (ExInEx) has published a very detailed screen by screen installation procedure to Install Maxio 7.6 at IBM Developer Works

 https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Anything%20about%20Tivoli/page/Maximo%207.6%20installation%20procedure

Another published article and very documented step by step procedure to install Maximo 7.6 by Richard Lesses 

1. Installing Maximo 7.6: A first look, part 1
2. Installing Maximo 7.6: A first look, part 2
3. Installing Maximo 7.6: A first look, part 3
4. Installing Maximo 7.6: A first look, part 4

Disable Emailing of Password when Updating Password | IBM Maximo

in Security > Users Application
Click Security Controls from Select Action
Select " Allow Generated Passwords to Be Displayed On Screen option"
and hit OK.

we are done :)

By disabling this option, you do not need to set up the SMTP server or provide email information for the user when creating a new user and password or updating an existing password.

Reference: http://www.ibm.com/support/knowledgecenter/SS2GNX_7.2.2/com.ibm.tivoli.tpm.scenario.doc/security_troubleshooting/trcom_disablingpsswd4update.html

Maximo 7.6 Developement Environment, EAR Deployment and Mbo Customization | IBM Maximo

Download Eclipse Kepler (64bit) from: http://www.eclipse.org/downloads/
run Eclipse.exe if java is already installed, or copy websphere/Appserver/jre c:\eclipse\ folder.
start Eclipse.exe and set java compiler settings, (Windows > Preferences > java > compiler > 1.7)

1. Create a new Java project Proj01, Finish
2. extract maximo.ear file into this workspace/Proj01/maximo folder (C:\IBM\SMP\maximo\deployment\default\maximo.ear)
3. Add JARS in Project Properties > Java Build Path > Add Jars(b)
    Add the following jars

        maximo/lib/*.jar
        maximo/businessobjects.jar

Done :)
thanks to Bruno Quick Setup Development Environment

Create a Child Table Using Table Control | IBM Maximo

1. First, drag and drop a table control in Maximo, set properties as below:

Data Source Id:            main_tasks_table
Relationship:               Master_Detail_Relation (master to detail main relationship)

2. Drag a Default value control and set properties as below:

From Data Source ID: MAINRECORD

From Attribute: ParentTableID

Attribute: ChildTableID

--------------

or it can be done with an automation script.

For instance, the table ( prchild ) is a child of the PR table. So just write an automation script and name it as below:

NAME: PRCHILD.NEW

owner=mbo.getOwner()
if owner and owner.isBasedOn("PR"):
    mbo.setValue("PRNUM",owner.getString("PRNUM"))
    mbo.setValue("SITEID",owner.getString("SITEID"))

ESCALATION: Cancel Workdorders after 1 minutes | IBM Maximo

Objective:
change status to CAN after 1 minutes; all new workorder which are create in last 1 days.
Object Name:         which object's record to monitor i.e. WORKORDER
Where:                 a Filter the identifies the set of records of objects, each escaltion point futher filter these records.
Event Attribute:        a date/date-time attribute of selected records; i.e. STATUSDATE of WORKORDER

 Event Condition:    A further filter in above filtered set of records. if any
Elapsed Interval:     A time period to measure against event attribute(elapsed time attribute).  +ive integer in past, -ive in future
Interval UOM:          in days, hours etc.
Repeat:                continue monitoring or not , the same record of condition met.

Alert Lead in PM; a warning message before approval | IBM Maximo

Alert Lead in PM; a warning message before approval | IBM Maximo

It will prompt an alert 4 days before the PM is due to Generate a Work order that PM exists for asset.

for Example in Preventive Maintenance Application :

1. create a new record
2. Asset ENG100 to the PM tab.
3. Go to the Frequency tab and add the following info:
1. Frequency = 1
2. Frequency Units = MONTHS
3. Alert Lead (Days) = 4 (it will alert you 4 days before the PM is due to Generate a Work order)
4. enter Estimated Next Due Date for example tomorrows date  

Search NULL values in filter or Advanced Search | IBM Maximo

simply by using below mentioned techiniuqe in search/filter in any application.

~null~ for NULL

!=~null~ for NOT NULL

Maximo 7.6 Development Environment for MBO Customization | IBM Maximo

Maximo 7.6 Developement Environment and Deployement with Example | IBM Maximo

Download Eclipse Kepler (64bit) from: http://www.eclipse.org/downloads/ 
run eclipse.exe if java is already installed, or copy websphere/Appserver/jre in c:\eclipse\ folder.
start eclispe.exe and set java compiler settings, (Windows > Preferences > java > compiler > 1.7)

1. create a new java project Proj01, Finish
2. extract maximo.ear file into this workspace/Proj01/maximo folder (C:\IBM\SMP\maximo\deployment\default\maximo.ear)
3. Add JARS in Project Properties > Java Build Path > Add Jars(b)
i. Add the following jars  (from workspace/Proj01/maximo folder)
maximo/lib/*.jar
maximo/businessobjects.jar
Done :)
thanks to Brunu http://maximodev.blogspot.com/2010/09/quick-maximo-development-environment.html

Push Button to Call Action Script | IBM Maximo

1ActionScript:

ACTION LP: PTWBUTTON
Language: jython
Object: PLUSGPERMITWORK
Action: PTWBUTTON (it will create an action automatically in Actions application, see belowin step 2)
Source: our code goes here

2Action:

NAME: PTWBUTTON
OBJECT: PLUSGPERMITWORK
TYPE: Custom Class
Value: com.ibm.tivoli.maximo.script.ScriptAction
Parameter: PTWBUTTON (automation script name, created in step 1)

Automatically populate default user's Site on SR | IBM MAXIMO

1 create a Cross over domain
Domain: MAXUSER2SR
object: MAXUSER
Validation Where Clause: USERID = :user # (:USER means current logged in user)
Source Field: DEFSITE # (attribute in maxuser table)
Destination Field: SITEID

2 In Database Configuration; attach this domain (MAXUSER2SR) with attribute TICKETID in SR object

Simplified Procedure to Generate Maximo Logs | IBM Maximo

Logger = sql
Log Level = INFO
Appenders = Console,Rolling

Logger = application
Log Level = DEBUG
Appenders = Console,Rolling

Hit Save button
 
Select Action > Apply Settings
Done :)

Reference:

Send an email to the person in the reportedby field of a ticket? | IBM Maximo

 Is it possible to send an email to the person in the reportedby field of a ticket?

Answer

Steps:
1. Go to Roles application.
2. Create a new role called REPORTEDBY under Administration module > Workflow.

ref: http://www-01.ibm.com/support/docview.wss?uid=swg21497185

Which ROS (Parent Categories) can security groups access for their individual report creation? | IBM Maximo

Application: Report Administration
Action: Set Report Object Structure Security
Applies To: Ad Hoc (QBR) Reports Only

Sorting data of the relationship attributes | IBM Maximo

Sorting:

You cannot sort data of the relationship attributes or non-persistent attributes.

Filtering:

you can filter relationship attribute but not non-persistent attributes.  

reference:  http://www-01.ibm.com/support/docview.wss?uid=

Conditional expression syntax | IBM Maximo

You enter conditional expressions using a syntax similar to Structured Query Language (SQL) with some additional variables.

When you create a conditional expression, use a colon (:) to define a variable. The colon is used to avoid ambiguity when you create expressions that relate the current record to a different, specific record.

You can have subselect in an expression,

exists (select 1 from workorder where wonum=:wonum).

The first wonum is the wonum attribute on the work order object. At run time, the second wonum is replaced with the value of the wonum attribute for the current record.

Display Assigned GROUPNAME with WONUM in Workorder Tracking | IBM Maximo

 I had a requirement from my client to show the Workflow Assingee PERSONGROUP in front of WONUM in Workorder tracking applicaton's list view.

display assigned PERSONGROUP name in WORKORDER application's list view.

 1. create a new Relationship from ASSIGNEE to PERSONGROUPTEAM, remaining are OOTB

How to Delete Custom Applications from Maximo | IBM Maximo

Note: First of all shut down application server before going to delete an application.

run these SQL commands one by one:

delete from maxapps where app='CSPINSPECTION';
delete from maxpresentation where app='CSPINSPECTION';
delete from sigoption where app='CSPINSPECTION';
delete from applicationauth where app='CSPINSPECTION';
delete from maxlabels where app='CSPINSPECTION';
delete from maxmenu where moduleapp='CSPINSPECTION' and menutype!='MODULE';
delete from maxmenu where elementtype='APP' and keyvalue='CSPINSPECTION';
delete from appdoctype where app= 'CSPINSPECTION';
delete from sigoptflag where app='CSPINSPECTION';
delete from wfapptoolbar where appname='CSPINSPECTION';

Now just start the application server, deleted application is now longer available. Wasn't that simple.

if you added any system XMLs for your app (like lookups), then you will need to export the System XML and manually remove them and then re-import. (Or just import the copy of the system XML you should have made before you started. 

Add a Combo-box Control in PR using ALN Domain or Object in Database Configuration | IBM Maximo

My client requirement is to have of combo-box (dropdown control) instead of domain(magnifier) for SHIPVIA in Purchase Requisition application Main tab.

Object is: PR
attribute is: SHIPVIA of PR object
DOMAINID in database configuration attach to SHIPVIA of PR object: SHIPVIA  (ALN domain name)

Enabling an existing Hover Window in any Attribures | IBM Maximo

By default a some of hover dialogs are set on various application. You can enable existing hover windows on fields to suit your needs. For example, you can add a hover window to show the contact details for the owners of service requests. In general, you can show related information on any fields that support lookup.
If we analyze the properties Advance Tab of these text fields in application designer, we will get to know that there is something in Hover Window ID: field

below is a sample of these four examples and Hover dialog keywords
Hover Window ID:

- Asset               ASSET_RECORDHOVER
- Item                ITEM_RECORDHOVER
- Person             PERSON_RECORDHOVER   
- Work Order    WO_RECORDHOVER

How to Add lookup to a custom field? | IBM Maximo

In this example we are going to create a new custom field in work order tracking application. And then we are going to attach a lookup to select existing people records.

1. Create a new Table domain in Domain Application
   
• Domain:    myPersonDomain
• Object:        PERSON
• Validation where clause:    personid = :myCustomField (same name as field in application) 

Restrict default behaviour, Auto-Population of Asset Field everytime I select Location | IBM Maximo

use a simple Automation script to restrict this behavior because sometime work orders are opened against Location only.


A small Attibute automation script (ALP):

Business object:  WORKORDER
Attribute: LOCATION
Variable: vASSETNUM bind with ASSETNUM of object WORKORDER

copy and paste below mentioned code:

if  vASSETNUM is not None:
        vASSETNUM=None

Custom Field in Non-persistent Object ISSUECURRENTITEM | IBM Maximo

Add a new field in ISSUE CURRENT ITEM dialog and capturing the data in the MATUSETRANS table using automation script.

if owner and owner.getRecordMboName()=="INVENTORY": issueitemMbo=owner.getMboSet("ISSUECURRENTITEM").getMbo(0) if issueitemMbo: mbo.setValue("MATUSETRANScustomaFieldName", issueitemMbo.getString("ISSUECURRENTITEMcustomFieldName"))

Thanks to SASHULL

Maximo Safetyplan and associated Hazard n Precautions SQL | IBM Maximo

select
      sp.safetyplanid
      , sp.description
      , h.hazardid
      , h.description
      , p.precautionid
      , P.description
      , p.siteid
  from
      safetyplan sp
  join
      spworkasset spwa
      on sp.safetyplanid = spwa.safetyplanid
  join
      splexiconlink spll
      on spwa.spworkassetid = spll.spworkassetid

Modify Label using Conditional Expression | IBM Maximo

1. signature option new or existing (e.g. READ)
2. In Advance:
Security Group: EveryOne
Condition: our condition (e.g. :status = 'APPR')
Property: label (if condition true)

value "status is approved"

Property(if false) label (if condition false)

value "Status is not approved"
 

Invoke an Action (i.e. Change Status) with Push Button | IBM Maximo

1. Create New Action:

    Name: statusApprAction ( for example)

    Object: PR
    Type: 'Change Status'

    Value: 'APPR'

2. Open desired application  (for example, Purchase Requisition in Application Designer
    Create a new Signature Option in desired application using application designer

    New/Option: statusApprSig
    Advanced Signaure Option: Check This is an action that must be invoked by user in the UI