REPORT - Who runs the action

[Former Member]

Hi,

I need to make a report containning all the actions made on a user and the user who made this action.

For instance, I need to know WHO creates an account.

Do I have an attribute or a table that store this information?

I try to see into mxp_audit but the colon startedBy is almost always "NULL" and in the colon "changedBy" into mxiv_oentries I find lots of negative values such as -1;-2;-3;-4 instead of mskeys.

An idea?

thanks

[Former Member]

Hi!

I just made a report like yours. first your need to see what a changes there is made by a user.. thats quite easy because thats everything on changed on the user. you could make some union on the mxiv_all_sentries and mxiv_oentries. then for matching them up to a time where they were updated and by whom you should use the valueauditid on mxiv_sentries/oentries and map it to mxp_audit and then use them to se when and by whom made the changes..

That should give you most of it!

[Former Member]

Hi,

To get any date time details for an entry use mxiv_entries view and for log related data use mxp_auditlog.

If any changes to an entry is made from management console using jobs then values for created by are set as -1, -2 etc as you mentioned.

If workflows are used to set any data then user mskey is set to created by.

Edited by: Anup Singh Tomar on Jun 19, 2011 9:55 PM

[Former Member]

That can happen if it was done by an inital load.

But you should see the field "JobID=xxx" then.