Share This:

Please join Mark and Rajendra as they present on Using the Subquery Option to Optimize Row Level Security Searches during the June 24th webinar.


In this session they will review what is Row Level Security (RLS), differences between the existing RLS options and RLS subquery options.  Also covered RLS Subquery implementation, enabling, format of queries, troubleshooting best practices and how the subquery option can improve performance.


Mark Walters is a Principal Technical Support Analyst

Rajendra Kapale is a Lead Product Developer


Below is the recording from the live webinar it is also available as a podcast on iTunes.



Subscribe to the BMC Helix Remedy & Discovery Youtube Channel


Presentation References


Presentation Q&A

Q: What are the different values available for Algorithm apart from Subquery?

A: Combined LIKE’s is the original implementation and  RLS_Split was added in a later 8.1 service pack.  Subquery was introduced in 1902.


Q: Can Subquery algorithm be used for CMDB forms as well?

A: Yes, CMDB forms may also use this algorithm but it is recommended not to create overlays for CMDB forms.  Make the change in base mode for CMDB forms and it will remain intact during CMDB upgrade


Q: In the example for Join forms it was suggested to enable the S table on BaseElement form, but BMC best practices suggest to not overlay the Core CMDB forms. What's the suggested approach for enabling this for CMDB join forms in this case?

A: Enable the subquery algorithm in base mode for CMDB forms as overlays are not recommended. This change will remain intact during upgrades.


For more information, or if you have questions, please contact Gregory Kiyoi or Jeff Hudson

Remedy AR System  Remedy ITSM  CMDB  Discovery  Digital Workplace BMC Helix