How to update CMDB CI Computer table via creation a Request from Service Portal ?

[Anuj30]

HI, I want to update the CMDB Ci computer table just by creating a request ticket from Service Portal.

so that attached excel sheet in request ticket will update the Computer table ?

[kkm_23]

Hi Anuj,

To update the cmdb_ci_computer table in ServiceNow by creating a request ticket from the Service Portal, where an attached Excel sheet is used to update the table, you can leverage ServiceNow's Import Sets, Transform Maps, Record Producer, and Flow Designer to automate the process.

1. You can create a Record Producer in the Service Catalog to allow users to submit a request ticket with an Excel file attachment.
2. Then Use an Import Set to load the Excel data into a staging table.
3. Using transform Map, map the staging table data to the cmdb_ci_computer table and transform it to update or insert records.
4. Using flow designer application, you can build a flow to detect the request ticket, process the attached Excel file, and trigger an import process.
5. Please ensure that your excel file follows a consistent format with respect to columns, unique identifier and the reference field.

If you find this answer useful, click on accept solution and if you find this valuable, also click on helpful.

Regards

K**bleep**ish