Automated report extraction from servicenow to shared folder

Ranjith95
Tera Contributor

Hi,

 

We would like to extract the reports from service now instance and transfer the reports to shared folder in specified path automatically, any idea or help would be appreciated.

Thanks.

4 REPLIES 4

Hemanth M1
Giga Sage
Giga Sage

Hi @Ranjith95 ,

 

Simple way to try export sets.

 

reference: https://docs.servicenow.com/bundle/xanadu-integrate-applications/page/administer/export-sets/concept... 

 

https://www.youtube.com/watch?v=XV_C5OrHzrk 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Thanks for the response @Hemanth M1 , do we have any alternative way to export the reports to a specified folder path without using a Mid server?

 

Thanks in advance.

Hi @Ranjith95 ,

 

There are other couple of ways but you need have integration hub subscriptions or deep customisation

you can SFTP step if you have integration hub

or Use powershell step in your flow and write scripts 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Ravi Chandra_K
Kilo Patron
Kilo Patron

Hello @Ranjith95,

As Hemanth mentioned, it's Export sets using Mid Server.

 

If you want no Mid Server involvement, the other way I can think is reports can be exported to specific mail box using scheduled reports

 

From that mail box, report can be exported to remote path. This requires microsoft team involvement.

You can find stack overflow reference here.

https://stackoverflow.com/questions/77272478/automate-process-to-send-email-attachment-to-remote-ser...