import assets data in to inventory tables.

[B Ashok]

Hello, 

We would like to provide access to IT Agents to import regular asset details into the ServiceNow Inventory module (Hardware and Consumables).Currently, hardware assets must be added one by one, and there is no option to add them in bulk directly. The only available solution for bulk import is using Import Sets. However, we cannot grant admin access to the IT Agents. Please suggest the best approach to enable IT Agents to import asset details (such as Serial Number, Asset Model, Asset Tag, Asset Name, etc.) without providing them full admin rights.

Thanks

AB

[Dr Atul G- LNG]

Hi @B Ashok 

There is no issue with this. The best approach in ServiceNow is to automate the entire process without any human intervention. Here’s how you can do it: create a source and store the record file (e.g., Excel or CSV) in that location. You can either use a job or the file picker in the File Import Designer to select the file from that location. Then, using import sets and transformation maps, you can bring the data into ServiceNow.

A few things to note:

• Ensure the file is formatted the same way each time, as discrepancies could cause the script to fail and prevent the data from being loaded correctly.

• A check is required once the data is collected to ensure accuracy.

Build the solution in your Dev environment or PDI, and then test the results before moving it to your upper instance.

https://www.servicenow.com/community/developer-forum/automatic-import-sets/m-p/2182933

https://www.servicenow.com/community/developer-forum/script-to-create-an-import-set-and-run-the-tran...

https://www.servicenow.com/community/developer-blog/snmonthlychallenge9-how-to-trigger-scheduled-dat...

[Shivalika]

Hello @B Ashok 

You can just give them "import_admin" or transformer related access. Giving admin access is not necessary. 

We also have same configuration in our system where Local IT Agents are responsible for creating assets and they use import sets.

OR another basic ACL you can create which works with import and give them that role. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY