Maximo EAM

 View Only
  • 1.  Maximo Queries - Private, Public

    Posted Wed March 11, 2020 08:10 AM

    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

  • 2.  RE: Maximo Queries - Private, Public

    Posted Wed March 11, 2020 08:44 AM

    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

  • 3.  RE: Maximo Queries - Private, Public

    Posted Tue March 31, 2020 08:38 AM
    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

  • 4.  RE: Maximo Queries - Private, Public

    Posted Tue May 26, 2020 12:06 PM
    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.


    Robert Goff

  • 5.  RE: Maximo Queries - Private, Public

    IBM Champion
    Posted Thu May 28, 2020 09:39 AM
      |   view attached

    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.

    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

  • 6.  RE: Maximo Queries - Private, Public

    Posted Fri May 29, 2020 10:32 AM
    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

  • 7.  RE: Maximo Queries - Private, Public

    Posted Mon June 01, 2020 01:04 PM
    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