cannot export all roles from sys_user_role table

[mand02]

Hi there,

I am trying to export the sys_user_role table.  In the table there are 1194 records, however when I export I only get 1187 records (note that I am logged on with admin and have Elevated Roles) .  There are obviously some rows that I cannot export due to security constraints but does anyone know how I can find out what these are?

This is for Audit so need an explanation!

Thanks for your help.

Amanda

[Mark Roethof]

sn_hr_core.admin was just an example. There are more plugins that have this way of working. Also it might have been applied on custom applications. We don't know your instance, so can't tell you that in detail. That's up to you.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Mark Roethof]

Hi there,

Any follow-up needed? Or was my answer sufficient?
Let me know.

If your question is solved, please close the topic by marking my answer as correct. This will help others searching for a similar question and will remove the topic from the unsolved list.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[PB7]

If you are in a domain-separated instance:

1. open Settings and change to 'global' Domain

 

2. 'Expand Domain Scope'  [PFA2]

3. Export in whichever preferred format and they all should export given it is an amount within your filetype-defined-default limit 

 

Give a thumbs if this was Helpful.

[Nikita50]

Any update. facing same issue.