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 futureRegards,Devneet MohantyIntelligent Process Automation Consultant | Sr. Consultant - Automation Developer,WonderBotz India Pvt. Ltd.Blue Prism Community MVP | Blue Prism 7x Certified ProfessionalWebsite: 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
----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.