Maximo Open Forum

 View Only

 Transaction log when a public query was last use/Managing public queries

  • Administration
  • Utilities
Alan Villaverde's profile image
Alan Villaverde posted 03-04-2025 11:38

Hi,

Is there a log to see when a public query was last used?

We want to manage our growing public queries. Unfortunately, we were told that only the author can modify or delete them. However, when the person retires, we have to go to the back end to manage those queries. We were told by our IT that we have to present it to the change management board.

So as a first step, we want to know when a public query was last used then go from there to clean up.

I appreciate it if you can also share your ideas how you are managing your public queries.

Thanks.

mark robbins's profile image
mark robbins posted 03-05-2025 08:48

Unfortunately there is no way to identify when a public query has been used. 

Some people have developed customisations to make the query management easier. Searching the forum / Internet should find them

Ryan Medernach's profile image
Ryan Medernach posted 03-05-2025 11:04

On way we have done this in the past was identify a list of public queries that we wanted to track and to add Uniq ID's to the query GUID's as a comment at the start of the public query. After this was completed we had the DBA's do an audit for a range of time and they could track the exact amount of times that public query was used by tracking the GUID's specified by us.

/*{36d43500-b0a7-44f4-a4f4-3c5c56c514af}*/  

<Your query>

We could then correlate the data and identify who was running them query and how often. We have typically done this during Major version upgrades of Maximo as its a great time to clean things up.

You also mentioned updating the queries from the back end. You might want to look into setup a Query Manager tool in your Maximo Instance Link to something you might be interested in.

https://youtu.be/xXx7E5fGzQc?si=XCQXB1d67OcLQXZK

You could also go a step further and have some functionality setup to allow Maximo Admins to set the query owner to MAXADMIN (or whatever you admin user is) to allow the queries to be used in Start Center Result sets if required.

You can easily generate a list of GUIDs in excel

Using Power Query
Go to Data > Get Data > From Other Sources > Blank Query.

In the Power Query Editor, go to Home > Advanced Editor.

Replace the existing code with the following:

let
    Source = List.Transform({1..10}, each Text.NewGuid())
in
    Source
Click Close & Load to load the list of GUIDs into Excel.

This will generate a list of 10 GUIDs. You can adjust the number in {1..10} to generate more or fewer GUIDs.

Related Content