How to send a scheduled report (CSV file) to external server from ServiceNow

[sivanagalakshmi]

Hi,

Could someone please help me for below requirement.

I have a report which is there on custom table which needs to schedule on weekly basis and send to external sever.

CSV files need to send to external server.

Thanks,

[Bhuvan]

@sivanagalakshmi 

Did you get a chance to review this as I believe the information provided should resolve your issue.

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Vivek Tirpude1]

Hi Sivanaga,
You can try this approach.

1. Go to Export Sets module

2. Create one report based on your custom table by mentioning date and time (by selecting CSV option)

3. This export set will, export a CSV report file in MID Server folder

4. Now there are 2 ways to send a file to external system.
a) Share the MID Server folder which has CSV file (by going into folder sharing option)

b) Use SFTP client to send CSV file from source location to target location (this will need required permission like IP Address / firewall)

5) After file is shared, please create simple BATCH command file to remove the already shared CSV report file and make space for the new CSV file for next week export.

-----------------------------------------------------------------------------------------------------------------------------------

Simplest way
Send CSV file as attachment is by using Scheduled Reporting.

Hopefully external system is having capability to receive email and download the attachment

_____________________________________________________________________________

If RPA (Automation Anywhere or UI PATH) exists, please check with them for Automate this activity.