How to store Schedule Reports on a shared drive (mid-server or other) ?

[J-Paul Millet]

We would like to store existing reports into a shared drive so that:

- the owner of report has the flexibility to update it easily (add / remove columns) 

- we avoid sending reports to many users by email

I'm challenging the "export Set" option that is not flexible enough in our context. I know the scheduled reports are sent by email but I remember , been in front of the same constraint with our legacy PPM tool (some years ago), and it was possible to use a generic email that store the attached file into a folder (I don't know the technical details).  

Do we have a customer having implemented something similar with the Servicenow scheduled reports ?

Thanks

[Saurabh Gupta]

Hi @J-Paul Millet 
Do you have integration hub plugin, if yes here is the solution.
Use OneDrive spoke to share the data over drives.
Integration Hub (servicenow.com)

How To Set Up Microsoft OneDrive Spoke - Support and Troubleshooting (servicenow.com)

Working with Spokes | ServiceNow Developer

Please mark the answer as correct, If I answered your query. It will be helpful for others who are looking for similar questions.

Regards
Saurabh

[J-Paul Millet]

Hi Saurabh,

I will check with our Integration expert, but I think we have the integration hub plugin. 

I'm not an expert on this part but, except if I missed something, I don't see how to "link" it with a scheduled Report. In other words, what do we have to do to ensure the Excel file generated by a Scheduled Report is stored in a specific folder? Thanks again

[Saurabh Gupta]

Hi @J-Paul Millet ,

All attachments are available on email logs that are present on any email generated from ServiceNow. 
PFA.

You can have the logic to get the attachment from that record and send it to a shared folder using integration hub.