Track management reporter changes..

(0) Share

Report

Posted on by Community Member Microsoft Employee

Anyone have found way to determine who made changes to management reporter table definitions, etc ? or changes that were made. There are tons of table and I haven't started to dive into every table or is there a cheat sheet somewhere.. Thanks.. so far I found

[Reporting].[ControlAudit] - shows report/date time stamp/user id,

[Reporting].[SecuritUser] - shows the user id mapped to a windows name.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Greg Byer 2,586 on at

Like (0)

Report

RE: Track management reporter changes..

Hi Michael,

There isn't a good way to see who made changes in MR. You could use the scripts below to check the row, column, tree and report to see who last made changes to it.

--ROW DEFINTION

SELECT CRM.NAME AS ROWNAME,

CRM.LASTMODIFIEDDATE AS ROWMODIFYDATE,

SU.USERNAME

FROM Reporting.ControlRowMaster CRM

JOIN Reporting.SecurityUser SU

ON CRM.LASTCHANGEDBY = SU.USERID

--COLUMN DEFINTION

SELECT CCM.NAME AS COLUMNNAME,

CCM.LASTMODIFIEDDATE AS COLUMNMODIFYDATE,

SU.USERNAME

FROM Reporting.ControlColumnMaster CCM

JOIN Reporting.SecurityUser SU

ON CCM.LASTCHANGEDBY = SU.USERID

--TREE DEFINTION

SELECT CTM.NAME AS TREENAME,

CTM.LASTMODIFIEDDATE AS TREEMODIFYDATE,

SU.USERNAME

FROM Reporting.ControlTreeMaster CTM

JOIN Reporting.SecurityUser SU

ON CTM.LASTCHANGEDBY = SU.USERID

--REPORT DEFINITION

SELECT CRM.NAME AS REPORTNAME,

CRM.LASTMODIFIEDDATE AS REPORTMODIFIYDATE,

SU.USERNAME

FROM Reporting.ControlReport CRM

JOIN Reporting.SecurityUser SU

ON CRM.LastChangedBy = SU.USERID