So the KPI is just an "internal" query on the underlying database that is being used for Maximo. You could use the Maximo API to GET the dataset based upon the same query and then use the set as you wish. ibm-maximo-dev.github.io/maximo-restapi-documentation/ Hope this helps.
It's possible: SELECT: SELECT ORGANIZATION.ABI_DRV, COUNT(ASSET.ASSETNUM) FROM MAXIMO.ASSET LEFT JOIN MAXIMO.ORGANIZATION ON ASSET.ORGID = ORGANIZATION.ORGID WHERE: WHERE ASSET.STATUS = 'DISPONIBLE' GROUP BY ORGANIZATION.ABI_DRV this is an example
Nice tutorial thanks. Had to find friends who work with Maximo 😅
Glad I could help!
What would be the url for extracting the data from the KPI to use it in Grafana?
So the KPI is just an "internal" query on the underlying database that is being used for Maximo. You could use the Maximo API to GET the dataset based upon the same query and then use the set as you wish.
ibm-maximo-dev.github.io/maximo-restapi-documentation/
Hope this helps.
I love your content, do you know if it's posible to use JOIN sentence?
It's possible:
SELECT:
SELECT ORGANIZATION.ABI_DRV, COUNT(ASSET.ASSETNUM) FROM MAXIMO.ASSET LEFT JOIN MAXIMO.ORGANIZATION ON ASSET.ORGID = ORGANIZATION.ORGID
WHERE:
WHERE ASSET.STATUS = 'DISPONIBLE'
GROUP BY ORGANIZATION.ABI_DRV
this is an example
Thanks!