How to fetch Assets data excel file from SharePoint to ServiceNow Computer table ?

Anuj30
Tera Contributor

yesterday

Hi We want to do the Asset management.

we have to a process to save the Computer data on Sharepoint, and we want to fetch that to Computer table in SN on every 15 days.

 

we want to do this as, we are unable to do it from Intune to SN, as we only have the ITSM professional Subscription, which required some Paid Plugins for such integration.

Please Suggest any process without cost, if we can do the data synch to Computer table (CMDB_ci_Computer)

0 Helpfuls
  • 144 Views
2 REPLIES 2

vaishali231
Kilo Sage

yesterday

Hey @Anuj30 

Yes, this is possible without purchasing additional ServiceNow plugins.

Since your device inventory is already available in SharePoint, you can use SharePoint as the integration source instead of Intune.

A recommended approach is:

  1. Store the computer inventory in a SharePoint List or Excel/CSV file.
  2. Create an Import Set table in ServiceNow.
  3. Retrieve the SharePoint data either through the Microsoft Graph/SharePoint REST API (if available) or by using a CSV/Excel Data Source.
  4. Use a Transform Map to insert/update records in cmdb_ci_computer. Configure coalesce on a unique field such as Serial Number, Asset Tag, or another unique device identifier to avoid duplicate CIs.
  5. Schedule the import (or a Scheduled Script Execution) to run every 15 days.

This approach uses out-of-the-box ServiceNow capabilities (Import Sets, Transform Maps, Scheduled Jobs, and REST APIs) and does not require the paid Intune integration plugins.

If Microsoft 365/Power Automate is available in your environment, you could also automate the export from SharePoint and push the data to ServiceNow via the Table API or Import Set API, making the entire synchronization process fully automated

 

************************************************************************************************************************************

If this response helps, please mark it as Accept as Solution and Helpful.

Doing so helps others in the community and encourages me to keep contributing.

Regards

Vaishali Singh

Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb




0 Helpfuls

Anuj30
Tera Contributor
In response to vaishali231

yesterday

Hi Vaishali,

Appreciate your reply 

but, we don't want to do any manual work. that process you have written, required someone to fetch the data by import setmanually

 

but we need this process Automated, so that data will be fetch from Sharepoint file to SN (we will just update the sharepoint file on sharepoint, and on 15th day all update will fetch to SN )

0 Helpfuls