topic RE: Not really. The Archive in Product Forum

How to extract, save and send process logs automatically?

RonAng — Mon, 17 Jul 2017 13:13:00 GMT

Is there a way somewhere in the process or BO, that it extracts the BP process logs then save it to a text or csv file then send it via e-mail?

Not really. The Archive

John__Carter — Mon, 17 Jul 2017 13:25:00 GMT

Not really. The Archive functionality can extract logs to flat files, but it's not designed to be part of a process. In theory you could query the DB directly but that would probably compromise your security model and put your DB at risk. Similarly, sending out potentially sensitive data via email is insecure. The logs are very dense and verbose, and I would question their value to the uninitiated. Maybe a better approach would be to create a bespoke log that 1) you can control the content and 2) access more easily?

RE: Not really. The Archive

SandeepSatish — Mon, 02 Nov 2020 09:49:00 GMT

There is definitely a value in being able to extract the logs. The logs are sent to the process owners and operations team and sent over the SMTP server.
Developer should have visibility of the product runs in order to make sure that the job that they pushed to production runs as expected. Do you know the SQL query that is fired at the DB?

------------------------------
Sandeep Satish
IT Architect
Agilent Technologies
Asia/Kolkata
------------------------------

RE: Not really. The Archive

NicholasZejdlik — Mon, 02 Nov 2020 14:50:00 GMT

This is the SQL query I use for parsing logs, based on session number:

Select 
	seqnum, 
	stagename, 
	processname, 
	pagename, 
	objectname, 
	actionname, 
	Result, 
	startdatetime 
From 
	BPASessionLog_NonUnicode 
Where
	SessionNumber = <session number here>

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: How to extract, save and send process logs automatically?

david.l.morris — Mon, 02 Nov 2020 15:34:00 GMT

Have you considered Data Gateways. I still haven't tested this specifically, but last I saw you could choose to have Data Gateways send to text files. Not sure how flexible it is or anything, but it's something to look into.

Edit: I just noticed this post was resurrected from 2017. So, disclaimer, Data Gateways weren't available back then.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

RE: Not really. The Archive

MayankGoyal2 — Wed, 04 Nov 2020 07:59:00 GMT

@Nicholas Zejdlik - Thanks a lot for sharing the query. Kindly suggest if there is a similar query to monitor log size created within a session? We want to monitor how much log size is one session of process generating to accordingly optimize logs.

------------------------------
Mayank Goyal
------------------------------

RE: Not really. The Archive

NicholasZejdlik — Wed, 04 Nov 2020 15:09:00 GMT

I think this should do it, I adapted from this StackOverflow answer. You may need to switch the table name based on whether or not your logs are unicode (BPASessionLog_NonUnicode vs BPASessionLog_Unicode). You can also join with the BPASession and BPAProcess tables if you would like the process name as well.

Select
sessionnumber,
Sum(
IsNull(DataLength(sessionnumber), 1)
+ IsNull(DataLength(seqnum), 1)
+ IsNull(DataLength(stageid), 1)
+ IsNull(DataLength(stagename), 1)
+ IsNull(DataLength(stagetype), 1)
+ IsNull(DataLength(processname), 1)
+ IsNull(DataLength(pagename), 1)
+ IsNull(DataLength(objectname), 1)
+ IsNull(DataLength(actionname), 1)
+ IsNull(DataLength(result), 1)
+ IsNull(DataLength(resulttype), 1)
+ IsNull(DataLength(startdatetime), 1)
+ IsNull(DataLength(enddatetime), 1)
+ IsNull(DataLength(attributexml), 1)
+ IsNull(DataLength(automateworkingset), 1)
+ IsNull(DataLength(targetappname), 1)
+ IsNull(DataLength(targetappworkingset), 1)
) session_log_size
From
BPASessionLog_NonUnicode
Group By
sessionnumber

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: Not really. The Archive

SaifulKhan — Fri, 03 Jun 2022 07:40:00 GMT

Getting an error when joining to know which process is consuming maximum space. Could you please provide to query to find out which process is logging maxiumum

------------------------------
Saiful Khan
------------------------------