SQL QUERIES FOR KPI IN MAXIMO
Validate KPI's & Metrics in Maximo - MyGeekDaddy
Apr 15, 2013SQL Query for Maximo KPI to monitor PM to CM Labor Hours: Listed below is the SQL query to use in Maximo's KPI module to generate a PM to CM labor hour ratio. The entire query should be placed in the 'Select' box and the 'Where' box will remain empty. Make
Creating a result set query in Maximo - InterPro Solutions
Aug 16, 2011At the heart of every start center in Maximo is the result set. This is a user defined query that you can create and save on any object you want from within Maximo. You can create a query to return a list of workorders, assets, locations, etc. Once you have setup a query,..
IBM Maximo Asset Management - Creating SQL queries
Creating SQL queries, escalations, and notifications for work records. You can create SQL queries to select work records that meet certain criteria and view the result set in the Start Center. You also can send notifications to work owners if certain criteria is not met. For example, if there is no work log
Understanding and creating KPI's for - InterPro Solutions
Sep 29, 2011As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo. Check out our products by clicking on the following links: EZMaxMobile, EZPlanner and EZInsight.
Creating queries in Maximo Asset Management
When you create queries in Maximo® Asset Management, you specify search criteria that suit the requirements of the target user groups in Maximo Anywhere. About this task You create work list queries in the Maximo application that authorizes access to the primary resource for the mobile app.[PDF]
Maximo’s Key Performance Indicators (KPIs)
• Introduced January 2004 for Maximo 5.2 and beyond • Can be downloaded from IBM Support Online (with active support) for Maximo 5.2, included in 6.x and 7.x. • Allows users to create KPIs on the fly using a query in an application or simple SQL • Comes with 13 KPIs out-of-the-box (MAXDEMO
Find Columns in All Tables With This Maximo SQL Script
Sep 05, 2019This is a useful SQL script that will search through all the tables in a database for a specific field name and return the tables where that field is found. Think of it as the Maximo equivalent to a search in Windows. In Windows, you can search for files by name, by keywords, by folders with words in
Building your own 'special' Maximo query - MyGeekDaddy
Location HierarchyAsset HierarchyRouted Locations & AssetsFinal QuerySummaryThe first one we tackled was all of the Locations in the area of the plant. The Maintenance Manager had first tried using the \"Search Location Hierarchy\". I love this box because it can give just about any Maximo user a built-in demonstration of a sub-select query in Maximo. Because the Location Hierarchy and Location Parent records reside on tables, other than the LOCATIONS table, Maximo will give the sub-select query if a user looks at the Where Clause in the Advanced Search. After determin..See more on mygeekdaddy
IBM Saved queries listed by description
In Maximo 7.5 or higher , the Saved Query drop-down menu now shows values from the QUERYRIPTION attribute of a query record in all applications. In previous Maximo versions, like 7.1.x, it used to show the QUERYSENAME field. The screen shot below is how Maximo
New in Maximo 7.6: KPI Templates – A3J Group
Nov 18, 2017From the Select Action menu, choose the Generate KPIs option. Maximo will prompt you with the results. Press the OK button. You can now navigate to the Administration > KPI > KPI Manager application and see your 3 new KPIs. Please note that if you make changes to the KPI in the KPI Manager application that you may void the link with the template.
Related searches for sql queries for kpi in maximo
maximo sql queryexample of sql queriessql queries pdfsql queries in oraclesample sql queriessql database queries examplessql queries tutorialselect queries in sql