Is there a way to filter specific Active user accounts from ALL user fields?

[Scott Whitman]

Hello - is there a mechanism to use a Before Business rule query against the sys_user table to keep specific Active accounts from being picked by non-admins?  The existing OOB business rule that filters out active=false for non-admins is on and working fine (i.e. if I deselected active on the accounts that would work). Unfortunately these accounts do need to stay active. They are mostly local ServiceNow accounts that keep getting accidently assigned tickets.

Thanks for any ideas.

[Alp Utku]

I think there is a field called "user type"  on sys_user table which you can use for filtering purposes

[Scott Whitman]

Alp - thank you. Unfortunately not seeing a field called user type.

[Vamsi Sreenivas · Accepted solution]

Hi Scott Whitman,

Yes you can use a query BR to restrict user accounts for users with certain roles. But the easy way I would suggest to create a check box field on sys_user table to indicate that its a locally managed account. And you can add that filter to the reference qualifier if the field where the tickets are getting assigned.

Regards,

Vamsi S

[Scott Whitman]

Vamsi - That worked very well. Created a Local Account field and filtered off that.

Thanks

Scott W