Exporting Reports to an SQL Database
DiskPulse Ultimate and DiskPulse Server provide the ability to submit disk change monitoring reports into a centralized SQL database through the ODBC database interface. Reports may be submitted to an SQL database using the main GUI application or the command line utility, which may be used to perform disk monitoring operations on multiple servers or desktop computers and submit all reports to a centralized SQL database.
In addition, customers are provided with a dedicated DiskPulse database server capable of receiving reports from multiple production servers and providing advanced report analysis capabilities. The DiskPulse DB server stores disk change monitoring reports in an SQL database and allows one to define custom report analysis rules and issue E-Mail notifications when critical file system changes are detected.
The report database dialog displays reports that were submitted to the database and allows one to search reports by the report title, host name, date or directories that were monitored. For each report in the database, DiskPulse displays the report date, time, host name, directories that were monitored, the amount of changes and storage space the report refers to and the report title. In order to open a report, just click on the report item in the report database dialog.
In order to connect DiskPulse to an SQL database, the user is required to define an ODBC data source in the computer where DiskPulse is installed on and to specify the ODBC data source in the DiskPulse options dialog. Open the options dialog, select the 'Database' tab, enable the ODBC interface and specify a valid user name and password to connect DiskPulse to an SQL database.
In order to export a report to an SQL database, press the 'Save' button on the results dialog and select the 'SQL Database' format. In addition, the user is provided with the ability to use the command line utility, which is available in DiskPulse Ultimate and DiskPulse Server, to export reports to an SQL database.