[SCCD] Finding Parameter Value of Report Schedule

Some report have parameter to filter the result records. But when these reports have been set as schedule we can not see it in the system. However, we can see these value for each parameter in the database.

Firstly you can query data in REPORTSCHED table. You will see report schedule information. Then notice the CRONTASKNAME and INSTANCENAME.

These 2 values are also in CRONTASKPARAM table. So you can see parameter value in this table by using where CRONTASKNAME and INSTANCENAME.

 

Read More

[SCCD] Access maximo without /maximo

You can make your base web address to http://hostname/ instead of http://hostname/maximo using IBM HTTP server configuration, without restarting Maximo/SCCD.
1. Open the WAS console–>Servers–>WebServers –>webserver1 .

2. Click the Edit button next to the httpd.conf file to edit the configuration file of the webserver.

3. Remove # in the line: LoadModule rewrite_module modules/mod_rewrite.mod
With removing # you enable this rewrite module.

4. Add the following at the end of the file config file:

RewriteEngine On
RewriteCond %{SERVER_PORT} ^80$
RewriteRule ^/$ /maximo/ [R=301,L]

5. Generate plugin, Propagete plugin and restart webserver.
Try now the address: http://hostname/ , and your Maximo SCCD login screen will welcome you.

 

Thanks Tamas Kubicsek

Reference : http://maximodev.blogspot.com/2014/04/change-maximo-base-web-address.html

Read More

[SCCD] Push button to change Tab

Some trick to create button to change tab, you can do it via Application Designer.

In push button properties assign Event as “click” and Target ID is <Control ID of destination Tab>

Read More

[SCCD] Hide Some Status in Change Status Dialog

In Change/Work Order Application, there are a lots of status. To reduce the list you can filter it out by steps below.

  1. Create Condition in Conditional Expression Manager Application with expression below

    :&USERNAME& in (SELECT USERID FROM GROUPUSER WHERE GROUPNAME = ‘MAXADMIN’)

    above condition is to allow only system admin can see it.

  2. Select WOSTATUS domain in Domain Application.
  3. Select Value you want to hide it. And Click View/Modify Condition
  4. Fill the condition is step 1 and select the application you want to hide the status.

 

Thank this technote for guideline.

Read More

[SCCD] increase size of TICKETID

To change size of TICKETID of TICKET object. You also need to change several object to avoid some error.

which are

RECORDKEY in the WORKVIEW object
RECORDKEY in the WORKLOG object
TICKETID in the TKSTATUS object
ORIGRECORDID in the TICKET object
RELATEDRECKEY in the RELATEDRECORD object
OBJECTKEY in the INBOUNDCOMM object

 

Reference : https://developer.ibm.com/answers/questions/212594/how-do-you-modify-ticketid-when-numbers-run-out/

Read More

[SCCD] Doclink Relationship

ให้ Activity สามารถเห็นไฟล์แนบที่อยู่ใน Ticket เดียวกันได้

(ownertable=’WOACTIVITY’ and ownerid in (select workorderid from woactivity where origrecordid=:origrecordid and istask=0 and siteid=:siteid))

 

ให้ Activity สามารถเห็นไฟล์แนบที่อยู่ใน Parent (Ticket) ได้

(ownertable in (‘SR’,’INCIDENT’,’PROBLEM’) and ownerid in (select ticketuid from ticket,woactivity where woactivity.origrecordid=ticket.ticketid and woactivity.origrecordclass= ticket.class and woclass=’ACTIVITY’ and wonum=:wonum))

 

ให้ Activity สามารถเห็นไฟล์แนบที่อยู่ใน Related Ticket กับ Parent ได้

(ownertable in (‘SR’,’INCIDENT’,’PROBLEM’) and ownerid in (select recordkey from ticket,relatedrecord where ticketid=recordkey and ticket.class = relatedrecord.class and relatedreckey=:origrecordid))

Read More

[SCCD] Automation Script function to check membership of security groups

I got a requirement to validate field when user are in specific security groups.

After googling, I found this entry http://www.learnsccd.com/2015/02/maximo-automation-script-validate-group.html (Thank you) . It explains how to validate group membership of current user login.

So I cut some part of code and make it as jython function for reuse next time.

 

s_secgroupset = “‘MAXADMIN’,”,’MAXREG'”
s_rem = “*****”

def ingroup():
mbosetMaxuser = MXServer.getMXServer().getMboSet(“MAXUSER”, mbo.getUserInfo())
mbosetMaxuser.setWhere(“userid = ‘” + user + “‘”)
mbosetMaxuser.reset()
mboMaxuser = mbosetMaxuser.moveFirst()

if (mboMaxuser is not None):
mbosetGroupUser = mboMaxuser.getMboSet(“GROUPUSER”)
mbosetGroupUser.setWhere(“groupname in (” + s_secgroupset + “)”)
mbosetGroupUser.reset()
print s_rem+”Where Clause: “+str(mbosetGroupUser.getCompleteWhere())
mboMaxGroup = mbosetGroupUser.moveFirst()

if (not mbosetGroupUser.isEmpty()):
print s_rem+”in groups”
return 1

if (mbosetGroupUser.isEmpty()):
print s_rem+”not in groups”
return 0

 

Read More

[DB2] Export Data with command

Run Program > IBM DB2 > DB2COPY1 > Command Line Tools > Command Line Processor or run db2cmd

Type

connect to MAXDB75

Type

export to assets.csv of del modified by nochardel select * from maximo.asset

Read More

[SCCD] Filter Graph Option Display by attribute of Result Set

When you enable graph option for result and select display by attribute, you might confuse with many attributes as example below.

querycolumn1

SCCD shows all attributes (query column) which are in object of result set’s query.

Read More

Read More

[SCCD] Report error “Premature end of file”

We found an error “org.xml.sax.SAXParseException: Premature end of file” during run report on IE and Chrome (but not on Firefox).

 

After investigation and searching information, we found that this error is about prototype.js in com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar (https://bugs.eclipse.org/bugs/show_bug.cgi?id=310512)

 

The solution to fix is replace new com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar in directory

/opt/IBM/WebSphere/AppServer/profiles/ctgAppSrv01/installedApps/ctgCell01/MAXIMO.ear/maximouiweb.war/WEB-INF/birt/platform/plugins

Then restart Application Server

 

You can download new com.ibm.tivoli.maximo.report.birt.viewer_1.0.0.jar here

 

 

 

Read More