How to filter only active users in report sharing option?

[hyperjam]

How to filter only active users in report sharing option? As of now the list of all users is available. The desired state is that only active/not locket-out users are available.

I do found same question on the community, however it is not understandable for me where exactly to configure the dictionary (i see there is some assigned_to field being configured, but what table is that)

https://community.servicenow.com/community?id=community_question&sys_id=80f14fa9db98dbc01dcaf3231f96...

[Ankur Bawiskar]

Hi,

there should be out of the box query business rule on sys_user table which should show only active users

can you check the BR is active or not OR some condition got updated in it?

BR Name:

user query

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Harsh Vardhan]

Table: sys_report_users_groups

Column name. group_id

column name :user_id

add simple filter condition by configure dictionary . 

Reference:

kindly have a look on below thread, it has mentioned the solution. 

https://community.servicenow.com/community?id=community_question&sys_id=fa9c83e5db9cdbc01dcaf3231f96...

[Harsh Vardhan · Accepted solution]

Screenshot for reference, 

[hyperjam]

Thanks for help!