Maximo Open Forum

 View Only
  • 1.  Prevent Queries from able to be public for certain Security Groups

    Posted 03-15-2024 12:36
    Edited by Danny Richardson 03-15-2024 12:37

    Is there a security option to remove the option for users within a certain Security Group to make a query public?

    Is there a way to change Queries that users have made public to private?  

    Thank you in advance


    #Administration
    #EndUser
    #EverythingMaximo
    #MaximoUserGroups

    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------



  • 2.  RE: Prevent Queries from able to be public for certain Security Groups

    Posted 03-15-2024 18:51

    Hi Danny,

    I recommend reviewing the following thread for possible options to your first question. 

    Security Group app Permissions - public Queries (Queries app)

    You can use MxLoader to change the ISPUBLIC field from 1 to 0 to make the query private. 

    MxL_Query



    ------------------------------
    justin haley
    ------------------------------



  • 3.  RE: Prevent Queries from able to be public for certain Security Groups

    Posted 5 days ago

    @justin haley  Thank you.  I was able to pull the data but when trying to change the data I received this error:

    Please let me know if you have any suggestions.

    Thank you



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------



  • 4.  RE: Prevent Queries from able to be public for certain Security Groups

    Posted 03-15-2024 20:10
    Hi Danny Richardson! As Justin says, if it would be possible to update the ISPUBLIC value of a stored query (via MXLOADER, by database, REST or webservice)
     
    Now, about what you need to do, in a standard way, I understand that it is not possible. The reason is that the "Save current query" option is an xml system library. The MBO that represents it is called "QUERY" and is managed by "psdi.webclient.system.beans.SaveQueryBean". As it is a system library and not an application, it is not possible to configure it for a specific security group.
     
    I looked for it to do it, but I found what I told you before.
    Regards!


    ------------------------------
    Martin Fabra
    Mfsi
    ------------------------------



  • 5.  RE: Prevent Queries from able to be public for certain Security Groups

    Posted 5 days ago

    Thank you @Martin Fabra



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------



  • 6.  RE: Prevent Queries from able to be public for certain Security Groups

    Posted 03-18-2024 12:17
      |   view attached

    Danny, I have been sharing an application to manage Maximo queries with the Maximo community for a number of years... I have attached  document which describes the steps to create this handy administrative application in your Maximo... It would allow the appropriate administrator to not only change the public flag, but tune the where clause, and take ownership to be able to delete a users query.



    ------------------------------
    Stephen Hume
    Sheffield Scientific LLC
    ------------------------------



  • 7.  RE: Prevent Queries from able to be public for certain Security Groups

    Posted 5 days ago

    Thank you @Stephen Hume.  I will look further into this.  Thank you again, very kind of you.



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------