cancel
Showing results for 
Search instead for 
Did you mean: 

Sql

karthickparthib
Level 2
Hi all,

How I can get my stage logging report for each process and log size, no. of line generated for all of my process into SQL.


------------------------------
Thanks in advance,
Karthick Parthiban.
------------------------------
1 REPLY 1

steven.boggs
Staff
Staff
Hi Karthick,

The logging level of a Process is written into a single string of XML stored in the BPAProcess table under the "processxml" column. Parsing this data with a SQL query would likely not be a simple task, but you could work with your DBA to potentially extract this, or others here in the Community may have some SQL they could share that could report on the data you're looking for here.

Edit to add:
In Blue Prism v6.7 and above, there is a built-in report in the System -> Reporting tab's MI Reporting area called "Logging" which displays the number and percentage of stages that are set to high logging levels that may meet your stated requirements here though. In v6.8 and above, the "Runtime Resource Summary" report displays logging levels per Resource. More information about these built-in reports can be found here: https://bpdocs.blueprism.com/bp-6-10/en-us/helpSystemManagerReports.htm?Highlight=Logging

There are also shortcuts to quickly enable or disable logging in the Process Studio under the "Edit All Stages" or "Edit Selected Stages" options. In addition, in v6.6+ of Blue Prism, importing Processes counts the number of logged stages.

------------------------------
Steve Boggs
Senior Software Support Engineer
Blue Prism
Austin, TX
------------------------------