Hameed and his teacher

A small boy named Hameed lived in a village in Morocco. None of his classmates liked him because of his stupidity, especially his teacher, who was always yelling at him "You are driving me crazy Hameed!!!!!"


One day hameed's mother came into school to check on how he was doing. The teacher told his mother honestly, that her son is simply a disaster, getting very low marks and even she had never seen such a dumb boy in her entire teaching career!!!! The mother was shocked at the feedback and withdrew her son from the school & even moved to another town!!!!!




25 years later, the teacher was diagnosed with an incurable cardio disease! All the doctors strongly advised her to have an open heart operation, which only one surgeon could perform.......




Left with no other options, the teacher decided to have the operation, which was successful...... When she opened her eyes after the surgery she saw a handsome doctor smiling down at her! She wanted to thank him, but could not talk. Her face started to turn blue, she raised her hand, trying to tell him something but eventually died!


The doctor was shocked and was trying to work out what went wrong, when he turned around he saw our friend Hameed, working as a cleaner in the clinic, who had unplugged the oxygen equipment to connect his Mobile Charger !!!!!






Don't tell me you thought that Hameed became a doctor???? :D :D

Good Day..Have a great Week ahead :) collapse


----------------------------------------------------------------------------
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.

Adding messages in processing rules of Enterprise services in Maximo

Below are the steps which are to be followed to make sure messages can be properly added in enterprise services à processing rules.

·         Create an entry in Messages from database configuration making sure that messagegroup value is ‘iface’  example below

o   Message Group :iface

o   Message Key : VALIDATIONALERT

o   Display Method : MSGBOX

o   Value : Alerting user

·         Now navigate to Enterprise services à Processing rules and select this value from lookup attached to Message Key.

----------------------------------------------------------------------------
 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.

Fetching last 6 months data in Maximo using SQL Server with output in a specific language

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database in a specific language.
here i am using Portugese as lanuage in which my output should be

Query is self explanatory


select CASE month
WHEN  'January' THEN 'Janeiro de'
WHEN  'February' THEN 'Fevereiro'
WHEN  'March' THEN 'Março de'
WHEN  'April' THEN 'Abril'
WHEN  'May' THEN 'Maio'
WHEN  'June' THEN 'Junho de'
WHEN  'July' THEN 'Julho'
WHEN  'August' THEN 'Agosto'
WHEN  'September' THEN 'Setembro de'
WHEN  'October' THEN 'Outubro'
WHEN  'November' THEN 'Novembro de'
  ELSE 'Dezembro de'
END 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
Setembro de 0
Outubro 0
Novembro de 0
Dezembro de 22
Janeiro de 57
Fevereiro 34






----------------------------------------------------------------------------
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 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.

moral story ..change ur perspective

At a fundraising dinner for a school that serves children with learning disabilities, the father of one of the students delivered a speech that would never be forgotten by all who attended. After extolling the school and its

dedicated staff, he offered a question:

'When not interfered with by outside influences, everything nature does, is done with perfection.

Yet my son, Shay, cannot learn things as other children do. He cannot understand things as other children do.

Where is the natural order of things in my son?'

The audience was stilled by the query.

The father continued. 'I believe that when a child like Shay, who was mentally and physically disabled comes into the world, an opportunity to realize true human nature presents itself, and it comes in the way other people treat that child.'

Then he told the following story:

Shay and I had walked past a park where some boys Shay knew were playing baseball. Shay asked, 'Do you think they'll let me play?' I knew that most of the boys would not want someone like Shay on their team, but as a father I also understood that if my son were allowed to play, it would give him a much-needed sense of belonging and some confidence to be accepted by others in spite of his handicaps.

I approached one of the boys on the field and asked (not expecting

much) if Shay could play. The boy looked around for guidance and said, 'We're losing by six runs and the game is in the eighth inning. I guess he can be on our team and we'll try to put him in to bat in the ninth inning.'

Shay struggled over to the team's bench and, with a broad smile, put on a team shirt. I watched with a small tear in my eye and warmth in my heart. The boys saw my joy at my son being accepted.

In the bottom of the eighth inning, Shay's team scored a few runs but was still behind by three.

In the top of the ninth inning, Shay put on a glove and played in the right field. Even though no hits came his way, he was obviously ecstatic just to be in the game and on the field, grinning from ear to ear as I waved to him from the stands.

In the bottom of the ninth inning, Shay's team scored again..

Now, with two outs and the bases loaded, the potential winning run was on base and Shay was scheduled to be next at bat.

At this juncture, do they let Shay bat and give away their chance to win the game?

Surprisingly, Shay was given the bat. Everyone knew that a hit was all but impossible because Shay didn't even know how to hold the bat properly, much less connect with the ball.

However, as Shay stepped up to the

plate, the pitcher, recognizing that the other team was putting winning aside for this moment in Shay's life, moved in a few steps to lob the ball in softly so Shay could at least make contact.

The first pitch came and Shay swung clumsily and missed.

The pitcher again took a few steps forward to toss the ball softly towards Shay.

As the pitch came in, Shay swung at the ball and hit a slow ground ball right back to the pitcher.

The game would now be over.

The pitcher picked up the soft grounder and could have easily thrown the ball to the first baseman.

Shay would have been out and that would have been the end of the game.

Instead, the pitcher threw the ball right over the first baseman's head, out of reach of all team mates.

Everyone from the stands and both teams started yelling, 'Shay, run to first!

Run to first!'

Never in his life had Shay ever run that far, but he made it to first base.

He scampered down the baseline, wide-eyed and startled.

Everyone yelled, 'Run to second, run to second!'

Catching his breath, Shay awkwardly ran towards second, gleaming and struggling to make it to the base.

B y the time Shay rounded towards second base, the right fielder had the ball . the smallest guy on their team who now had his first chance to be the hero for his team.

He could have thrown the ball to the second-baseman for the tag, but he understood the pitcher's intentions so he, too, intentionally threw the ball high and far over the third-baseman's head.

Shay ran toward third base deliriously as the runners ahead of him circled the bases toward home.

All were screaming, 'Shay, Shay, Shay, all the Way Shay'

Shay reached third base because the opposing shortstop ran to help him by turning him in the direction of third base, and shouted, 'Run to third!

Shay, run to third!'

As Shay rounded third, the boys from both teams, and the spectators, were on their feet screaming, 'Shay, run home! Run home!'

Shay ran to home, stepped on the plate, and was cheered as the hero who hit the grand slam and won the game for his team

'That day', said the father softly with tears now rolling down his face, 'the boys from both teams helped bring a piece of true love and humanity into this world'.

Shay didn't make it to another summer. He died that winter, having never forgotten being the hero and making me so happy, and coming home and seeing his Mother tearfully embrace her little hero of the day!