THURSDAY, JANUARY 19, 2017

Defining the ‘Run as’ User for a Scheduled Import

Recently I had a client ask me why all of their imported records showed up as being updated and created by the person who initially created the import. The problem, they said, was that the imported records were being created and updated on a scheduled basis by the system so it really wasn’t a particular person who was creating the records. While I agreed that it was a problem, I wasn’t sure at the time why it was happening or what the solution was. Now I know!


It should be no surprise to anybody that each record created or updated in Service-now has some information about who created and last updated the record (along with when those actions occurred). When you’re doing an initial import of data directly through import sets it is accurate for the system to record that the user performing those actions performed the creation and/or update of each of those records.

With a scheduled import however, that same assumption isn’t correct. Generally you would like to have those actions attributed to system behavior rather than the person who set up the scheduled import. Enter the ‘Run as’ field on the ‘Scheduled Import’ table.

By default, this field isn’t part of the Scheduled Import form so you’ll need to personalize your form layout to see it and use it. You’ll notice that this field is automatically populated with the name or ID of the user that is creating the scheduled import record. The value in this field determines which user will run the import and, in turn, what user will be recorded in the ‘Updated by’ and ‘Created by’ fields for each record imported by that schedule.

Since you’ll probably create some sort of dummy or system user for this function, it is important to note that the user account used in the ‘Run as’ field does not have to have any permissions or roles at all to be used as the ‘Run as’ user.

1 Comment

Tom Boone 05-02-2010, 04:07

Well blow me down, that is just too easy! 🙂

Thanks for the info!

Reply

Leave a Reply


Latest Comments

  • David: It appears that I can hit sys_properties table with REST. This works, but I haven’t yet discovered the...
  • Mark Stanger: Hey David, It doesn’t surprise me that scoped apps have made this more difficult. I’m not...
  • David: Mark, do you have an example of how to do this in a scoped app? It seems there are many hoops to jump through...
  • Mark Stanger: The only possibility is to create a system property to override this in your application. Check out the...