ScriptRunner Blog

Long-term storage and auditing of PowerShell Reports | ScriptRunner

Written by Frank Kresse | Sep 3, 2016 1:44:56 PM

In ScriptRunner this mainly concerns the corresponding reports for the execution of scripts as well as the corresponding metadata. ScriptRunner uses the integrated SQL Compact database to store reports in the runtime environment. This has limits in capacity, especially for long-term storage.

In ScriptRunner 2016 a function for long-term storage will be available in the form of the Report/Audit DB Connector.

It allows the parallel storage of report and metadata on a SQL server. The implementation also has failure and restart functions. If, for example, the SQL server is not accessible, the transactions are stored locally on the ScriptRunner service backend. Once the database is accessible again, all outstanding reports are written to the long-term database. This ensures that all results of script executions are stored in the long-term memory at all times.

The configuration of the database connection is done by creating a specific registry key; the configuration for the credentials for the database access is done in the ScriptRunner UI.