Export Set — Target Path outside MID server path

[rgu]

When setting the target path of an export set, the root of the file path is the "export" folder of the MID server software hierarchy. For example, D:\ServiceNow\prod_midserver\export.

What solutions do you employ for directly telling an export set to place (or copy) the file to a location outside of the MID server software hierarchy? For example, D:\Dropbox.

I do not want to have to rely on a batch file and Windows scheduled task to move/copy files after the fact.

I found this post, but it concerns FTPing the file. I was not sure how to modify it to a file copy.

https://community.servicenow.com/community/blogs/blog/2016/11/22/using-export-sets-transfer-using-sf...

I also found this previous post on the topic, but the person that answered it did not fully understand the question.

https://community.servicenow.com/thread/293571

Thanks for your time.

[Gowrisankar Sat]

Hi rgu,

Export sets generally identifies the target where the file should be placed like the folder you said using "Export Target" field, but as per the suggestion on the export target field on export set record, it says:

The Export Target specifies the file destination such as a location on a MID Server.

But it is configured to only move the file to the location in mid server directory, not anywhere outside the midserver directory:

Check the below link:

File Path

Specify a path relative to the MID Server directory to save the exported data to. The user account used to run the MID Server must have permission to write to this location.

Export target

[rgu]

Right, the out of the box Export Set / Target Path functionality do not provide the option. But, I imagine customers have come up with workarounds or solutions. That is what I'm asking about.

[Raffy]

hi. rgu,

any solution have you found out of this community site?

I totally agree on your point and I am looking for the way to do.

If you have any, please share with me, which will be great?

In fact, my original goal is to backup the subset of tables (saying all tables with _log or/and _audit) out of the ServiceNow to the local file system to keep it for certain period as the reference points who did what etc.

However, I can't find out how to achieve to do the database table backup, rather than exporting to another format anywhere.

So I found this working around using Export Set, and come up the same inquiry as you try to find out.

cheers,

Moon1

[Teja31]

I have created export definition, Export target and export set to send file to a location in mid server and below are the configurations I made.

Mid server name : abc

Folder path I requested: abc/agent/export/test

So, I need to send multiple reports to a folder test shown above. In export target, I added /test in the file path field, and when I tried by exporting 20 records I don't see any file created in test folder.

Is there anything I'm missing in the above process. Also, just want to know which user need to have write permissions to create a files in test folder.

Thanks in Advance!!

Teja