not able to view the inactive users in sys_user table

ranjithkumark19 · ‎10-14-2014

Itil user are not able to view the inactive users in sys_user table also not able to view the caller's details if the caller is inactive. Please any one help to view the inactive users details while login using itil user.

Slava Savitsky · ‎10-14-2014

By default, there is a "before query" business rule on Users [sys_user] table that is called "user query". It prevents anyone except admins from viewing (querying) inactive user records. If you deactivate that rule, your itil users should be able to see inactive users' details.

Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/

View solution in original post

casey_barela1 · ‎01-29-2015

Slava - You have helped me before and this just saved me lots of time. Thanks

praveenKumar2 · ‎03-06-2018

Instead of deactivating that rule, Best way is to add a condition like gs.hasRole('desktop_user') or any specific role or a member of that group.

If service now has given a Business rule, that means there is a particular purpose to it.

ranjithkumark19 · ‎10-15-2014

Hi all thanks for your reply... I got solution from the business rule "user query" from sys_user.

Thanks a lot again..

bianca_vaccarin · ‎10-15-2014

Feel free to mark the correct and helpful answers as you see fit, so others who stumble upon this thread will know which ones worked for you.