Scheduled Data Extract
ServiceNow provides numerous ways of getting data into the system. The import set functionality supports pulling data in from an attachment, FTP(S) servers, JDBC data sources, etc. However, a common problem that many customers have is trying to get data out of their SN instance and into their data center. The simplest way to handle this currently is by having a report emailed to you on a scheduled basis. There has to be a better way!
The good news is that there is a better way. The ‘Scheduled Data Extract’ update set has been designed to allow a user to have reports, tables, or table views sent to a specific directory on a local mid server or FTP to a customer’s FTP/FTPS server on a scheduled basis. The ‘Scheduled Data Extract’ update set has been battle-tested and is used by hundreds of large ServiceNow customers today.
On installation of the Data Extract update set, two new modules will be present within the Reports Application: ‘Scheduled Data Extract’ and ‘Data Extract History’.
How it works
Let’s say you want to have all of your users exported from ServiceNow to a particular computer in your corporate intranet. In this case you want it to end up on a generic Windows XP machine in a certain directory everyday at 12 AM. Once you’ve installed the scheduled data extract, you simply fill out the form in the following manner.
You want to export an incident report to an FTP server every Wednesday at 1 PM. This report should be in CSV format. Since the incident table contains so many fields, you want to limit the export to only include the fields that you’re interested in. This screenshot represents the solution. Notice the View field. This allows you to specify which view you want to use. It is by defining the view that you’re able to specify which fields should be exported.
The ‘Scheduled Data Extract’ update set supports several secure FTP methods. One method that is not supported is SFTP, which commonly confused with FTPS.