Displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Below query can be used for displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Data would be displayed like below

Priority          Count Status
1                 1        SLA OK
1                   2        SLA NOT OK
3                  15      SLA OK


Query :

select internalpriority,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" and="" by="" count="" from="" group="" internalpriority="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by internalpriority










----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Display Number of tickets solved with in SLA by person in Maximo .. SQL Server

Below query can be used for displaying data solved with in SLA by person in MAXIMO using SQL Server.

Data would be displayed like below

AffectedPerson Count Status
ABC                   1        SLA OK
ABC                   2        SLA NOT OK
XYZ                   15      SLA OK


Query :

select affectedperson,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" affectedperson="" and="" by="" count="" from="" group="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by affectedperson







----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Displaying tickets created from different sources in Maximo using Sql Server

Below query can be used to display number of tickets which are created from different sources(here external systems) as per months.

Output would be like below

Source  Month count
Email    Dec       10
Email     Jan        14
Phone    Jan         15
self Serv  Dec      05

Query:

select externalsystem,DATENAME(MONTH,DATEADD(month, 0, creationdate)) month ,count(*) count  from TICKET  group by externalsystem , DATENAME(MONTH,DATEADD(month, 0, creationdate))








---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Fetching Last 6 months data in SQL Server for Maximo

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database.

Query is self explanatory

select month,countoftickets from (
SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1
order by fs

output:

Month   Countoftickets
October 10
November 12
December   5
January   17
February 20
March 15











---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Enable Workflow reassignments in Maximo based on security groups

1.       Simple way to enable workflow reassignments in application is through Signature options and security group.

2.       Navigate to any application in which you need Workflow reassignment option thorough application designer. In this case I am taking Requests and Defects (Oil) -- PLUSGDEF

3.       From select action add a sig option called ‘MAXWFRA’ with a  simple desc and save the record.

4.       Now navigate to the security group for which this access  has to be enabled and check the sigoption under the application (PLUSGDEF).

5.       After signing out and signing in as a user from that security group ,When you navigate to Requests and Defects (Oil) application and select a record with an active workflow . Observe that Reassignments icon is visible.

----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

How to wrap attributes in Birt based on space.

In the attribute which you want to wrap add the following code which wraps after every space to next line

if(dataSetRow["description"]!=null){

  dataSetRow["description "].replace(/ /g,"\n")

 }

/ /g à means white space anywhere in the string

----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

How to wrap data attributes in Birt Report

Below function would be useful for wrapping the data present in a field.

if(dataSetRow["description"]!=null){

function wrap(longStr,width){ length = longStr.length; if(length <= width) return longStr; return (longStr.substring(0, width) + "\n" + wrap(longStr.substring(width, length), width)); }wrap( dataSetRow["description"], 15 );

}

in the above function, i am trying to wrap description field to a size of 15.

Only disadvantage of this is that it includes hard stops so after every 15 characters which can be frustrating to a user who uses the report in a excel sheet.

----------------------------------------------------------------------------
All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo .. Update database using Birt report

Sometimes database has to be updated after each report run showing that a report  has been run(example like last run date).

In Birt simple way to achieve this is to execute update query in the 'beforeClose' method of dataset.

var myTxn = MXReportTxnProvider.create("maximoDataSource");


var updateSqlText = new String();

updateSqlText = " update poline set enterdate=SYSDATE  where enterdate is null'";

var apextractStmt = myTxn.createStatement();
apextractStmt.setQuery(updateSqlText);

myTxn.save();

---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

SQL Server & Maximo .. How to split GL account in SQL Server

Below query can be used in sql server to split a GL account which has 3 components in to individual components divided by '-' (ex : 100010123-abcd-1234 will be divided into gl1- 100010123, gl2- abcd , gl3 - 1234) .

select gldebitacc,

substring(gldebitacc,0,CHARINDEX('-',gldebitacc)) as gl1,

substring(gldebitacc,CHARINDEX('-',gldebitacc)+1,len(gldebitacc)-(CHARINDEX('-',gldebitacc)+charindex('-', reverse(gldebitacc)))), as gl2,

REVERSE(substring(reverse(gldebitacc),0, charindex('-', reverse(gldebitacc)) )) as gl3

 from

poline


----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo Automation script .. How to find the parent Mbo and set value

Below is the sample code which can be used for finding the parent Mbo (ex invoiceline is parent for invoicecost) and setting values.I am using a attribute launchpoint on child mbo (ex invoicecost) which is called from invoiceline when filling gldebitaccout

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants


parentMbo=mbo.getOwner()
parentMbo.setValue("description","test", MboConstants.NOACCESSCHECK|MboConstants.NOVALIDATION_AND_NOACTION)



----------------------------------------------------------------------------

 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Maximo Automation Script .. Split GL account

Below is the script which can be used for splitting the GL account to components

from psdi.mbo import MboConstants
from psdi.mbo import GLFormat
from java import util

 glComp1=mbo.getValue("gldebitacc").split('-')[0]
glComp2=mbo.getValue("gldebitacc").split('-')[1]
glComp3=mbo.getValue("gldebitacc").split('-')[2]

----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Java Freshers Recruitment in Accenture

Destiny reveals fortune at the end of your expedition. Recruitment Event for ASE Level Candidates For Java Skill At Accenture, we value achievers like you who have the zeal to go an extra mile for fulfilling a mission. We are on a look out for such high performers and we believe you can help us find some. Bring in exceptional talents from your network of friends and family who could seamlessly click at Accenture and help us take the path forward.   Criteria: 1.      Good understanding of Core Java/ Java Concepts/ Java Enterprise Edition (Any of these) 2.      Knowledge on J2EE / Spring /Hibernate/Servlet (Any of these). 3.       Good Communication Skills. 4.      Engineering Graduate with =/> 60%. 5.      Work location – Across all locations(Bangalore, Chennai, Hyderabad, Mumbai, Pune) 6.     Experience level from 03 to 12 months. 7.   Candidates willing / available to join us in May 2015 (Immediate joiners)  If your friend’s profile matches the abovementioned criteria, simply log on to https://employeereferrals.accenture.com and start referring How to refer: ·         Search for opening on employee referral portal with the following criteria - [Search Box - J2EE Programming - Application ][location – Bangalore, Chennai, Hyderabad, Mumbai, Pune] [level – 12] [Career Track – Client Delivery and Operations]. (If you are not able to refer on employee referral portal please send the resume with subject line as ‘Opportunity for Java Skill!!’ at (idc.talentscout@accenture.com). ·         Upload the profile ·         Once the profile is successfully uploaded – you would get an auto generated mail with a unique CID number for the candidate. ·         You can use the CID number to track the status of the referred candidate. Note:  Referral bonus is not applicable for this hiring Event Details: Date 14th 16th 20th & 23rd May-2015 (will be confirmed to selected candidates via email) Reporting Time Will be mailed to selected candidates Venue Will be mailed to selected candidates Please Note: ·         Please refer only resume / CV of candidates matching the criteria. Any resume / CV of candidate referred but not matching criteria will not be considered for further processing. ·         Suitable candidates will be contacted directly from Accenture recruitment team  Regards, Talent Scout Team Technology, India

----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Accenture Recruitment for freshers

  Associate Software Engineer

Referrals are your clues to finding a treasure. Narrow your quest, search for peers, and find us credible crew members. Each referral will bring you closer to the treasure. The more number of referrals, the closer you get to your reward.

Qualifications and other criteria:

·       MCom pass-out (2011 onwards) who should be a graduate in BCom/Bachelor of Commerce in Accounting & Finance (BAF)/Bachelor of Management Studies (BMS)

·        Should have scored 60% or above with no current backlogs

·        Should be available to join us on or before May 15, 2015

Selected candidates would be trained in SAP FICO.

Work location: Bangalore

Referral award: INR 5000

How to refer:

·         Search for an opening on employee referral portal with the following criteria - [Search Box - SAP-FI-Financial Accounting=] [location - Bangalore] [level – 12] [Career Track – Client Delivery and Operations].

·         Upload the profile.

·         Once the profile is successfully uploaded, you would get an auto generated mail with a unique CID number for the candidate.

·         You can use the CID number to track the status of the referred candidate.

If you are not able to refer on employee referral portal please send the resume with subject line ‘Destiny reveals fortune at the end of your expedition’ to idc.talentscout@accenture.com.

Shortlisted candidates will get a mail from Accenture recruitment team on schedule confirmation for interview on April 26, 2015 and May 3, 2015.

Do not wait any longer, start referring today.

----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.