Friday, June 26, 2020

Removing keyboard shortcuts that interfere with Polish characters

While I was sorting out my notes for the new version of my book about Maximo, I found this SQL:

update maxmenu set accesskey = null where (accesskey = 'CTRL+ALT+A') or (accesskey = 'CTRL+ALT+C') or (accesskey = 'CTRL+ALT+E') or (accesskey = 'CTRL+ALT+L') or (accesskey = 'CTRL+ALT+N') or (accesskey = 'CTRL+ALT+O') or (accesskey = 'CTRL+ALT+S') or (accesskey = 'CTRL+ALT+Z')  or (accesskey = 'CTRL+ALT+X')

This very special update command, only for admins having Polish users. 
In Poland, most of the users use so called: "Polish programmers" keyboard layout. Polish accented characters are entered by pressing ALT and letter key for example:

ALT+E = ę
ALT+C = ć

Standard Maximo keyboard shortcuts overwrite Polish characters and the users are unable to write in Polish. 
Above SQL will remove the conflicting keyboard shortcuts, but... you will loose the some functionality in Maximo. The decision is yours.

If you have any questions or need further information, please feel free to contact me.

Friday, January 10, 2020

IBM Maximo Installation Date

For one of my customers I needed to check the Maximo server installation date (you can use this information for example to find which System Properties were updated--see example below.)

There was a constraint: I was not able to access database system tables (DBA restriction) and I had to do it from Maximo (no access to system folders.)

After analyzing data in different table I have found following query:

DB2 Version
select starttime from crontaskhistory order by starttime fetch first 1 rows only

MS SQL Server Version
select top 1 starttime from crontaskhistory order by starttime

Oracle Version
select starttime from crontaskhistory where rowid = (select min(rowid) from crontaskhistory)

Does anyone know a better method to find the date when Maximo was installed?


And here is the example of how to find all System Properties, which were modified after Maximo was installed (DB2 version):

select p.propname, p.description, p.maximodefault, v.propvalue from maxprop p left join maxpropvalue v on p.propnmae = v.propname where v.changedate > (select starttime from crontaskhistory order by starttime fetch first 1 rows only)

Sunday, December 22, 2019

Winter Is Coming to Plant (IBM Maximo Version)

Today is the first day of winter (in the northern hemisphere) and it may be a nice time for children, but not for the maintenance managers. They are responsible not only for their everyday duties but also need to take care of the snow and ice removal from the roofs, pavements and roads. 

It will be good to know when it will be snowing and prepare accordingly. Today, when the climate is changing, it is hard to predict the weather, but there is a FREE solution for IBM Maximo Asset Management users, which can make their life easier.
It is a simple integration, which will create a Work Order for snow removal in the morning, when the snowfall is expected.

The integration is based on Zapier service (zapier.com.) Please create free account first.

You will then create so-called Zap—a procedure, which will do the trick.

Add a component called Weather by Zapier first, which is responsible for checking the weather based on your geographical coordinates. Forecast information contains among others the information about precipitation, which we will use later.

Next component is Filter by Zapier; it is required to filter out the days when it will snow (this will be our actual trigger to create the Work Order in Maximo). You will define the precipitation type and probability here.

Final element is Webhooks by Zapier, which will call the IBM Maximo REST API to create the Work Order record. It requires the URL of your server and information about location, WO description. 
NOTE: User ID and password is required in this URL for Zapier to log in to and execute this action. It is recommended, that you have a separate user for this purpose only with limited access to the system (make sure you have a spare license.)

This is it! After few minutes of configuration, your integration is ready. You can now wait for new Work Order for snow removal. To make it even more proactive, you can define Escalation to send email notification about new Work Order.

I hope, you will not get too many snow notifications this winter and I wish you all Merry Christmas!


Below you will find sample technical details to configure the integration. Please replace the bold text in the URL with your values.

Weather by Zapier
            Trigger: Today’s Forecast (7AM)
            Latitude
            Longitude
            Units: Celsius or Fahrenheit

Filter by Zapier
            Precip Type: snow
            Precip Probability: (Number) Greater than–for example 30 (%)

Webhooks by Zapier
            Method: POST
            URL: https://SERVER_URL/maxrest/rest/os/mxwo/?_lid=USERNAME&_lpwd =PASSWORD&description=Snow%20Removal&siteid=SITE&location=LOCATION&reportedby=USERNAME&worktype=WORKTYPE
            Payload Type: form
Basic Auth: USERNAME|PASSWORD

Sunday, December 15, 2019

IBM Maximo Asset Management (Partner) World Map

Have you ever wondered who else is implementing IBM Maximo Asset Management? Where are all the consulting companies located?
This map is my answer to these questions. It was built based on my contacts network and is not yet complete, I know that there are companies in other countries too. Therefore, I would like to ask you to help me make it better.

Please contact me to update your company name (to include Ltd., A/S when needed), the web page address (maybe you have a country-specific URL?), and the countries you are operating in.

There is only one important condition: Maximo must be one of the company’s core businesses.

A special question to global companies like IBM, Accenture, or Capgemini. I know that you offer Maximo services, but not in all countries, please let me know where you have dedicated Maximo teams. 
If you want your company to be removed, please let me know too, I will do that immediately.



Maximo services are offered on 6 continents and in 56 countries! (so far...)

ContinentCountryCompanyWeb Page
AfricaEgyptMegaSofthttps://www.megasoft.com.eg
NigeriaSedin Technologieshttps://eam360.com
Republic of South AfricaVetasihttps://www.vetasi.com
AsiaChinaIBMhttps://www.ibm.com
IndiaAccenturehttps://www.accenture.com
IndiaAmstarhttps://www.amstar.in
IndiaAstin Technologyhttps://www.astintechnology.com
IndiaBahwan Cybertekhttp://www.bahwancybertek.com
IndiaCapgeminihttps://www.capgemini.com
IndiaCognizanthttps://www.cognizant.com
IndiaEnvisionhttps://www.envisionesl.com
IndiaHCL Technologieshttps://www.hcltech.com
IndiaIBMhttps://www.ibm.com
IndiaInfosyshttps://www.infosys.com
IndiaInterloc Solutionshttps://www.interlocsolutions.com
IndiaJantacarehttps://www.jantacare.com
IndiaKeegosyshttps://www.keegosysit.com
IndiaMCT India Infotechhttps://www.mctindia.co.in
IndiaLTIhttps://www.lntinfotech.com
IndiaPwChttps://www.pwc.com
IndiaSedin Technologieshttps://eam360.com
IndiaTATA Consulting Serviceshttps://www.tcs.com
IndiaTech Mahindrahttps://www.techmahindra.com
IndiaThiranhttp://thirantech.com
IndiaWiprohttps://www.wipro.com
IndonesiaVetasi (Talian Infodinamika)https://www.vetasi.com
JapanAccenturehttps://www.accenture.com
JapanAsahi Electronicshttps://www.aec.co.jp
JapanCOMTUREhttps://www.comture.com
JapanEXAhttps://www.exa-corp.co.jp
JapanIBMhttps://www.ibm.com
JapanSOLPAChttps://www.solpac.co.jp
JapanToshiba Digital Solutionshttps://www.global.toshiba/ww/company/digitalsolution.html
KuwaitPraxis Solutionshttps://www.praxis.ae
KuwaitProzonehttp://www.prozone.rs
MacauBPD Zenithhttps://www.bpdzenith.com
MalaysiaBahwan Cybertekhttp://www.bahwancybertek.com
MalaysiaCOMM-IThttps://www.comm-itgroup.com
MalaysiaStrato Solutionshttps://stratosolutions.com.my
OmanBahwan Cybertekhttp://www.bahwancybertek.com
PakistanGlobal Consultinghttp://www.gc.com.pk
PakistanOra Tech Systemshttp://www.ora-tech.com
PhilippinesCOMM-IThttps://www.comm-itgroup.com
PhilippinesMaximo Business Solutionshttps://maximoph.business.site
QatarBahwan Cybertekhttp://www.bahwancybertek.com
Saudi ArabiaBahwan Cybertekhttp://www.bahwancybertek.com
Saudi ArabiaeSolutionsMEAhttp://www.maximo.ae
SingaporeBahwan Cybertekhttp://www.bahwancybertek.com
SingaporeBPD Zenithhttps://www.bpdzenith.com
SingaporeEnvisionhttps://www.envisionesl.com
SingaporeCOMM-IThttps://www.comm-itgroup.com
ThailandTriple Dot Consultinghttps://www.tripledotconsult.com
United Arab EmiratesBahwan Cybertekhttp://www.bahwancybertek.com
United Arab EmiratesEnvisionhttps://www.envisionesl.com
United Arab EmirateseSolutionsMEAhttp://www.maximo.ae
United Arab EmiratesIBMhttps://www.ibm.com
United Arab EmiratesPraxis Solutionshttps://www.praxis.ae
United Arab EmiratesTATA Consulting Serviceshttps://www.tcs.com
United Arab EmiratesThiranhttp://thirantech.com
VietnamAvenue JSChttps://avenue-net.com
Australia/OceaniaAustraliaBPD Zenithhttps://www.bpdzenith.com
AustraliaCertushttps://www.certussolutions.com
AustraliaClarita Solutionshttps://claritasolutions.com
AustraliaCohesive Solutionshttps://www.cohesivesolutions.com
AustraliaIBMhttps://www.ibm.com
AustraliaISWhttps://isw.net.au
AustraliaQR40 Pty Ltd
AustraliaTATA Consulting Serviceshttps://www.tcs.com
AustraliaVetasihttps://www.vetasi.com
AustraliaWATT Technologieshttps://watttechnologies.com.au
New ZealandBPD Zenithhttps://www.bpdzenith.com
New ZealandCertushttps://www.certussolutions.com
EuropeAustriaSBIhttp://www.stockner-bi.at
BelgiumIBMhttps://www.ibm.com
BelgiumMacs EUhttps://macs.eu
BulgariaOpenintegrahttp://openintegra.com
CroatiaCode Developmenthttps://www.codedevelopment.com
CroatiaIBMhttps://www.ibm.com
CroatiaSmartIShttps://www.smartis.si
Czech RepublicGC Systemhttps://www.gcsystem.cz
Czech RepublicIBMhttps://www.ibm.com
Czech RepublicISP&M Consult http://www.ispm.cz
Czech RepublicVisitechhttps://www.visitech.cz
FinlandMaxiPoint Oyhttps://www.maxipoint.fi
FinlandTATA Consulting Serviceshttps://www.tcs.com
FranceAtoshttps://atos.net
FranceCapgeminihttps://www.capgemini.com
FranceEnnoviahttps://ennovia.fr
FranceIBMhttps://www.ibm.com
FranceInoteamhttp://www.inoteam.fr
FranceSopra Steriahttps://www.soprasteria.com
FranceSQLIhttps://www.sqli.com
FranceTalanhttps://talan.com
GermanyARShttps://www.ars.de
GermanyAxino Solutionshttps://axino-group.com
GermanyIBMhttps://www.ibm.com
GermanyMacs EUhttps://macs.eu
GermanyRodiashttps://rodias.de
GermanyscienITechttps://www.scienitec.de
GermanySoftacushttps://www.softacus.com
GermanySVAhttps://sva.de
GermanyTATA Consulting Serviceshttps://www.tcs.com
GreeceNousPratIThttps://nouspratit.gr
HungaryInter-Computer-Informatikahttps://intercomputer.hu
IrelandDeloittehttps://www.deloitte.com
IrelandMacs EUhttps://macs.eu
ItalyElmi SRLhttps://www.elmisoftware.com/
ItalyIBMhttps://www.ibm.com
ItalyTempestivehttps://www.tempestive.com
ItalyOmninecshttps://www.omninecs.com
ItalyUno Informaticahttps://www.unoinformatica.it
LatviaTroiahttps://www.troia.eu
NetherlandsAmosa Grouphttps://www.amosa-group.com
NetherlandsArcadishttps://www.arcadis.com/
NetherlandsAsset Peoplehttps://assetpeople.com
NetherlandsCohesive Solutionshttps://www.cohesivesolutions.com
NetherlandsGembahttps://gemba.nl
NetherlandsIBMhttps://www.ibm.com
NetherlandsLamahttps://www.lamaempowerz.com
NetherlandsMacs EUhttps://macs.eu
NetherlandsOxplushttps://oxplus.com
NetherlandsStorkhttps://www.stork.com
NetherlandsTATA Consulting Serviceshttps://www.tcs.com
NetherlandsZNAPZhttps://www.znapz-assetmanagement.com
PolandAiuthttp://maximo.pl
PolandMacs EUhttps://macs.eu
PolandOpseniohttp://opsenio.com
PolandVetasihttps://www.vetasi.com
RomaniaZNAPZhttps://www.znapz-assetmanagement.com
RussiaIBMhttps://www.ibm.com
RussiaInfoLinkhttps://www.infolinkcomp.ru
RussiaInterprocomhttps://interprocom.ru
SerbiaProzonehttp://www.prozone.rs
SlovakiaIBMhttps://www.ibm.com
SloveniaKopahttps://www.kopa.si
SloveniaTroiahttps://www.troia.eu
SpainIBMhttps://www.ibm.com
SpainVetasihttps://www.vetasi.com
SwedenEnfohttps://www.enfogroup.com
SwedenEY Skyehttp://skyeconsulting.se
SwedenIBMhttps://www.ibm.com
SwedenMidrochttps://www.midroc.se
SwedenSigma IThttps://www.sigmait.se
SwedenTotal Digitalhttps://totaldigital.se
SwedenTrivalohttps://trivalo.se
SwitzerlandEAM Swisshttps://www.eam-swiss.ch
SwitzerlandIBMhttps://www.ibm.com
SwitzerlandTATA Consulting Serviceshttps://www.tcs.com
Turkeyİntesasofthttps://intesasoft.com
UkraineVetasihttps://www.vetasi.com
United KingdomArcadis (EAMS Group)https://www.arcadis.com/
United KingdomBPD Zenithhttps://www.bpdzenith.com
United KingdomCodub Grouphttps://codubgroup.com
United KingdomCode Developmenthttps://www.codedevelopment.com
United KingdomCohesive Solutionshttps://www.cohesivesolutions.com
United KingdomECCShttp://eccs.co.uk
United KingdomeCRMhttp://www.ecrm-euro.eu
United KingdomIBMhttps://www.ibm.com
United KingdomMACS EUhttps://macs.eu
United KingdomMaxLogic Grouphttps://www.maxlogicgroup.com/
United KingdomMicrodeskhttps://www.microdesk.com
United KingdomOmninecshttps://www.omninecs.com
United KingdomPeacock Engineeringhttps://www.peluk.org
United KingdomProgressive TSLhttps://progressive-tsl.com
United KingdomSRO Solutions (Bentley Systems)https://www.srosolutions.net
United KingdomVetasihttps://www.vetasi.com
North AmericaCanadaBPD Zenithhttps://www.bpdzenith.com
CanadaCreatechhttps://www.createch.ca
CanadaEnvisionhttps://www.envisionesl.com
CanadaIBMhttps://www.ibm.com
CanadaInform Solutionshttp://informsolutions.ca
CanadaInterloc Solutionshttps://www.interlocsolutions.com
CanadaCohesive Solutions (Ontracks Consulting)https://www.cohesivesolutions.com
CanadaMaven Asset Managementhttps://www.mavenasset.com
CanadaSedin Technologieshttps://eam360.com
CanadaSheffield Scientifichttps://sheffieldscientific.com
CanadaSmartechhttp://www.smartech-tn.com
CanadaTATA Consulting Serviceshttps://www.tcs.com
CanadaTriNmaxhttps://www.trinmax.com
USAA3J Grouphttp://a3jgroup.com
USAAquitas Solutionshttps://www.aquitas-solutions.com
USAAscension Strategieshttps://ascensionstrategies.com
USAAssetOnehttps://www.assetone.net
USABahwan Cybertekhttp://www.bahwancybertek.com
USABanettihttps://banetti.com
USABPD Zenithhttps://www.bpdzenith.com
USABrass Tacks Consultinghttp://www.brasstacksconsulting.com
USACapgeminihttps://www.capgemini.com
USACohesive Solutionshttps://www.cohesivesolutions.com
USADEF Alliancehttps://defalliance.com
USAEnvisionhttps://www.envisionesl.com
USAFields Consultinghttps://www.fields-consulting-services.com
USAGenesis Solutionshttps://www.genesissolutions.com
USAHelwan Technologieshttps://www.helwantechnologies.org
USAIBMhttps://www.ibm.com
USAInnovaptivehttps://www.innovapptive.com
USAIntelligent Technology Solutionshttps://www.webuildits.com
USAInterloc Solutionshttps://www.interlocsolutions.com
USAInterPro Solutionshttps://interprosoft.com
USAJFC & Associateshttp://www.jfc-associates.com
USALucid Coasthttps://lucidcoast.com
USAMaven Asset Managementhttps://www.mavenasset.com
USAMicrodeskhttps://www.microdesk.com
USAOntracks Consultinghttps://ontracksconsulting.com
USAPerficienthttps://www.perficient.com
USAProjetechhttps://www.projetech.com
USAPrometheus Grouphttps://www.prometheusgroup.com
USAPwChttps://www.pwc.com
USAQellushttps://www.qellus.com
USASaunders Internationalhttps://saundersintl.com
USASedin Technologieshttps://eam360.com
USASentz Consultinghttps://www.sentzconsulting.com
USASheffield Scientifichttps://sheffieldscientific.com
USAStarboard Consultinghttps://starboard-consulting.com
USATATA Consulting Serviceshttps://www.tcs.com
USATotal Resource Managementhttps://www.trmnet.com
USAXybionhttps://www.xybion.com
USAZpro Solutionshttps://zprosolutions.com
South AmericaArgentinaIBMhttps://www.ibm.com
BrazilIBMhttps://www.ibm.com
BrazilMaximoConhttp://www.maximocon.com
BrazilMaxMattershttps://maxmatters.com
ChileSolexhttps://www.solex.biz/ibm-maximo
ColombiaSolexhttps://www.solex.biz/ibm-maximo
EcuadorSolexhttps://www.solex.biz/ibm-maximo
MexicoDEF Alliancehttps://defalliance.com
MexicoIBMhttps://www.ibm.com
PeruSolexhttps://www.solex.biz/ibm-maximo

Thank you for all your comments and suggestions!

P.S.
You can bookmark this article; I will update it in the future.
And, you can freely use this map in your documents, presentations, and web pages, you can share it with others, please only reference the source.

Removing keyboard shortcuts that interfere with Polish characters

While I was sorting out my notes for the new version of my book about Maximo, I found this SQL: update maxmenu set accesskey = null where (a...