Scheduled Data Extract - post report to ftp server

[huma]

Hi,

I have a requirement wherein I am asked the feasibility to send the scheduled reports to ftp server.

Upon doing some investigation I found that there is an update set which if applied enables 2 new modules under Reporting 'Scheduled Data Extract' and 'Data Extract History'.

Can anyone please help me with that update set XML file so that I can implement and verify if that works or any other way which can help me achieve my requirement.

Thanks,

Huma Naaz

[Ankur Bawiskar]

Hi Naaz,

That update set won't be available on wiki or community. You can find that in servicenow share website.

There is one more alternative to that update set as below:

1) Have a mid server setup

2) From Helsinki you can export table as csv or xls to mid server location

3) Write the mid server script include and pick that file from mid server location and send it to ftp server.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

[Josh Cooper]

Depending on what capabilities you have internally at your disposal, you may also just be able to use a scheduled task in Windows or Linux using cURL to retrieve it using REST.   That would obviate the need for a MID Server, since the ftp server would be calling out to the internet using HTTPS.   You would just need a Windows or Linux admin to schedule the task.

[kobby_adu-nti]

Hello Huma,

If you are looking for free applications to fit a particular business requirement, then the place to search for it is the Service Now Share web site:

ServiceNow Share

The Share website is where the Service Now Community posts custom apps, utilities, service portal widgets, and themes. It can be a vital resource for Service Now developers and application creators, as you may often find that someone has had the same idea as you and has made it available on the Share (there is no need to reinvent the wheel). All the content on the Share is available to download for free to anyone who has a Hi user account.

[Ankur Bawiskar]

Hi Naaz,

Any update on this?

Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards

Ankur