Maximo Asset Management and SmartCloud Control Desk Migration Series

Abstract

This series is intended to assist our customers in planning their upgrade to the latest versions of Maximo Asset Management and SmartCloud Control Desk. The bulk of this series will be devoted to the Maximo product suite, add-on's and industry solutions.

In each session, a member of the business architecture team will deliver a presentation chronicling the incremental enhancements made in the product as well as point out functional changes to existing features. Ample time will be allowed for customer questions. Attendees will come away with a better understanding of what to expect, functionally, after the upgrade. This information should prove valuable for customers in determining customizations and configurations that could be modified or removed upon implementation of the latest version. Who should attend these sessions? Any current Maximo customer who is on version 6.x or 7.1.x and is planning to upgrade to version 7.5 or any customer who plans to upgrade to or implement the latest version of SmartCloud Control Desk. Review the session schedule to determine who from your organization is the best fit for each topic.

This session is also open to any IBM business partner or IBM employee who would gain useful information in helping your clients upgrade to the latest versions of Maximo or SmartCloud Control Desk. Please note that these sessions are primarily intended for customers. If time allows, business partners and IBM employees can pose questions after all customer questions have been addressed.

Content

Session topics, with the recording playback Amazon Cloud Download links are listed below.

Installing Maximo 7.6 on Redhat Linux 6.6

Developerworks links:
Installing Maximo 7.6 on Redhat Linux 6.6 (1 of 3)
Installing Maximo 7.6 on Redhat Linux 6.6 (2 of 3)
Installing Maximo 7.6 on Redhat Linux 6.6 (3 of 3)

Installing Control Desk Service Portal

IBM Knowledge Center:
Installing Control Desk Service Portal

Batch file for starting Maximo services

sc start "IBMHTTPServerV8.5"
timeout 5

sc start "IBMWAS85Service - ctgCellManager01"
timeout 5

sc start "IBMWAS85Service - ctgNode01"
pause

Starting and Stopping MS SQL Server from bat file

Start SQL Server:

@echo off

sc query "MSSQL$SQL01" | find /I "STATE" | find "STARTED"
if errorlevel 1 goto :start
goto :end

:start
net start "MSSQL$SQL01"
net start "SQLAgent$SQL01"
rem net start "MSSQLFDLauncher$SQL01"
net start "SQLBrowser"
net start "SQLWriter"

:end

Where clause for condition node in workflow for definition related records in not final status

For TICKET:

(select count(1) from ticket where origrecordid = :ticketid and origrecordclass = :class and status not in ('CLOSED', 'RESOLVED')) = 0
and
(select count(1) from workorder where origrecordid = :ticketid and origrecordclass = :class and status not in ('CLOSE', 'REJECTED', 'CAN', 'FAILPIR', 'COMP', 'FAIL', 'REVIEW')) = 0

For WORKORDER:

(select count(1) from ticket where origrecordid = :wonum and origrecordclass = :class and status not in ('CLOSED', 'RESOLVED')) = 0
and
(select count(1) from workorder where origrecordid = :wonum and origrecordclass = :class and status not in ('CLOSE', 'REJECTED', 'CAN', 'FAILPIR', 'COMP', 'FAIL', 'REVIEW')) = 0

SQL query for searching responsible person group for classification looking from bottom level to top level classification tree

If you want to define common responsible person group for all child classification elements hierarchy from top to down element, by defining responsible person group only for one top classification element, you can use the following sql query to define relationship for the object (e.g. TICKET, WORKORDER etc., all objects which has classstructureid attrribute) with persongroup object.