Exporting Reports to an SQL Database
DiskPulse Ultimate and DiskPulse Server provide the ability to export detected file system changes to an SQL database via the ODBC database interface. In order to be able to export file system changes to an SQL database, the user need to configure the ODBC database interface on the main options dialog.
In order to configure the ODBC interface, open the main options dialog, select the 'Database' tab, enable the ODBC database interface, enter the ODBC data source name, the ODBC user name and password to use to connect to the SQL database and then press the 'Verify' button to check the specified ODBC interface.
Once finished configuring the ODBC database interface, select one or more detected file system changes, press the right mouse button, select the 'Export Changes to SQL Database' menu item and enter the name of the SQL database table to export changes to. DiskPulse will connect to the specified SQL database and export the selected file system changes to the specified SQL database table.
In order to import file system changes from an SQL database to Microsoft Excel, select the menu 'Data - Import External Data - New Database Query' menu item, select the ODBC data source to import the data from, select the SQL database table name that was specified during the export operation, select SQL database table columns to be imported, optionally select the data sorting mode and press the 'Finish' button.
For each detected file system change, DiskPulse exports to the SQL database the following columns of data: a unique change ID, the date and time of the change, the type of the change (created, modified, renamed or deleted), the size of the file as recorded at the time of the change, the user name of the file owner and the full file or directory name.