Hi!  Question for the Maximo Community - 

We have had a number of requests to enable an additional layer of access to Maximo queries.  Currently - there are 2 access levels:  Private and Public.
    Private:  Query available to creator only
    Public:  Query available to creator + anyone with access to application

Clients have asked for a 3rd level - to enable query access at a group level - which would enable this access:  

    Group:  Query available to creator + any specified group

Question to you is - what type of group level would you like to see?   Options are -

1.  Security Group
2.  Person Group
3.  Crew
4.  New Query Group - where you would define which users would be a member

Please respond with what group level access you would most like to see.

Thank you!

------------------------------
Pam Denny
IBM Maximo Anywhere Offering Manager
------------------------------



#MaximoEAM
#AssetandFacilitiesManagement
#Maximo

I think security groups makes the most sense for a majority of our customers. It's already used to define access and this is arguably an access restriction. ​That being said, I think the query mapping should support 1:many security groups so new groups could be added that should have access to the query. For example, a query could be useful for Technicians & Supervisors which might be in two different security groups in Maximo. This would keep management simple as security groups are already maintained today.

Most customers aren't utilizing crews and person groups are used heavily to drive assignments & communications so cluttering that with person groups that just control query access I think would be confusing. I think it would also cause people to assign work orders to a group that was intended solely for viewing queries, which could result in work not getting completed on time.  

------------------------------
Steven Shull
Director of Development
Projetech Inc
Cincinnati OH
------------------------------

Hi Pam! Thanks for doing this.  At the person group level would be very helpful for us. Users are going a little crazy with their new found saved query skills and making a bunch of public queries that are not applicable to many users. What these users really want to do is just make it public within their workgroup (aka person group).

------------------------------
Sharon MacDonald
Shire
7816974682
------------------------------

Sysadmins already have the ability to restrict reports by security group; I think the most bang for the buck would lie with one of the other options. That said, our tiny organization wouldn't benefit much from a third level of access, since we barely use the feature at all.

Bob

------------------------------
Robert Goff
------------------------------

Hi, 

Back in 2017 one of the BPD Zenith Team, Stephen Hume, developed this for Person Groups and shared the instructions with the MaxTECH sessions which run along side Maximo User Forums.
https://www.bpdzenith.com/limit-the-number-of-queries-visible-in-an-application-in-maximo/

I've uploaded the presentation file which shows how to create a Query Manager App which will allow administrators to edit other people's queries, show which start centres a query is used in and restrict to certain person groups.

------------------------------
Paul Irving
Product Development Lead
BPD Zenith Ltd
------------------------------

Hi Pam,
I agree with the others that Security Groups would be best to use for managing the query access.  I think my second choice would be the 'New Query Group' which could allow membership across roles, work groups and security levels.  Thanks for asking!

 R/Lani Trotter

------------------------------
Lani Trotter
Functional Analyst
Starboard Consulting
------------------------------

I think a new Query Group would work well especially well as we have queries that are used/shared between different roles. This would allow a central source of truth for the query which would have an owner(s) that would be in charge of maintaining that query. Second choice would be Security Group.

------------------------------
Ryan Medernach
Application Support
MEG Energy
Calgary AB
-
------------------------------