Export a report on an ftp server

[pierre_lambercy]

I would like to schedule a report to be posted on an ftp server on daily basis.

Did someone manage to do that?

Currently, the work-around I have is to schedule the distribution of the report via email and then run a script in outlook to detach it automatically on a folder.

[Jacob_Andersen]

Pierre,

I have written a scheduled data export application that is currently on an update set on my demo instance. You can retrieve it by importing the remote udpate set. Here are the details:

url: https://demoja.service-now.com
user: forum
pass: forum
update set: Scheduled Data Extract.

What this update set allows you to do is, on a scheduled basis, export a report to a mid server or to an ftp server. You can choose to have this export overwrite the last export or to create a new one with a timestamp appended.

I hope that you find this helpful.

[pierre_lambercy]

Jacob,

Thanks for that. Based on your description, it's exactly what I need.

2 questions:
- I have remove Mid server as mandatory field (I don't think this is a problem is I use an ftp server)
- Can I put a sftp://57.XX.XX.XXX type of address? (I have tried, so I will keep you posted)

Thanks/Pierre

[Jacob_Andersen]

Pierre,

You'll need to keep the mid server field. You can just choose localhost (in your MID Server field) if your SN instance has visibility to the ftp location that you are wanting to send the report to. You are also free to choose 'MID Server' or 'FTP' as the target. I just checked out the update set and it looks like your only option was 'SSH'. Please add 'MID Server' and 'FTP' as your choices and remove SSH.

Thanks,

-Jake.

[Chuck Tomasi]

Jacob,

I am very much interested in adding this functionality. I installed the update set on my dev system, but do not see any additional apps or modules relating to the new tables. Any basic instructions (e.g. you won't see it until you enable the MID Server plug-in) would be helpful.

Thanks