Administrator tools – View logs

Facebooktwittergoogle_pluspinterestlinkedinmail
Applies to version: 8.x; Author: Kamil Nędza

View logs

Using BPS Designer Studio, it is possible to easily view logs directly, without launching SQL Server Management Studio. Using the ‘View logs’ tool is the recommended method of loading and viewing logs, due to the fact that the table containing logs may store them in compressed form – which makes them unable to be viewed in SQL Server Management Studio

Click Tasks -> Administration tools. This will open the administration tools window.

1

Fig.1. ‘View logs’ tool main window

 

The query prompt can be used to enter any query which can obtain appropriate data. By default, the prompt suggests a query which is used to load all logs based on the ID of an action. In the case presented below, the query will return all logs for the workflow element with an ID of 3009:

2

Fig.2. Loading logs for the element with an ID of 3009

 

Clicking “Get data” will load and display log  in table form:

3

Fig.3. Result of loading logs

 

Logs obtained this way can be further narrowed down using the additional filter. In the example below, we narrow down the logs of document ID 3009 to those created after the 24th of February 2016, 15:15:33.

4

Fig.4. Example of the additional filter being used

 

5

Fig.5. Result of loading logs with the additional filter in place

 

The final result can be saved as xls or xlsx spreadsheet  by clicking “Export o Excel”,

6

Fig.6. Exporter window

 

For comparison, here is a query presented in SQL Server Management Studio.

7

Fig.7. Example of log view in SQL Server Management Studio

 

Take a look at the LOG_AdditionalMessage column, which contains information about executed actions. If the message content is long, it will be compressed and the only possibility of viewing it is through WEBCON BPS Designer Studio. The below screenshot shows that logs which show up as NULL in SQL Server Management Studio actually contain values when viewed in Designer Studio:

8

Fig.8. Compressed columns show up normally in WEBCON BPS Designer Studio

 

Compressing historical logs

If you happen to have a considerable amount of historical records, it might be worthwhile to compress them. This will free up disk space to some degree. If the system finds that it contains historical logs, it will display a message informing you that the table contains uncompressed data. Choosing to check the logs will cause the system to verify how many records are uncompressed. Clicking Compress will cause the system to begin compressing logs.

9

Fig.9. After verifying the number of uncompressed logs

 

The screenshots below show how much space can be saved on a small database after compressing 435 records:

10

Fig.10. Space used by the log table before compression


11

Fig.11. Space used by the log table after compression

Leave a Reply

Your email address will not be published. Required fields are marked *