Questions tagged [maximo]

IBM Maximo Asset Management software provides asset lifecycle and maintenance management for all asset types on a single, extensible platform. It is built on Java, makes heavy use of SQL where clauses, and supports "automation scripting" out of the box in Jython/Python and JavaScript in predefined contexts.

IBM Maximo Asset Management software is the foundation and framework of an Enterprise Asset Management (EAM), Change and Configuration Management Database (CCMDB), Service Management and IT Asset Management (ITAM) suite of applications that provides asset lifecycle and maintenance management for all asset types on a single platform. Businesses across all industries use Maximo to maximize the realized value of critical physical and IT assets, from purchase authorization to decommissioning, by augmenting business processes with automation and enforcement of best practices. Industry-tailored solutions are available for IT, utilities, nuclear power, transportation, government, telecommunications, life sciences, oil & gas, and more.

The current release, IBM Maximo Asset Management 7.6, is the latest release built upon a Java Enterprise Edition (JEE) Service Oriented Architecture (SOA). The Maximo framework is scalable, can be easily integrated into existing Enterprise Resource Planning (ERP) systems via REST, database tables, Remote Method Invocation (RMI) or a host of other options, can be extended with custom Java or via Automation Scripting (scripting in Jython/Python or JavaScript in predefined contexts), and can be configured with SQL where clauses in many of its internal configuration tools. It also sports tight integration with Actuate's Business Intelligence Reporting Tool (BIRT).

As Maximo is a Commercial Off The Shelf (COTS) product, related Java, Python, JavaScript, BIRT and SQL questions may have constraints not normally imposed on developers working with those languages/tools. For example, Automation Scripting contexts, for scripting in Python or JavaScript, are predefined but dynamic, so the scripter doesn't know at coding time what all the variable names will be. For another example, Maximo does select * from table where and appends your where clause, so the developer can't change the columns selected or the grouping.

Maximo Homepage

617 questions
2
votes
1 answer

how to generate request pages for multiple reports

how to generate request pages for multiple pages as I am going to migrating multiple reports from test to prod in Maximo. is it possible to add generate request page button in the list view of report administration application
2
votes
1 answer

Maximo: Save a dynamic query?

In Maximo 7.6.1.1, I can run a query on work orders with this WHERE clause: reportedby = :user: When I hit Find the query runs successfully; it filters the records using the currently logged in user. However, when I go back and look at the WHERE…
User1974
  • 276
  • 1
  • 17
  • 63
2
votes
2 answers

Does the ASSET table in Maximo have a primary key?

I'm trying to determine if the asset table in Maximo 7.6.1.1 has a primary key (query source): SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner FROM all_constraints cons, all_cons_columns cols WHERE cols.table_name =…
User1974
  • 276
  • 1
  • 17
  • 63
2
votes
2 answers

Maximo: ASSET table has duplicate indexes?

I have been investigating the indexes on the asset table in Maximo 7.6.1.1. I noticed that there are a couple of indexes that appear to be duplicated: ASSET_NDX1 ASSET_NDX14 Query the indexes: select * from all_indexes where …
User1974
  • 276
  • 1
  • 17
  • 63
2
votes
2 answers

Maximo MAXINTMSGTRK table: How to extract text from MSGDATA column? (HUGEBLOB)

I'm attempting to extract the text from the MSGDATA column (HUGEBLOB) in the MAXINTMSGTRK table: I've tried the options outlined here: How to query hugeblob data: select msg.*, utl_raw.cast_to_varchar2(dbms_lob.substr(msgdata,1000,1))…
User1974
  • 276
  • 1
  • 17
  • 63
2
votes
3 answers

Generate hierarchical path

I have a classstructure table: create table classstructure (classstructureid number(8,0), classificationid varchar2(25), parent number(8,0)); insert into classstructure(classstructureid, classificationid, parent) values(1001, 'FLEET', null); insert…
User1974
  • 276
  • 1
  • 17
  • 63
2
votes
1 answer

ORA-01843: not a valid month exception when running as report on maximo

I am currently writing some Code to get a view over issued service-tickets from my company and where they have been routed. I am using Birt for Eclipse to create a report who uses that Code. While using Toad 12.0.10.30, no exception is thrown, same…
Caenerys
  • 57
  • 1
  • 9
2
votes
1 answer

Changing portlet item color scheme based off of date

I am trying to change the colors of lines displayed in my portlet based off of a date range. The following are examples of what I am trying to do. within the last 7 days - green greater than 7 days - red. I have tried the following expressions…
2
votes
3 answers

MAximo workorder total labor costs and total Material costs

I'm working with my DBA to try to figure out a way to roll up all costs associated with a Work Order. Since any work Order can have multiple child work orders (through multiple "generations") as well as related work orders (through the…
Frank Ball
  • 1,039
  • 8
  • 15
2
votes
1 answer

Fetch System Property in Automation script in Maximo

I would like to know how to fetch system property in an automation script. I do understand we can declare it as variable however I would like to know whether there is any other way since using it as a variable is causing error in scripting for…
max092012
  • 365
  • 1
  • 5
  • 25
2
votes
3 answers

How can I query Automation Script Launch Point Event Conditions, Event Type, and Save settings?

I'd like to be able to query all details from our automation script launch points, such as (but not limited to) conditions, event types, and save settings. The problem is, these are non-persistent fields and I'm not sure where to get the…
BoydDensmore
  • 181
  • 12
2
votes
1 answer

Maximo -SoapUI “failed to load url” error when loading WSDL

We are on Maximo 7.5 I have created and deployed a web service in Maximo. I can load the wsdl of the service in the browser, however when I try to import it into SOAPUI, I get a "java.lang.Exception: Failed to load url;" When I try to access the…
user2732988
  • 71
  • 3
  • 12
2
votes
4 answers

use IBM Maximo with a new user interface

We are using IBM Maximo for one of our projects. Now we decided to improve the user interface (currently it's using the standard UI components provided by the Maximo system), but we want to move forward and create our own web pages (interface) using…
Asha
  • 3,871
  • 7
  • 44
  • 57
2
votes
1 answer

Issues saving current record from custom dialog

I am currently developing a custom app in Maximo Asset Management where i have form and an empty DataTable that have a button, when user clicks this button, a custom dialog appears and user can select a related record from this dialog on a data…
soviedo
  • 33
  • 1
  • 8
2
votes
1 answer

Maximo 7.6 / SQL Server 2014 Chinese or Thai Characters

The company I work for is in the process of upgrading from Maximo 7.1 with Oracle 10g to Maximo 7.6 with SQL Server 2014. The program allows Chinese and thai characters in 7.1 and Oracle 10g through the front end without any issues but the new…
Hosmerica
  • 21
  • 1