A few other things to mention: 1) Be aware of field inheritance that occurs when you create a custom table that extends another table. So example, when creating a custom table and you elect to extend from the Task table, your new table starts out with those required fields (as shown in the video), plus all Task fields. This is because your new table is considered a "child" to the Task "parent" table. More documentation about this located here: docs.servicenow.com/csh?topicname=table-extension-and-classes.html&version=latest 2) There are other types of tables that are exempt that I forgot to mention in the video and they are: Many to Many, Remote, Archive, Rotated Table Shards, Document tables. More information can be found in the "Custom Table Guide" link page 3.
Once again I learned something new today, thanks to you. I was under the impression that any tables extending other tables were exempt... and only tables created from scratch were counted as a custom table. As I just finished a story that required me to extend a table not listed in the video - or in your comment - I will make sure to check how many custom tables we currently have and how many we're allowed to have. Thanks again!!
I can see why you'd think that! Glad to hear that the video helped though, I hope it all turns out well and they have proper allocations. Either way, great timing and it's smart of you to check their subscriptions!
Thank you for willing to be vulnerable to share a valuable teaching experience from the past. A lot of your videos cover pertinent issues that noobs like me won't learn from Now Learning or other platforms.
Informative video, got a question what if a customer has ITSM Pro(50 tables) as well as App Engine License(75) and now if we need a scoped app, would the ITSM table allocation be utilized in custom scope for the app? or ITSM tables must have ITSM/Global Scope only? Kind of confused and appreciate if you could provide a response on same. Thanks
Hi, great question! In the purchase order segment of the video when I covered the ITSM Pro App Engine 50 piece, the rest of that sentence said that it was meant for those fulfillers to utilize. Basically, it means, the custom tables allocated per product need to be in support of that product and the same user case (fulfiller) would be the ones who would use that. It doesn’t open the door to a custom app for a completely different purpose. There’s actually separate licensing for that. The App Engine License (75), is most likely what your org purchased for the custom app scenarios. Usually App Engine user licensing is either pay by the user or it’s unrestricted (meaning all users can or could access all custom apps, if applicable). With you all having “75”, it most likely means that you’ll have up to 75 users who could access a or all custom apps. I would try and check your purchase order for specific details or as always, check with the SN account rep for full details!
Thank you for these info , if i didnt watch this video i was about to make same mistake next week 😂 Now i have to check with the client about there licensing Thank you 😄
Hi. If you create a custom table and extend one of the tables shown in the video in the exempt list (or look in the description of the video for a link to the Custom Table Guide - which has that same exempt list on it), then it’s NOT a custom table. It’ll be exempt. If you create a custom table but extend the out of box Task, or Incident, or something like that, then yes, it’s considered custom and counts.
Ah the good old days where we could create all the tables we wanted in the old licence model. We grandfathered all of our old custom tables when they changed the licensing. I had the foresight to create a bunch of generic custom tables before they changed our license, because you can change the columns still afterwards, just can't create new tables outside of an app (unless they are extended from exempt ones). Tip, if you just need to create a custom table for storing matrix data, for example, a junction table for custom routing data, you can just create and M2M first, then add in your extra columns without needing to create any extra custom tables.
Great foresight by you for sure! Also, great tip for everyone to consider when they need a custom table for an obscure reason, leverage an exempt table (such as a M2M) to get around the custom table implication. 👏
Not table related but I created custom ACL rules for a manager who asked her employees have access to certain items, turns out she was trying to circumvent granting them licenses and at the time I didn’t know any better. Thankfully our architect caught it and we cleared them, but I had wondered what would have happened had ServiceNow caught on.
That's a great lesson as well and definitely one that we still come across today. There's talk that "read" access...is "fine" to open up, but when it becomes an issue is when users are becoming "fulfillers" (working the records/being assigned the records), then that tends to be where people try to circumvent things. ServiceNow has specific audits they run for that that don't just look for the literal "itil" type role (for example), but they look at access, what roles are associated with that, who has it, and why. Discussions will come about and you'll either have to increase your fulfiller licenses or change the approach. What I've found that works for me is any time I have a question or am doubtful about a requirement like that...just speak to the account rep.
A few other things to mention:
1) Be aware of field inheritance that occurs when you create a custom table that extends another table. So example, when creating a custom table and you elect to extend from the Task table, your new table starts out with those required fields (as shown in the video), plus all Task fields. This is because your new table is considered a "child" to the Task "parent" table. More documentation about this located here: docs.servicenow.com/csh?topicname=table-extension-and-classes.html&version=latest
2) There are other types of tables that are exempt that I forgot to mention in the video and they are: Many to Many, Remote, Archive, Rotated Table Shards, Document tables. More information can be found in the "Custom Table Guide" link page 3.
This is really helpful and simple and thanks for sharing licenses types
Thanks for sharing your mistake, I've been in similar situation before.
Hi, I’m glad the content resonates with you! Thank you very much for your time spent watching the video and leaving a comment!
Once again I learned something new today, thanks to you.
I was under the impression that any tables extending other tables were exempt... and only tables created from scratch were counted as a custom table.
As I just finished a story that required me to extend a table not listed in the video - or in your comment - I will make sure to check how many custom tables we currently have and how many we're allowed to have. Thanks again!!
I can see why you'd think that! Glad to hear that the video helped though, I hope it all turns out well and they have proper allocations. Either way, great timing and it's smart of you to check their subscriptions!
Thank you for willing to be vulnerable to share a valuable teaching experience from the past. A lot of your videos cover pertinent issues that noobs like me won't learn from Now Learning or other platforms.
You're very welcome. It's viewers and supporters like you that keep me going. Thank you so much!
Informative video, got a question what if a customer has ITSM Pro(50 tables) as well as App Engine License(75) and now if we need a scoped app, would the ITSM table allocation be utilized in custom scope for the app? or ITSM tables must have ITSM/Global Scope only? Kind of confused and appreciate if you could provide a response on same.
Thanks
Hi, great question! In the purchase order segment of the video when I covered the ITSM Pro App Engine 50 piece, the rest of that sentence said that it was meant for those fulfillers to utilize. Basically, it means, the custom tables allocated per product need to be in support of that product and the same user case (fulfiller) would be the ones who would use that. It doesn’t open the door to a custom app for a completely different purpose. There’s actually separate licensing for that. The App Engine License (75), is most likely what your org purchased for the custom app scenarios. Usually App Engine user licensing is either pay by the user or it’s unrestricted (meaning all users can or could access all custom apps, if applicable). With you all having “75”, it most likely means that you’ll have up to 75 users who could access a or all custom apps. I would try and check your purchase order for specific details or as always, check with the SN account rep for full details!
Thank you for these info , if i didnt watch this video i was about to make same mistake next week 😂
Now i have to check with the client about there licensing
Thank you 😄
Haha! Glad I could help! Great job on your part for being open to continuously learning for you to come across this video. That’s a big win!
Nice article. Having a doubt here. If we create a custom table by extending an out of box table. Do we still call it as a custom table?
Hi. If you create a custom table and extend one of the tables shown in the video in the exempt list (or look in the description of the video for a link to the Custom Table Guide - which has that same exempt list on it), then it’s NOT a custom table. It’ll be exempt. If you create a custom table but extend the out of box Task, or Incident, or something like that, then yes, it’s considered custom and counts.
Understood. Thanks. Keep posting such informative videos.
Thank you for your support. It means a lot!
Ah the good old days where we could create all the tables we wanted in the old licence model. We grandfathered all of our old custom tables when they changed the licensing. I had the foresight to create a bunch of generic custom tables before they changed our license, because you can change the columns still afterwards, just can't create new tables outside of an app (unless they are extended from exempt ones).
Tip, if you just need to create a custom table for storing matrix data, for example, a junction table for custom routing data, you can just create and M2M first, then add in your extra columns without needing to create any extra custom tables.
Great foresight by you for sure! Also, great tip for everyone to consider when they need a custom table for an obscure reason, leverage an exempt table (such as a M2M) to get around the custom table implication. 👏
Not table related but I created custom ACL rules for a manager who asked her employees have access to certain items, turns out she was trying to circumvent granting them licenses and at the time I didn’t know any better. Thankfully our architect caught it and we cleared them, but I had wondered what would have happened had ServiceNow caught on.
That's a great lesson as well and definitely one that we still come across today. There's talk that "read" access...is "fine" to open up, but when it becomes an issue is when users are becoming "fulfillers" (working the records/being assigned the records), then that tends to be where people try to circumvent things. ServiceNow has specific audits they run for that that don't just look for the literal "itil" type role (for example), but they look at access, what roles are associated with that, who has it, and why. Discussions will come about and you'll either have to increase your fulfiller licenses or change the approach.
What I've found that works for me is any time I have a question or am doubtful about a requirement like that...just speak to the account rep.
👍👍👍👍👍👍👍👍👍👍👍👍👍👍
Glad you liked the video! Thanks for watching!
@@Allenovation I enjoy your work, You should create more content