Hi Brian,
Assuming your start centre is assigned to a group and someone has logged in you should be able to get the info by running:
SELECT DISTINCT app, clausename, query.description QueryDesc, layout.description PortletDesc, scconfig.DESCRIPTION SCDesc FROM query
LEFT OUTER JOIN layout ON app=queryapp AND clausename = queryclausename
LEFT OUTER JOIN scconfig ON layout.SCCONFIGID = scconfig.scconfigid;
Alternatively, you could search through the xml presentation to find it, though the query is much less efficient:
SELECT DISTINCT app, clausename, query.description, sctemplate.DESCRIPTION FROM query
LEFT OUTER JOIN SCTEMPLATE ON PRESENTATION LIKE '%queryclausename="'|| CLAUSENAME ||'"%';
swap the || for + if you're on SQL Server.
Hope that helps.
------------------------------
Paul Irving
Product Development Manager
BPD Zenith Ltd
------------------------------
Original Message:
Sent: Wed November 02, 2022 05:54 PM
From: Brian Hobbs
Subject: Maximo Start Center Related Tables
I am trying to id all tables having to do with determining who has what start centers and which queries they are using. I am going thru the ERD but not making very fast progress and am wondering if any has some info.
Brian
------------------------------
Brian Hobbs
------------------------------
#AssetandFacilitiesManagement
#Maximo