Is it possible share report to shared folder through sftp?

[Nagendra Rao Si]

Hi All,

Is there any possible share report to shared folder access through SFTP?

Please let me know if there is any possible, It could be helpful.

Thanks in advance.

 Best Regards,

Nagendra

[Ahmmed Ali]

Hello @Nagendra Rao Si 

You could you Export set to save data from ServiceNow to any shared folder on your network through MID server.

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/export-sets/concept...

Thank you,

Ali

[Nagendra Rao Si]

Hi @Ahmmed Ali,

Is it not possible share through FTP or SFTP?

Thanks,

Nagendra S 

[Ahmmed Ali]

Hello @Nagendra Rao Si 

We can read data through FTP/SFTP in data source. But not sure if we can send the data.

I would have used export set if the data should be auto-stored in any shared folder. It is OOTB functionality.

Thanks,

Ali

[Amit Gujarathi]

HI @Nagendra Rao Si ,
I trust you are doing great.

Here's a step-by-step guide to implementing the solution:

1. Set up an SFTP server: First, you need to have an SFTP server in place. This server will act as the destination for the shared reports. You can set up an SFTP server using various available options like OpenSSH, FileZilla Server, or similar tools. Follow the documentation or instructions specific to the chosen SFTP server to install and configure it.

2. Create a ServiceNow scheduled job: In ServiceNow, we'll create a scheduled job that runs at specific intervals to generate the reports and upload them to the SFTP server. You can define the schedule based on your requirements. For this example, let's assume a daily schedule.

3. Generate the report: Write a script or use ServiceNow's reporting capabilities to generate the desired report in a format compatible with the SFTP server. This could involve querying the ServiceNow database or using ServiceNow reporting modules. Ensure that the report is generated in a suitable format (e.g., CSV, PDF) that can be easily uploaded to the SFTP server.

4. Implement the SFTP upload: Write a script in ServiceNow to establish an SFTP connection to the server and upload the generated report file. You can use a third-party library like jsch to handle the SFTP functionality.