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

Reports Modified Data Expand / Collapse
Author
Message
Posted Tuesday, October 18, 2011 3:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 4, 2014 10:38 PM
Points: 110, Visits: 637
Hi All,


we have 200 reports and daily one of the reports will be modified as per business requirements so i need to audit which report has been modified
on what date and details like

Report Name
Last modified date
user name

please do the needful ASAP

Post #1191835
Posted Thursday, October 20, 2011 1:22 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:54 AM
Points: 4,427, Visits: 4,172
All that info is in the reportserver database:

USE reportserver
SELECT Name, ModifiedDate, UserName
FROM dbo.Catalog C
JOIN dbo.Users U
ON C.ModifiedById = U.UserID
ORDER BY ModifiedDate


Markus Bohse
Post #1193371
Posted Wednesday, April 9, 2014 11:47 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 9:30 AM
Points: 67, Visits: 342
We have SharePoint with Reporting Services in integrated mode and our ReportServer database does not have a Users table. I checked the SharePoint database and could not find a Users table either. Does anyone know where this ModifiedByID could come from then?
Post #1560115
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse