Automated report extraction from servicenow to shared folder

[Ranjith95]

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.

[Hemanth M1]

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 

[Ranjith95]

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.

[Hemanth M1]

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 

[Ravi Chandra_K]

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...