Activity report

[BrandonMiller]

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.

[PabloSarabia]

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 :)



​