Activity report

BrandonMiller — Fri, 18 Feb 2022 20:41:51 GMT

In blue prism is there a way to produce an output report on a server for what all changes have been made by a user? Any help or guidance toward documentation would be greatly appreciated.

Re: Activity report

PabloSarabia — Sat, 19 Feb 2022 08:59:53 GMT

Hi @Brandon Miller

I assume that you want to know what changes have been made by the user inside Blue Prism.

You have table with all the information about the changes. Not only the change in the process, in the entry platform. (Logins and logouts, credential changed, process changed, imported business objects.....)

You can find all of the information in the view "vw_Audit_improved". And, the table that store all this data is "BPAAuditEvents".

In the view I miss an important field, the EditSummary, so, here you have a full query adding this field:

SELECT
BPAAuditEvents.eventdatetime as [Event Datetime]
, BPAAuditEvents.eventid as [Event ID]
, BPAAuditEvents.sCode as Code
, s.username as [By User]
, BPAAuditEvents.sNarrative as Narrative
, BPAAuditEvents.comments as Comments
, BPAAuditEvents.EditSummary AS EditSummary
, t.username as [Target User]
, p.name as [Target Process]
, r.Name as [Target Resource]
FROM BPAAuditEvents BPAAuditEvents
LEFT OUTER JOIN BPAProcess p ON BPAAuditEvents.gTgtProcID= p.processid
LEFT OUTER JOIN BPAUser s ON BPAAuditEvents.gSrcUserID= s.userid
LEFT OUTER JOIN BPAUser t ON BPAAuditEvents.gTgtUserID= t.userid
LEFT OUTER JOIN BPAResource r ON BPAAuditEvents.gTgtResourceID = r.ResourceID
ORDER BY eventdatetime

If you are thinking to get all the change that the user made in the entry server, you will need to use the "Event Viewer" from Windows. You can generate a custom report inside.

Hope this helps you!

See you on the Community, bye 🙂

topic Re: Activity report in Product Forum

Activity report

Re: Activity report