Querying Archived Data

EmmaBurns — Fri, 20 May 2022 09:59:14 GMT

I have been tasked with building some reports on the performance and utilisation of RPA within my business but the issue I have is that once a session has been archived, it's no longer available in the session table.

Is there a way around this? Can I change the archive settings to archive the logs only, leaving the session table complete?

Thanks in advance!

Re: Querying Archived Data

John__Carter — Mon, 23 May 2022 11:50:51 GMT

Hi Emma - archiving sweeps out the session and log tables, and I don't think there is a way to change that. The only workaround I can think of is to report before the archiving takes place, but I suspect you've already considered that one. You can reinstate archived log files back into the DB, but that's a more cumbersome option.

There's a feature called Data Gateways you may want to take a look at. It's a means of pushing logs (and other stuff) to an external data store like Splunk, Elastic or a 3rd party DB. It runs on the app server and would push logs in real time, so before archiving was able to delete them.

topic Querying Archived Data in Product Forum

Querying Archived Data

Re: Querying Archived Data