Which DB table of BP stores the version history of Process and Object?

[Tejaskumar_Darji]

Hi,

Which DB table of BP stores the version history of Process and Object?

I checked BPAProcess but seems it stores only the latest XML so unable to find older versions.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

[PabloSarabia]

Hi @Tejaskumar_Darji


Check this table: ​BPAAuditEvents.

Here you have all the changes in the platform.

You can join this table with BPAProcess by using the field gTgtProcID

In the Audit Table you have two fields at the end, oldXML and newXML


Hope this helps you!!

See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

[devneetmohanty07]

Hi Tejas,

The BPAAuditEvents along with BPAProcess table would give you the desired information as BPAAudit events stores all the activity trail done on an user account. You can join the two tables using 'processid' and 'gTgProcID' columns:

SELECT [eventdatetime]
      ,[sNarrative]
      ,[gTgtProcID]
      ,[comments]
      ,[EditSummary]
      ,[oldXML]
      ,[newXML]
  FROM [blueprism].[dbo].[BPAAuditEvents] INNER JOIN [blueprism].[dbo].[BPAProcess] 
  ON [blueprism].[dbo].[BPAAuditEvents].gTgtProcID = [blueprism].[dbo].[BPAProcess].processid
  WHERE [newXML] IS NOT NULL

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[lookman]

Hi Devneet.

Thanks for sharing the query. I added BPAProcess.name and BPAProcess.description to the SELECT list to make it easier to recognize which process/object each line represents.

In my environment, I also noticed the column oldXML was always NULL.

Was that your experience as well?

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[devneetmohanty07]

Hi Jack,

Definitely those extra columns would help a lot to identify the processes. I might have removed those due to chunk of data I was seeing on the screen. But that totally is useful to have I agree.

On that [oldXML] column , I exactly have experienced that. At first, I felt was weird but thought maybe it would be something to do specifically with my environment for some reason.

Is there any specific reason for that though, even I am curious to know on that.

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[lookman]

Hi Devneet.

I'll ask around and see if I can find out why that column is NULL.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[lookman]

Hi Devneet.

Apparently, the thought was that "oldXML" was used in Studio for comparing versions but that was not the case. It was "turned off" awhile back to reduce the size of the BPAAuditEvents table.

I don't have an explanation why the column has not been removed from the table but it is not used and so can be ignored.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

[devneetmohanty07]

Thanks a lot Jack for sharing the details with us. It makes sense as XML's would clog up spaces if he processes or objects are large in nature and they gather up quite often down the line.

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[Soumya21]

Hi @Jack Look

Is there any way to enable the turned off "oldxml" in the database 

Thanks,

Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

[Tejaskumar_Darji]

Hi Soumya k

Did not get your question. Can you add bit more details please

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
Technical Lead
------------------------------