How to create report from User Subscription("user_has_subscription") table

TatsuyaY
Tera Contributor

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?

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

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

View solution in original post

5 REPLIES 5

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