Where does "Import XML" file go?

Scheb
Kilo Explorer

When an admin uses the "Import XML" menu option in the list header, where does the file they are importing go? Is it written to a table in the SNC app (e.g. sys_attachment), or is it written to the file system (/glide/instances/...), or is it simply written to memory?

More importantly, is there a log of what is/when/who imported - file name, date, username, etc.?

Thanks,

Adam

5 REPLIES 5

myee
Kilo Expert

When you import the XML file, the XML tags will specify which tag and action the XML import will perform. In the attached example, the XML file tag is:



Thus, the XML file will point to the incident table, with an action to INSERT_OR_UPDATE.


Jace Benson
Mega Sage

After a little investigation this is what I find.
There is a table, v_customer_uploads, that seems to have everything you are looking for.
https://instance.service-now.com/nav_to.do?uri=v_customer_uploads_list.do


Additionally I did find it in the scs folder but from there you can't see much about when/who uploaded it.


Wwe have a great many admins in non-prod instances (devs mainly) and alot of those folks use this import xml command to move data around between instances. Because import xml bypasses all the normal biz logic, it's very powerful yet also very easy to screw things up. Hoping someone out there has found an way to audit this command.

I did look at v_customer_uploads but that view is messed up. the created by/updated by reset to current user/time every time we reload the page. sigh... 🙂

Adam