Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit reporting on report changes, etc.? Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 11:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 10:30 AM
Points: 44, Visits: 99
Hi.

I need to track changes made to reports; when they were created, changed, deleted, moved to another folder in Report Manager, and so on. My first thought was to use Change Data Capture on the ReportServer database, but I can't tell which tables in there store reports or on which tables to capture change data and how to interpret what's in that database in general. Is CDC the best way to go? If so, can someone please help me understand what it needs to monitor? Or is there another approach that is better suited to accomplish this?

Thanks
Post #1450705
Posted Wednesday, May 22, 2013 3:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:36 AM
Points: 2, Visits: 3
Hi,

For performing an easy auditing of the changes that are done in the SQL Server or database objects regarding create, alter, drop, I can recommend you to try in a Lepide's tool which has the ability to perform such operations easily. It tells the information regarding who, what, when, where for all the changes that are done in whether the Database objects or in SQL Server objects. To know more functions you can try and test this tool.
Post #1455392
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse