I have a requirement I need to store different applications and associate roles with the application in service now and would also need to associate an Application with an user.
I could see the cmdb_ci_appl table and also the cmdb_rel_user_type, where Application is associated with a user but I don’t see any table or field specific applications associated to roles.
Would need to use a CMDB table
Example :
Service Now is an application and it has multiple roles associated with it like admin, ITIL
Similarly I would have many applications and roles associated with the application as might need to use this data in front end forms /catalogs.
Hence a CMDB table with an application with user relationship and role relationship
Could you suggest what would be the best approach here?
If there is an OOTB form that could accommodate the requirement it would be helpful.
Creating a new table or field should be the last option.
Thanks
