Wiki - IBM Maximo Asset Management

Link to Wiki (IBM Maximo Asset Management)

CI Classification - Export to XLS

CI classification with attributes names: Link to XLS file

SQL Query script:

select
main.classificationid CIROOT, main.classstructureid CI_ID,
chold1.classificationid CH1, chold1.classstructureid CH1_ID,
chold2.classificationid CH2, chold2.classstructureid CH2_ID,
chold3.classificationid CH3, chold3.classstructureid CH3_ID,
chold4.classificationid CH4, chold4.classstructureid CH4_ID,
CASE WHEN chold4.classstructureid is not NULL THEN chold4.classstructureid
ELSE CASE WHEN chold3.classstructureid is not NULL THEN chold3.classstructureid
ELSE CASE WHEN chold2.classstructureid is not NULL THEN chold2.classstructureid
ELSE CASE WHEN chold1.classstructureid is not NULL THEN chold1.classstructureid END END END
END CHECK_ID,
specification.assetattrid SPEC_ATTR
from classstructure main
left join classstructure chold1 on chold1.parent = main.classstructureid
left join classstructure chold2 on chold2.parent = chold1.classstructureid
left join classstructure chold3 on chold3.parent = chold2.classstructureid
left join classstructure chold4 on chold4.parent = chold3.classstructureid
left join classspec specification on specification.classstructureid = (CASE WHEN chold4.classstructureid is not NULL THEN chold4.classstructureid
ELSE CASE WHEN chold3.classstructureid is not NULL THEN chold3.classstructureid
ELSE CASE WHEN chold2.classstructureid is not NULL THEN chold2.classstructureid
ELSE CASE WHEN chold1.classstructureid is not NULL THEN chold1.classstructureid END END END
END)
where main.classificationid = 'CIROOT'
order by CIROOT, CH1, CH2, CH3, CH4, SPEC_ATTR

For update data from your database you need to update your connection settings:

Good news for Report Developers who cannot execute reports using BIRT Report Viewer on Internet Explorer 11 (Win 8.1)

To resolve the issue of blank window when I try to execute report using BIRT Report Viewer on Internet Explorer 11, I do next steps:

1. Run regedit.exe
2. Open "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\FeaturControl\FEATURE_BROWSER_EMULATION"
3. Add "DWORD (32-bit) Value": "jawaw.exe=9000" (https://flic.kr/p/pVA62s)
4. At the end of elipse.ini add following entry:

-Dorg.eclipse.swt.browser.DefaultType=ie
-Dorg.eclipse.swt.browser.IEVersion=9999
(https://flic.kr/p/pVP4zx)

Run eclipse.exe, execute report. I have following result: https://flic.kr/p/qA1Ztj

IBM Tivoli Application Dependency Discovery Manager version 7.3 documentation

Link: IBM TADDM 7.5.3

Maximo Asset Management 7.6 installation process overview

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

Conditional user interface in SmartCloud Control Desk 7.5.1

IBM Support Portal: http://goo.gl/fXhKO5

Email Listener Communications via GMail

Email Listener Communications via GMail - Part I: Importing the SSL Certificate

A Note About SSL Certificates

In general, SSL certificates are acquired from certificate authorities.  The implementation of certificates falls in the province of the email server and application server.  Maximo does not directly (or even indirectly) handle or access SSL certificates.  The request for an SSL enabled connection is via a property issued to the JavaMail API.  Certificate handling occurs between the application server's JavaMail API and trust store and the email server.

Importing an SSL Certificate into Websphere 

In this case we'll be using GMail over SSL.  Websphere provides a handy feature for pulling the SSL certificate from the email server.

• Log into the Websphere console

• Navigate to Security > SSL certificate and key management > under Related Items select Key stores and certificates > CellDefaultTrustStore > under Additional Properties select Signer certificates

• Click on Retrieve from port                       

     Host:    smtp.gmail.com
     Port:     465
     Alias:    gmail (or desired alias)   

Email Listener Communications via GMail - Part II: Configuring SMTP Over SSL

System Properties

Below are the properties that will be used to connect to GMail via SMTP.  Note that the property 'mail.smtp.ssl.enable' has been added to allow authentication via SMTP over SSL.

Enabling the properties may require a full restart of the Websphere server instance hosting IBM Maximo 7.5.0.3.

 

Note: In this article only two GMail addresses will be used (servreq.user and servreq.listener).  The account servreq.listener will be used to authenticate with the SMTP server.  Your IBM Maximo system may have separate accounts for SMTP authentication and the listener.

 

Testing the SMTP Connection 

 

The SMTP connection can be quickly validated by resetting a user's password.

If mail.debug is enabled, the complete communication stream between the JavaMail API and the email server will be visible in the SystemOut log.  In this snippet the SMTP connection over SSL is apparent:

 

<snip> 

O DEBUG SMTP: useEhlo true, useAuth true
O DEBUG SMTP: useEhlo true, useAuth true
O DEBUG SMTP: trying to connect to host "smtp.gmail.com", port 465, isSSL true
O 220 mx.google.com ESMTP c17sm12626936vdj.11
O DEBUG SMTP: connected to host "smtp.gmail.com", port: 465

</snip> 

 

User PETE has received his new password via GMail.

Email Listener Communications via GMail - Part III: Sending Service Requests

Create an Email Listener

Using the out-of-the-box workflow process (LSNRBP), an Email Listener is created and activated which connects to the GMail pop server using pop3s.

Fire Up GMail and 'Talk' to the Listener

Our Service Request user is having printer difficulties so he drafts an email describing the issue using the GMail web client and sends it to the Maximo Email Listener's address.

The SR acknowledgement is received from Maximo a few moments later.

The resolver logs into Maximo and views their new Service Request which was created from an email received via GMail over SSL.

Source: https://www.ibm.com/developerworks/mydeveloperworks/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/email_listener_communications_via_gmail_part_i_importing_the_ssl_certificate8?lang=en