Hi @Bhuvan  

  Thank you so much for providing with actual-tried and tested example to solve my issue with business rule. One of the other approaches I tried (apart from different 'where' clauses in the view tables I listed above) was to create a query business rule and I used exactly the same logic as you did, to filter out records from the database view. 

The problem I rain into with that approach is that, currently there are around 7000 records from sys_user table and 100 records from recovery teams table, which brings my database view to having 700,000 records. There is an in-built ServiceNow scripted query limitation that only returns first 10k records. So, my gliderecord query is not looping through the complete set of 700k records. 

There is a ServiceNow system property 'glide.db.max_view_records' that needs to be set with higher value as ServiceNow takes it as 10,001 by default. I want to know if setting this value to a higher value is a good approach to follow in order to achieve my requirement. Do you have any idea on that?

Thanks for your help.