- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 02:54 AM
I want to create a report that compiles information on how much Subscription is being used by department.
I tried to create report from User Subscription("user_has_subscription") table, but report couldn't create by ACL.
In addition, I checked whether this ACL changed is possible and ACL's application is private so cannot be modified.
How do I create report from User Subscription("user_has_subscription") table ?
Is there no other way to create it from User's role?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-04-2024 02:56 AM
Won't it work by just creating a new report_view ACL on the table?
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Hi @Mark Manders ,
I am not sure how it worked for @TatsuyaY , but I did add a new report_view ACL on the table, but still it does not work. I believe user_has_subscription table is protected by the ACL and role required is 'maint' which is an internal role in ServiceNow, not meant for customers. The table is protected by design, to prevent misuse is what I understand.
That said, if you think there is some other way or something is incorrect in what I mentioned above, please feel free to update.
Thanks,
Gopi
