From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | May 15, 2017

BIRT Reports: Restricting Users

The following approach will restrict users running reports to see only the records that belong to sites they have access to. The benefits of this approach are:

It’s dynamic

There’s no need to hardcode the SITEID into the query. The user can change their default insert site and re-run the report to see a different set of data:

It uses Maximo’s security model

The list of values in the “Default Insert Site” will only display the sites that the user has access to (based on the sites listed under “Sites” tab of the security groups that they are part of). This ensures that the user cannot run the report for a site they don’t have access to:


1. Add a new report parameter “userName” (case sensitive). This is an internal parameter used by the report and auto-populated by Maximo with the ID of the user that is running the report:
2. Use the parameter in your main query:

3. When you add the report to Maximo (via the “Report Administration” application and “Import Report” action), make sure you delete the “userName” parameter. The user must not see this parameter for two reasons:

  1. It is auto-populated by Maximo with the ID of the user that’s running the report
  2. We don’t want the user to run the report under a different user’s ID who has access to sites the current user doesn’t.

4. For reports that need to be run for multiple sites (whether it’s multiple sites at once or one different site at a time), we can do the following:

  1. Add SITEID as an optional parameter (multi-select)
  2. If SITEID parameter was left blank by the person running the report, we will default the site in the query to their default insert site as described above.
Adel Rustum

Adel Rustum

Adel has been providing consultancy services for Maximo since 2011, tackling everyday user reported issues, implementing solutions, developing new functionality, and making recommendations on using industry best practices. He has international experience in working with clients of different industries, and currently he is based out of BPD's office in Calgary, AB, Canada.


What is Asset Performance Management?

What is Asset Performance Management?

What is Asset Performance Management? Introduction As a definition, Asset Performance Management (APM) encompasses the capabilities of data capture, integration, visualization, and analytics tied together for the explicit purpose of improving the reliability and...

Maximo Relationships

Maximo Relationships

In this blog I will be explaining what a Maximo Relationship is, how to create one, and, the benefits of having Maximo Relationships. What is a relationship? The way in which two or more things are connected, or the state of being connected.Why do we need Maximo...

Maximo Data Imports: A simplified guide

Maximo Data Imports: A simplified guide

All your Maximo data import needs simplified Being able to manage data loads and data extracts is a powerful ability. It can substantially improve processes and reduce delays. Maximo offers not one but multiple ways of handling data. Equipped with user-friendly error...

Custom servlet in Maximo

Custom servlet in Maximo

What is a servlet? Servlets are Java classes which service HTTP requests and implement the ‘javax. servlet. HttpServlet’, an abstract class that implements the servlet interface and is specially designed to handle HTTP requests. A  servlet accepts the request,...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Partner Ecosystem

BPD Zenith partners with a diverse array of the world’s top Technology, Business and Solution Integration leaders.