Is there a good way to automatically export entire records of a particular table daily, and locate them into MID Server or send them by email?

[Aki17]

We have the requirements to automatically export entire records of a particular table on a daily basis.
After that, the exported data should be either automatically located into a folder in MID server, or sent to some administrators via email.

If there is a good way to achieve this kind of challenge, please kindly let me know.

Best Regards,
Aki

[Ankur Bawiskar]

Hi,

yes OOB it is possible.

You can use Scheduled Export Sets to push data daily to mid server location

Schedule an export

Regards
Ankur

[Aki17]

Hi Ankur,

Thank you for the helpful information.

If I set daily export schedule, can the table records be exported as different file?

When I tried that, looks like the exported file in the MID server folder is just 1 and overwritten each time the export schedule runs.

I would like the file to be different ones, but would it be possible?

[Ankur Bawiskar · Accepted solution]

Hi,

you can include timestamp in the file name then it will create new file and won't override

On the export set there is an option

I believe I have answered your question.

please mark my response as correct and close the thread so that it benefits future readers.

Regards
Ankur

[Aniket Sawant2]

Hi, you can write a schedule export.

for more information go through the following docs

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/export-sets/task/t_ScheduleAnExport.html

 for storing data into a mid server you can use following steps

for e.g.

1. Navigate to System Export Sets > Create Export Set to use the simple record producer. Fill in these fields, and click Submit:
   • Name: Maintenance export
   • Select a table: x_hotel_maintenance
   • Select a MID server: midserver (or your MID server name)
   • File path: /

2. Once in the Export Set record, click on Test Export 20 Records. After a few seconds, you should have an export of all the Maintenance records in the export directory in your MID server installation.
3. Click on

Please mark correct or helpful based on an impact

Regards, 

Aniket sawant.