Maximo Open Forum

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
------------------------------

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. 

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

@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
------------------------------

Original Message:
Sent: 03-15-2024 17:28
From: justin haley
Subject: Prevent Queries from able to be public for certain Security Groups

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. 

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

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

Thank you @Martin Fabra

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

Original Message:
Sent: 03-15-2024 20:09
From: Martin Fabra
Subject: Prevent Queries from able to be public for certain Security Groups

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
------------------------------

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
------------------------------

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

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

Original Message:
Sent: 03-18-2024 12:17
From: Stephen Hume
Subject: Prevent Queries from able to be public for certain Security Groups

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
------------------------------