Update Expire date and Contract Number in CMDB table Asset Record

[surajsukuma]

What is the best way to regularly update the CMDB CI asset serial number and contract number?

We receive data from vendors (Dell, HP) in the form of Excel sheets. The Excel sheets contain serial numbers, contract numbers, expiration dates, etc. Need to match serial number with excel and update filed.

We are looking for an automatic scheduling option instead of manually uploading the data.

Thanks in advance, 

[Vengadeshgiri]

Hi @surajsukuma ,

Create a data source and scheduled data import and attach them to the flow. Send those data sheets as email to instance or create any catalog item to trigger the flow 

Regards

Vengadesh

[surajsukuma]

Thanks, Let me try this option 

[Adrian Ubeda]

Hello @surajsukuma , 

Create a Data Source importing the Excel file (you can select format, source, type...) and then you can automate using a schedule job or Transform map for applying this changes into the target table.