- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2022 02:12 PM
What is the role needed to access cmdb_ci_computer table for 'web acess' only account to read? I don't see any ACL for computer table and only see for cmdb_ci. Is it right or am I missing anything? Appreciate it.
In case if they need update to one custom field on cmdb_ci_computer using REST APIS, what would be steps?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2022 02:08 AM
Hello Giri,
You can provide 'cmdb_read' role to provide read access on cmdb_ci_computer table. You are right there is no specific Read ACL on 'cmdb_ci_computer' as ACL present on 'cmdb_ci' table will work for 'cmdb_ci_computer' table too.
To update custom field on 'cmdb_ci_computer', you may need to provide 'itil' role to the user account used for the REST API.
Below are the steps to update field on cmdb_ci_computer using REST API (Inbound Web service)
1) Create Inbound Web service (System web service -> Inbound -> Create new), specify target table as 'cmdb_ci_computer'
2) Create Transform map, Field mappings of custom field to be updated. Mention the coalesce field as well .
3) Staging table will be created and you can provide the Endpoint of staging table to the third party which will call this endpoint to update the custom field (and provide the authentication details as well.)
Hope it helps!!
Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg
Regards
Sulabh Garg

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2022 02:06 AM
Hi,
Try the cmdb_read role, should be enough. If there is no ACLs on the computer table, it means that ACLs on the parent class (cmdb_ci) is applied.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2022 02:08 AM
Hello Giri,
You can provide 'cmdb_read' role to provide read access on cmdb_ci_computer table. You are right there is no specific Read ACL on 'cmdb_ci_computer' as ACL present on 'cmdb_ci' table will work for 'cmdb_ci_computer' table too.
To update custom field on 'cmdb_ci_computer', you may need to provide 'itil' role to the user account used for the REST API.
Below are the steps to update field on cmdb_ci_computer using REST API (Inbound Web service)
1) Create Inbound Web service (System web service -> Inbound -> Create new), specify target table as 'cmdb_ci_computer'
2) Create Transform map, Field mappings of custom field to be updated. Mention the coalesce field as well .
3) Staging table will be created and you can provide the Endpoint of staging table to the third party which will call this endpoint to update the custom field (and provide the authentication details as well.)
Hope it helps!!
Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg
Regards
Sulabh Garg