Not able to report on sys_user_role and sys_user_has_role table

scottyharris
Kilo Contributor

‎08-07-2017 02:08 AM

Not able to report on sys_user_role and sys_user_has_role table though I have both the tables listed in glide.ui.permitted_tables sys property

Pradeep Sharma's Blog

0 Helpfuls
  • 1,639 Views
2 REPLIES 2

Laxmikanth
Tera Expert

‎08-07-2017 02:29 AM

Hi Scotty,



Please check this thread Reporting on users with roles in groups


0 Helpfuls

Khozema Attar1
Tera Guru

‎08-07-2017 02:35 AM

Hi Scotty,



Can use database views for reporting: http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0



Thanks


0 Helpfuls