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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
