Maximo

 View Only
  • 1.  Maximo Start Center Related Tables

    Posted Wed November 02, 2022 05:55 PM
    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


  • 2.  RE: Maximo Start Center Related Tables

    Posted Thu November 03, 2022 04:39 AM
    Hi,

    are you on 7.6.? There are three tables: SCTEMPLATE, SCCONFIG and LAYOUT.

    SCTEMPLATE is the templates, obviously.
    SCCONFIG is user's start center to template.
    LAYOUT is portlet to user's start center. The columns QUERYAPP and QUERYCLAUSENAME give you the queries they are using.

    Best,
    Fabian

    ------------------------------
    Fabian Selzer
    ------------------------------



  • 3.  RE: Maximo Start Center Related Tables

    IBM Champion
    Posted Thu November 03, 2022 09:38 AM
    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
    ------------------------------



  • 4.  RE: Maximo Start Center Related Tables

    Posted Thu November 03, 2022 11:27 AM
    Thanks guys, that did it.

    Brian

    ------------------------------
    Brian Hobbs
    ------------------------------