Wrong Date Format When We Download from List Tab | IBM Maximo

1. Go to System Configuration > Platform Configuration > System Properties
2. Find/filter property : webclient.downloaddatetimeastext
3. In "Global Value" field change the value to 1
4. Select the row and click "Live Refresh" action
5. We are done :)

Excluding Attributes Data (user-defined) When Duplicating Records | IBM Maximo

This is only for user-defined attributes and not for out of the box attributes.

1. In Database Configuration, filter your object e.g Assets
2. Click Exclude Attribute Data from Select Action
3. select the attributes that you want to exclude for this object, even you can use conditional expression over here.
4. run Apply Configuration Changes to take effect
you are done :)

DOCLINKS Configuration (Attachments) | IBM Maximo

1. Create your doclinks folder
Create a folder, e.g. c:\doclinks
and a sub-folder, e.g. c:\doclinks\default

2. Configure System Properties
You need to configure the following system properties

• mxe.doclink.doctypes.defpath => c:\doclinks\default
• mxe.doclink.doctypes.topLevelPaths => c:\doclinks
• mxe.doclink.path01 => c:\doclinks=http://<servername>/doclinks

Restart your MXServer.

3. Change httpd.conf (e.g. in my case C:\IBM\HTTPServer\conf\httpd.conf)
Open the httpd.conf and add the following section to the end of the file

Alias /doclinks "D:/doclinks"
<Directory "D:/doclinks">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>

Custom Power App for Desktop Requisition XML | IBM Maximo

Once we modified OOB Desktop requisition  to Power App, Presentation is as below:

<?xml version="1.0" encoding="UTF-8"?>
<presentation id="mymr" ismobile="false" mboname="MR" resultstableid="results_showlist" version="6.0.0">
<page id="mainrec" scroll="false">
<include controltoclone="pageHeader" id="INCLUDE-pageHeader"/>
<clientarea id="clientarea">
<tabgroup id="maintabs" style="form">
<tab default="true" id="results" label="List" type="list">
<menubar event="search" id="actiontoolbar1" sourcemethod="getAppSearchOptions"/>
<table id="results_showlist" inputmode="readonly" label="Requisitions" mboname="MR" selectmode="multiple">
<tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="results_showlist_tablebody">
<tablecol dataattribute="MRNUM" filterable="false" id="results_showlist_column_select" mxevent="toggleselectrow" mxevent_desc="Select Row {0}" sortable="false" type="event"/>
<tablecol dataattribute="MRNUM" id="results_showlist_column_link" mxevent="selectrecord" mxevent_desc="Go To %1" type="link" usefieldsizegroup="false"/>
<tablecol dataattribute="DESCRIPTION" id="results_showlist_column3"/>
<tablecol dataattribute="SITEID" id="results_showlist_column1"/>
<tablecol dataattribute="REQUESTEDBY"

How to setup e-signature on Asset Application | IBM Maximo

Goto > System configuration > Platform configuration > Database Configuration
1 filter Asset application
  and in Attribute Tab, find desired
2 and Enable Check Box "E-Signature Enabled"
Save
3 Now Manage eSig Actions from Select Action
 filter Asset application
 and filter "Save Asset" in Option for Add Assets in Collection
4 and Enable Check Box "E-Signature Enabled"
5 Run Database Configuration, and you are done :)

Launch in Context, Add Hyperlink on SR to IBM Portal | IBM Maximo

navigation: Goto > System configuration > Platform configuration > Launch in context
1 click new
Launch Entry Name: IBM    Description: IBM Support Portal
console URL: http://www.google.com/portal :) hehe
Target Browser Window: _blank
2 Click New Row button to add Launch Context for Launch Entry
Resource Object Name: SR
3 Hit Save
----------------------------------------------
Navigation: Goto > System configuration > Platform Configuration > application Designer
open SR application
1 Add new Signature Option from action menu
     i New Row button to add new row
        Option: IBM    Description IBM Support Portal
    ii Expand Advanced Signature Option
        Check radio button: Associate to launch entry to enable launch in context
    Launch in Context Name: IBM
2 Hit OK

Insert Image in PEOPLE application like in ITEMMASTER | IBM Maximo

Insert Image in PEOPLE application like in ITEMMASTER | IBM Maximo

1.    Create a Relationship on PERSON Object to IMGLIB

(REFOBJECT = 'PERSON' AND REFOBJECTID = :PERSONUID)

Embed Maximo into your own webpage PORTALMODE | IBM Maximo

client requirement is to embed Maximo Login Page into his company's website, for that Maximo offer a switch PORTALMODE=true to append into URL.

for example, in html as a hyperlink

 <body>
<A href="http://10.50.87.20:9080/maximo/ui/maximo.jsp?portalmode=true" target="ifr">Maximo Login</A><BR>

  <TD>
    <IFRAME name="ifr" width="700" height="500"></IFRAME>
  </TD>

</body>

Reassign button in Workflow (Display One) | IBM Maximo

A Reassign button in workflow at Manual Input Node, sometime we need or sometimes we don't.
Reassignment of an assigned task from your inbox to other is a useful option in Maximo;

below mentioned is the way to enable or disable this option when you click on Route button.
Open your desired workflow in Workflow designer,

Disabling e-Signature When Managing Admin Mode | IBM Maximo

Navigation: Go to > System Configuration > Platform Configuration > Database Configuration

Click on Manage eSig Action from Select Action Filter Database Configuration and below you will find enabled E-signatures for Manage Admin Mode and all like that. Deselect them and hit Save. You are done.

Import/Re-import a Modified BIRT Report | IBM Maximo

Goto > Administration > Report Administration
Filter desired report with attached Application (for example podetail.rptdesign, with PLUSGPO application)

1. Click to open that report

How to take Maximo DB2 Offline Backup - IBM Maximo

FIRST we have to stop maximo server to take offline backup, you can do it by using websphere GUI or by using ServerStop.bat, its totally up to your choice

now copy these below mentioned lines in notepad and save it with dot bat (i.e DB2BackupScript.bat) extension.

DB2 CONNECT TO MAXDB76 USER Administrator USING Maximo76
DB2 QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
DB2 CONNECT RESET
DB2 BACKUP DATABASE MAXDB76 USER Administrator USING Maximo76 TO "C:\Backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS EXCLUDE LOGS WITHOUT PROMPTING
DB2 CONNECT TO MAXDB76 USER Administrator USING Maximo76
DB2 UNQUIESCE DATABASE
DB2 CONNECT RESET

 run these this file by using this command

db2cmd /c /w /i DB2BackupScript.bat

Note: you also can make a bat file for this command also.

LAST: now Start WebSphere back by using GUI or StopServer.bat script. whatever you like. 

Websphere Start Stop Scripts | IBM Maximo

Save these scripts into dot bat file to create as script

Start Script:

C:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\bin\startServer.bat MXServer 

Stop Script:

C:\IBM\WebSphere\AppServer\profiles\ctgAppSrv01\bin\stopServer.bat MXServer -username wasadmin -password ******

Or

We also can use Websphere jython scripts with wsadmin.bat

Start Script:

AdminControl.invoke('WebSphere:name=NodeAgent,process=nodeagent,platform=common,node=ctgNode01,diagnosticProvider=true,version=8.5.5.3,type=NodeAgent,mbeanIdentifier=NodeAgent,cell=ctgCell01,spec=1.0', 'launchProcess', '[MXServer]', '[java.lang.String]')

Find Your Own Records | IBM Maximo

for example in SR request, logged in user wants to filter his own records,

Create a new query and paste below mentioned line

reportedby= :&USERNAME&

or

:&PERSONID&

Import Data into Maximo using INTERFACE tables MIF – IBM Maximo

First of all, we need to have interface/intermediate tables to import something into Maximo from an external/3^rd party database. Suppose we want to import some inventory data or for instance we try to figure out with a real example. Let’s assume we need to import data from a legacy application into Maximo. That legacy application is actually an inventory issuance system already implemented somewhere, we have to integrate it with New Maximo Inventory system.

MATRECTRANS tables is actually the main table to

To import data into Maximo, few steps are required to configure step by step.

1.            Object Structure (OS)

2.            End Point (EP)

3.            Enterprise services (Inbound or to import data) (ES)

4.            Publish Channel (Outbound or export data, we will not use in this case) (PC)

5.            and Combine above all into an External System (ExS)

6.            Generate Interface tables

7.            Configure Cron task for Scheduling (CT)

8.            Done. Now insert data into Interface tables and Maximo will read as per given schedule in CT.

Object Structures (OS)

Fixes by Versions for Maximo and TAMIT - IBM Maximo

On December 11, 2015, IBM Software released the 7.6.0.3 Feature Pack for Maximo Asset Management

Click here: This list reflects latest and recommended fixes for Maximo Asset Management and Maximo Asset Management for IT 

Document Sequence in Maximo with DB Trigger - IBM Maximo

Maximo uses Autonumbering, which basically a Unique value with optionally prefix or suffix. 

Whenever a user hit the New (#) button in any application, Maximo generate a AutoNumber, user can change that number but the CurrVal of sequence has moved to NextVal. 

One of my client's audit requirement is to have an auto incremented unique sequencial document control numbering without jumping(missing numbers), without losing even a signal number.  

We handled this situation at database level to insert into a new field with an increment of number before insert.

1. create a DOCNUM field in PO Object by using Database Configuration, check filterable and Wildcard.

2. Create a trigger with below mentioned code to fire on PRE-INSERT, get max(DOCNUM) from all POs , increment with 1 and Assign value to DOCNUM. 

3. If PO type is STD then a word 'PO' will be prefixed with Number else 'SO'

4. also Concat the fiscal year between prefix and actual number (SO-16-12345)

Trigger Code is as below:

CREATE OR REPLACE TRIGGER MAXIMO.PO_TEST
  NO CASCADE BEFORE INSERT
  ON MAXIMO.PO
  REFERENCING
    NEW AS N
    OLD AS O
  FOR EACH ROW
BEGIN
DECLARE POTYPE1 VARCHAR(10);
DECLARE YY INTEGER;
  IF N.POTYPE = 'STD' THEN
    SET POTYPE1='PO';
  ELSE
    SET POTYPE1='SO';
  END IF;
  Select to_char(add_months(sysdate,7),'YY') INTO YY from sysibm.sysdummy1;
SET N.ROWSTAMP = NEXTVAL FOR MAXSEQ
   ,N.DOCNUM = POTYPE1||YY||(select LPAD(MAX(SUBSTR(DOCNUM,7,3))+1,5,'0') from PO);
END;

Set a Default Filter in any Application | IBM Maximo

In Application designer, (Goto > System Configuration > Plateform Configuration > Application Designer)

1. Toggle/Show All Controls from Action Menu
2. Right Click on Presentation and click properties.
3. In the Where Clause property type: WORKTYPE = 'CM'
4. Save, you are done!

Limit out of the box lookups using WHERELCLAUSE by using LOOKUP.XML - IBM Maximo

Let’s start with an example, suppose our requirement is to limit Work types in Work Order Tracking application to just show CM and PM.

Therefore, we achieve this by using below mentioned solution:

Go to > System Configuration > Platform Configuration > Application Designer

click on Export System XML from Select Action

Click on blue blued juxtaposed to LOOKUP and then Save into your computer.

Note: make a copy to backup LOOKUPS.XML first.

1. Open LOOKUP.XML in your favorite editor, mine is Notepad++ and find html tag looks like this:

<table id="worktype" inputmode="readonly" selectmode="single"

Table Domain Vs Crossover Domain - IBM Maximo

Today one of my colleague has asked me the difference between Crossover domain and Table domain. He was confused and indeed he mixed up them both.

this is how I explained him.

First of all, as the names suggests, both have major differences in itself.  

Table Domain:

1.       It’s a list of value to show you all values in table

2.       We can populate only one field with one table domain.

3.       and yet, definitely we can re-use it as many times as we require.

4.       for Table domain, we don't need to know about the target application, can b use anywhere.

5.       table domains dynamically update its values, as they looked up table updates.

6.       for instance, in users’ application to create a new user. As we press lookup button, we see a list of persons’ table. And it updates automatically as the person’s records updates, insert, delete.

Crossover domain:

1.       It’s another type of domain to be use as lookup. It not only just lists us domain values but we can populate as many field as we require from source application to this (destination).

2.       for crossover, we must know target application and his field names to populates.

3.       Each field has to be mapped with source and target fields at the time of create a crossover domain.

4.       for example, we are creating a new user, when we select person from crossover domain, it populates other records as well automatically. We can use this to copy records/values from one application to another.

5.       We also can use relationship to drill child levels.

Error Message 'ADD not allowed on DOCLINKS' appears when trying to add an attachment - IBM Maximo

When you get this message, it means user must have a default insert site within his user application profile.

BMXAA0024E - The action ADD is not allowed on object DOCLINKS. Verify the business rules for the object and define the appropriate action for the object

Goto > Security > Users

1. Select Default Insert Site

And you are done.